A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.
- 1 Answers
- 6235 Views
- Satyam, I also Faced
- E-Mail Answers
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 |
what is the use of anchors?
what is meant by Drill Down in Discoverer report? why it will be use?
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
where the accounting related data is stored ?
What is secuirity's in R12 features.
what is pl/sql table and pl/sql records? what is the use of that?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
How do u identity its name of report?
what is the error you will get if field is referenced in wrong repeating frame?
wht is the use of Xml reports over reports6i?
In hierarchical structure of a database? we have write query from where we should start?
What is the link between AP and GL in oracle apps R/12?
4 Answers Bosch, Collabera, Synechron,
Oracle Apps Technical 
