Answer Posted / anang

Yes We can create a synony for a trigger like this

Create or replace trigger test before insert on emp
begin
dbms_output.put_line('Hi');
end;
Create the trigger in scott schema

and connect to apps schema and create a synonym like this

create public synonym test for scott.test;

or

create synonym test1 for scott.test;

CAN YOU CUSTOMISE THE COUTOMISE CUS_TOP

2090

---

Can you explain the difference between architecture followed in 10g & 11g?

656

---

In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

2460

---

How is choreography different from orchestration?

648

---

What is sca and how is it useful?

658

---

---

1. when we r doing interface/conversion which things u will take care to improve the perfrmonce?(except bulk collect) 2. In conversion,u r loading the data using sql*loader,I dnt want to use sql*loader,& i have millions of records,Id der any way to load the data withing fraction of time considering best performance. 3. When u r doing conversion,taht using sql*loader u r loading data into staging table,u r writing control file bt I dnt want to use sql*loader,when u r creating con prog that time can we pass all values from flat file using paramere,valuset?how? 4. In flat file u got 50 records,out of 50 ,30 records are proceesed & inserted into base table,after taht clien understood that 1 item having wrong name e.g insted of ABC he given DCE, so can we delete?hw?(client permission is der) i have lot of wrong item name randomly spreaded,can we delete it?hw? 5.after doing validation hw u will follow approach to error out records?if i want to send all the error out records to client daily,whats ur approach? 6. In outbound interface is der any way to load the data(large data-millions of records) except UTL_FILE package? 7. what is parsing? 8. In technical doc.s which section will mention?except code? 9. Do u have any idea about code depository tool? 10.whats is performance tunning,DB link? 11, How u will do RMA?

13580

---

What is the concept of soa governance?

766

---

testing tools?

1750

---

How to move the one file from one instance to another instance? And your scripts also?

615

---

please send me forms, xml pulisher questions,answers

1654

---

can we use look up type instead of a pofile option?or valueset?is it possible how?

1783

---

List of all the modules under Manufacturing, Finance and Distribution in oracle applications?

1799

---

Do you know where we can check the status of po?

637

---

Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?

2126

---

What are do's and dont's of Interface?

1905

---