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

A file has both header and corresponding lines. Explain design to load this data into respective interface tables.

1 Answers   Satyam,


where the accounting related data is stored ? all type of accounting related data costing etc...

3 Answers  


why we can use synonym?

6 Answers  


How do you register report in oracle apps?

0 Answers  


What is Summary columns?

1 Answers  






If there is any issue then whom do you report.(this is imp question for every interview)

3 Answers   Accenture,


Is soa a part of oracle fusion middleware?

0 Answers  


in procedure how to return a value

2 Answers   Wipro,


how can we get odd numbered pages in output of a report

2 Answers   Infosys,


when we run payment batch what are the 3 concurrent programs?

1 Answers   Genpact, Wipro,


in GL module specifing org_id or not?

1 Answers  


What is secuirity's in R12 features.

1 Answers   KPIT,


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)