A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.
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 |
in order to run utl_file package we need to give any specific path? if yes what is that?where u will run utl_package?
what are the sql attributes?
Tell me some interface tables on ordermangement.
Which is the best website to learn Oracle Apps?
WHAT IS THE USE OF SKIP WHERE U WILL GIVE?
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*/
How many typres of Purchase order and what are those.
WHAT IS THE VIEW IN ORACLE APPS?HOW IS IT CREATED?
when we run payment batch what are the 3 concurrent programs?
What is GLOBAL TEMPORARY TABLE and It's significance ?
what is latest version in reports
How will u register concurrent request ?