In this post, I will show you how to import payable invoice(zip of invoice header and Line) from ERP scheduled Processes.
Highlevel steps:
- Download the invoice file(.zip file which contains ApInvoicesInterface.csv and ApInvoiceLinesInterface.csv) from Oracle enterprise repository.
- Upload the file to UCM and submit the process "Load Interface File for Import"
- Onve the data loaded from the zip file to the interface tables(AP_INVOICES_INTERFACE AND AP_INVOICE_LINES_INTERFACE), run the process "Import Payables Invoices" to load data to bases tables.
Step1: Get the FBDI file from OER (Oracle Enterprise Repository)
https://docs.oracle.com/en/cloud/saas/financials/23a/oefbf/index.html
Download the XLSX template and Generate the CSV files as .zip file.
Step2: Transfer the file to UCM and load the file to Interface tables:
Navigate to Tools >> Scheduled Processes
Step3: Run the payable import job to load the data from interface tables to Base tables.
From Payable >> Invoice page we can also check the created invoice:
Note :
We can also verify the interface table data by running below BI queries:
Select * from AP_INVOICES_INTERFACE order by creation_date desc
Select * from AP_INVOICE_LINES_INTERFACE order by creation_date desc
No comments:
Post a Comment