Please guide me about the following requirement.
We need to transfer AP Invoices from an existing 11i apps sytem into a new implementation of 11i.
When we load data into staging tables from an external source the data includes primary keys for the header and detail tables.
We have to validate and transfer the data from staging tables to Interface tables by means of custom code(PL/SQL Interface).
Then the Standard Interface program picks data from Interface tabls and loads Apps Base tables.
But the Standard Interface program generates primary keys for the header and detail tables.
So I wish to know how do we load the Interface tables (with primary keys or with out primary keys).
If we load with out primary keys then how the Standard Interface program establishes relationship between header and detail tables.
Also let me know good Invoice Conversion Strategy.
Thanks and regards