A file has both header and corresponding lines. Explain
design to load this data into respective interface tables.
Answer Posted / 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 View All Answers
What is instead of trigger in where we will use?
What do you understand by concurrent programs?
Which oracle applications pl/sql standard apis you are familiar, have you used most of them?
Tell me where we find the status of order information?
Can u give the Documentation of Custom.pll in oracle apps
What are the different components of soa suite?
Hi Friends this is preetham, i am searching for job on oracle apps(technical) i put 3 years fake exp, so any one please could you help me for realtime interview questions and 9739782164 this is my no srpsrp777@gmail.Com please guys please provide your no for contact i have a doubts i want to clarify
Do you know what are user profiles in apps. Any examples you can give?
How can we import the data into a database using sql * loader?
In hierarchical structure of a database? we have write query from where we should start?
can we get profile values in report without using user exists is it possible how?
Hi, Anybody please send me the Oracle APPS 1i technical interview questions (Real time) as wel as sample resume also?
can we use look up type instead of a pofile option?or valueset?is it possible how?
what is the differences between internal requisition and internal sales order?
If we have a repeated record in a table. But the repeated record how i can transfer from table to nested table?