Answer / sandeep kumar

Its simple, in all the standard Interface tables there will be some thing a column named header_id, say suppose if you are inserting the header records then you need to provide the header_id in the headers table, In the corresponding child interface tables there will to columns one for the header_id which stores the same header_id which you had provided for the earlier header records and another column for line_id so insert the corresponding lines in the lines table with the same header_id.

what are external tables? how can we use external table instead of sql * loader to load data from flat file to staging table?

1 Answers   IBM,

---

What do you understand by soa and what are the benefits of using this architecture?

0 Answers  

---

In xml report, how to print the headings in every page?

1 Answers   Sierra Atlantica,

---

what is the use of anchors?

2 Answers   IBM,

---

What is INBOUND and OUT BOUND? (Different types of interfaces)

17 Answers   Accenture, Asian Paints, Inbound Solutions, Tech Mahindra,

---

---

How many standard interface programs in oracle purchasing module and oracle inventory? What are they?

3 Answers   KPIT,

---

why do we validate the records while developing interface?

3 Answers   TCS,

---

whats the use of after parameter form and before report?

2 Answers   IBM,

---

Difference between triggers and procedures?

2 Answers  

---

Can we create tables in apps schema?

0 Answers  

---

After execution of a report we get parameter layout where we have enter From_date and To_date.After entering From_date and without entering To_date what happen a report will execute or not?

2 Answers   HCL,

---

where is setup of business group done?

2 Answers   TCS,

---