Importing Payables invoices is a common requirement in every Oracle Fusion implementation — especially during data migration or when integrating with external systems like OIC, third-party ERPs, or legacy platforms.
In this post, I’ll walk you through the complete process of importing Payables invoices, including key interface tables, required jobs, and troubleshooting tips.
🧩 Step 1: Load Data into Interface Tables
Before importing, your invoice data must be inserted into the Payables Open Interface Tables:
| Table Name | Purpose |
|---|---|
AP_INVOICES_INTERFACE | Holds invoice header information such as Supplier, Invoice Number, Invoice Date, Amount, etc. |
AP_INVOICE_LINES_INTERFACE | Holds invoice line-level details such as Item, Description, Amount, Distribution Account, Tax, etc. |
These tables act as a staging area where data can be validated before creating invoices in Oracle Payables.
✅ Job Name: Load Interface File for Import (Transfers setup or transaction data files from a user-specified location to the interface tables)
⚙️ Step 2: Submit the “Import Payables Invoices” Job
Once your interface tables are populated, you need to run the Import Payables Invoices ESS job to create invoices in Oracle Payables.
✅ Job Name: Import Payables Invoices (Creates Oracle Fusion Payables invoices from invoice data in the open interface tables)
- Download and fill the data in the Invoice FBDI
- Open Fusion instance and navigate to Tools Menu -> Scheduled Processes
- Click on Schedule New Process
- Submit the Job "Load Interface File for Import"
- Select the import process as "Import Payables Invoices" and click on Upload a new file link and select the zip file generated after filling the data in FBDI file
- After selecting the file click on Submit Button
- Another way of uploading the file is by navigating to File Import and Export in Tools
- Click on Upload button
- Select the zip file and enter the Account as fin/payables/import and then click Save and Close button
- Uploaded file will be shown, this file can then be selected while running the Loader Job
- Below child jobs will be submitted
- Process ID will be populated as Load Interface File for Import Job's Process ID in File Import and Export screen
Below are the tables which stores the data:
- Once all Jobs have been completed, submit the Import Payables Invoices job
- Select the Business Unit, Ledger and Source and submit the Job
- Below jobs will be submitted
- You can check the Import Payables Invoices Report to see the import status of the invoice
- Once this job runs successfully, invoices will move from interface tables into AP_INVOICES_ALL and AP_INVOICE_LINES_ALL
Comments
Post a Comment