Answer / jijo

Global temporary tables are temporary table for perticular session.
Global temporary tables are two types,
1.Transaction wise temporary table
2.Session wise temporary tables.
In transaction wise temporary tables we will use on commit delete rows keyword, which delete the data whenever we do commit.
In session wise temporary table we will use on commit preserve rows keyword, which preserve the data till the end of that session.

Which modules of oracle apps have forms and reports? I am a beginner in oracle apps so kindly answer my query.

3 Answers  

---

can we use commit in trigger? If yes how?

2 Answers   Cap Gemini, TCS,

---

how will you refer a report column (data column,formula,summery,placeholderr)?

1 Answers  

---

Can you define an erp system?

0 Answers  

---

How to link between inventory and OrderManagement.

1 Answers   Zensar,

---

---

How You Will display the key flexifields in your report

3 Answers   TCS,

---

What is the Use of User Exit in Oracle apps and when we are developeing the new report you need to pass one parameter called P_CONC_REQUEST_ID,what is the use of this parameter and is it mandatory.Can't we develop report without this User exit's and P_CONC_REQUEST_ID parameter

12 Answers   TCS,

---

what are the match approvals in PO?

3 Answers  

---

what r the objects u have to do in u experiance

1 Answers  

---

List the types of flexfield?

0 Answers  

---

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.

0 Answers   KPIT,

---

How to pass data into EXECUTE_IMMEDIATE statement in plsql body ?

2 Answers   Oracle,

---