Interested to Buy Any Domain ? << Click Here >> for more details...
A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.
- 1 Answers
- 6881 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 |
how can u find the status in po?
Is soa a part of oracle fusion middleware?
wheather discard file is automatically created or explicty created?can u mention it?
IN GL,AP,PO,AR WHICH MODULE DOESNOT HAVE _ALL TABLES THEN WHY?
What is a value set? List its various types.
How to create a link between One dependent value set to another Dependent value set
5 Answers Indorama, ManSoft System, Syntel, TE Data,
what is the data type of lexical parameter?
Steps for DFF registration
In one flat file i got headers and lines data how you can write control file now ?
what is unit of measure classes? give atleast two examples. name the underlying table.
what is the difference between multiorg views and multiorg tables
2 Answers Immense Source, Intelligroup, TCS,
what is difference between d2k report and oracle apps report
10 Answers Seven Hills, Wipro,
Oracle Apps Technical 
