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

what type of testing u r doing?

2 Answers   Convergys,


How to report output like below supplier name date amount abc software jan/11 10000 /* jan month total transactions*/ abc software feb/12 30000 /* feb month total transactions*/ dell computers jan/13 45000 /* jan month total transactions*/

4 Answers   Satyam,


in one report using two layout models.if yes how to do

2 Answers  


How to create a link between One dependent value set to another Dependent value set

5 Answers   Indorama, ManSoft System, Syntel, TE Data,


where we find the status of order information.

2 Answers  


what is pl/sql table and pl/sql records? what is the use of that?

3 Answers   Intelligroup,


Tell me how to find the custom directory in front end?

0 Answers  


Is SOB is attached with Business grp ?

2 Answers   Convergys,


what are the prerequisites for costing transactions?

0 Answers   Scan Steel,


What is cursor?

3 Answers  


What are the files you have used in the part of Conversion and Interfaces?

2 Answers   Tech Mahindra,


Give a brief overview on OrderManagement.

1 Answers   Zensar,


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)