Hi everybody,

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

Hi,

The process for AP invoice program is as follows:

Excel Sheet -> Data file -> SQL Loader (Control file) -> Staging Tables -> Run Validation program -> Interface Tables -> Run the Payables Open Invoice Import Program -> Base Tables

Staging tables:
Create a custom staging table XX_AP_INVOICE_INTERFACE, XX_AP_INVOICE_LINES_INTERFACE which should be same as seeded interface table AP_INVOICES_INTERFACE and AP_INVOICE_LINES_INTERFACE.

Interface Tables:
1. AP_INVOICES_INTERFACE
2. AP_INVOICE_LINES_INTERFACE

Base Tables:
1. AP_INVOICES_ALL
2. AP_INVOICE_DISTRIBUTIONS_ALL
3. AP_PAYMENT_SCHEDULES_ALL

Process Flow:
-----------------
1. Excel sheet template is prepared which contains all the columns in AP_INVOICES_INTERFACE and AP_INVOICE_LINES table.
2. Convert the Excel Sheet which contains data to be interfaced given by the user into CSV file format.
3. Format the CSV file so that it contains only the relevant data separated with commas.
4. Rename the CSV into DAT file.
5. Prepare the Control File.
6. Run SQL Loader Script.
7. Check the Log file for any errors. In case of any errors rectify it and re-run the SQL Loader Script.
8. Run the PL/SQL Program to validate staging table data and load to Interface tables.
9. Run the Payables Open Invoice Import Program.
10. Check for the status in the Interface Table.
11. Query for the data in the front-end.

Regards,
Ajay Kunde

can u provide me sample ap invoice data

madhab
email :