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_INVOICES_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
Error table:
1.AP_INTERFACE_REJECTIONS
2.AP_INTERFACE_CONTROLS
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.
Subscribe to:
Post Comments (Atom)
5 comments:
Hi,
I m having a doubt here.What I am facing is that when im running the standard API Payables open interface import program to transfer data from interface table to base table (ap_invoices_all),the data is not getting populated in the base table..Could you tell me the possiblilities as to why it can happen?
HI Dude,
This Blog is simply Rocking.
Those beginers who follow this blog will certainly improve on their own.
And I need a solution for the below issue -- When I select
payables responsibility-->Setup-->set of books-->choose The blocks are in non-query mode. how to make these blocks to query mode.
Once agian my heartful appreciation for ur great effort and contribution to the world of oracle apps.
(You can also send reply to sunil27@in.com)
Hi,
I have a doubt. When im running the standard API Payables open interface import program to transfer data from interface table to base table ,the data is not getting picked up from interface table as the status is not gettng changed. can u suggest me a solution for this.
Can anyone help me out with my Query posted on March 14, 2012 7:10 AM
Post a Comment