A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.



A file has both header and corresponding lines. Explain design to load this data into respective in..

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.

Is This Answer Correct ?    3 Yes 1 No

Post New Answer

More Oracle Apps Technical Interview Questions

difference b/w procedures&functions

2 Answers   Oracle, TCS,


I want to print output in portrait style?where i have to change the settings?

2 Answers   Sierra Atlantica,


Could any one tell me the steps of conversions and what kind of validations and exceptions do we use during this conversion? Please do answer in detail. what program do we write in user exit in reports?

3 Answers   iGate,


In oracle application how do you debug or trace errors?

0 Answers  


wheather discard file is automatically created or explicty created?can u mention it?

1 Answers   CTS,






what is the difference between po_vendors & po_headers_all? does po_vendors relate to opeating unit?

2 Answers   CTS,


what type of testing u r doing?

2 Answers   Convergys,


What is instead of trigger in where we will use?

0 Answers  


i have 100 pages output. i want to print 10 records per page in Template?

2 Answers   Sierra Atlantica,


Is there any limitations on responsibility assigned to a apps user?

6 Answers   ESS,


HOW U DISPLAY THE FLEXFIELD DATA IN APPS?

2 Answers  


How to compile the Forms & Reports in Linux Apps Server which are created in WindowsXP client?

1 Answers  


Categories
  • Oracle Apps Technical Interview Questions Oracle Apps Technical (547)
  • Oracle Apps Financial Interview Questions Oracle Apps Financial (793)
  • Oracle Apps Manufacturing Interview Questions Oracle Apps Manufacturing (53)
  • Oracle Apps HRMS Interview Questions Oracle Apps HRMS (169)
  • Oracle Apps CRM Interview Questions Oracle Apps CRM (9)
  • Oracle Apps SCM Interview Questions Oracle Apps SCM (141)
  • Oracle Install Base Interview Questions Oracle Install Base (62)
  • Oracle Service Contracts Interview Questions Oracle Service Contracts (101)
  • Oracle Apps AllOther Interview Questions Oracle Apps AllOther (114)