Answer / jyotiprosad roy

1 Commit in Trigger
2 Avoid Table Mutation Trigger
3 Call of function in select stmt with DML
4 Two program units ( caller and called) with two states of
commit nature

Answer / santosh kumar

Autonomous transactions are independent transactions within parent transaction.

At the time of insertion and updation of records into table which has to pass validation then autonomous transactions used.

Can you differentiate between mediator and osb?

0 Answers  

---

what is meant by bind parameter?

2 Answers   Satyam,

---

What is the use of format trigger?

4 Answers   Cap Gemini, IBM,

---

FLEX FIELDS?

2 Answers  

---

what could be the problem if invoice_id is same in ap_invoices_all and ap_invoices_interface. while the Ord_id , invoice_num, and other things is diffrent .

3 Answers   Infosys, Oracle,

---

---

What is the maximum number of statements that can be specified in a trigger statement?

1 Answers   Oracle,

---

What is the link between AP and GL in oracle apps R/12?

4 Answers   Bosch, Collabera, Synechron,

---

What are file in oracle.

0 Answers   BirlaSoft, IBM,

---

How to create multi-layout reports ? If we have 5 layouts , then how to get into the 4th one ?

3 Answers   IBM,

---

What are the files we submit while your program move to testing instance?

4 Answers   Cap Gemini,

---

What is Formula Column?

4 Answers  

---

How many parameters we can pass through pl/sql program in Oracle apps

4 Answers  

---