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

name at least five reports in oracle inventory related to transaction ?

3 Answers   Scan Steel,


Explain oracle apps architecture.

0 Answers  


how can develope the po variance and po summary report? with tables mandatory columns and query please?

0 Answers  


what is item status? name the related table.

1 Answers   Scan Steel,


how to change the logo in template dynamically?

2 Answers   Sierra Atlantica,


In unix Schell sript what is very 1st line to be wriiten .

2 Answers   IBM,


In which tables receopt application form Appliy to field Value will come. I know one table i.e, ra_customer_trx.trx_number. Could U please any one tell me other than this except(ra_customer_trx and ar_payment_schedules_all tables). plz mentioned tables_name.Column_name.

0 Answers   KPIT,


How to create a purchase order without a requisition?

0 Answers  


Assume i have three Procedures defined in a Package Spec. I have created the Package Specification. now i create the Package Body by including the three procedures in addition to that i include a fourth procedure which is not included in my Package Spec. I compile the Package Body. Will the Package body Compile ? What will the end result ? what will happen if the execute the package by calling the 4th procedure ?

7 Answers   Satyam,


in procedure how to return a value

2 Answers   Wipro,


What is menu.

2 Answers   Accenture,


Where I can download D2K software?

2 Answers  


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)