Wednesday, March 1, 2023

ERP - Import AP Invoice using FBDI files from ERP scheduled Processes

In this post, I will show you how to import payable invoice(zip of invoice header and Line) from ERP scheduled Processes.

Highlevel steps:

  1. Download the invoice file(.zip file which contains ApInvoicesInterface.csv and ApInvoiceLinesInterface.csv) from Oracle enterprise repository.
  2. Upload the file to UCM and submit the process "Load Interface File for Import"
  3. 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.


Follow the below detailed Steps:

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.





Jobs got successfully completed and the invoice got generated. PAYABLE  import report reflecting the invoice created.


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

Featured Post

11g to 12c OSB projects migration points

1. Export 11g OSB code and import in 12c Jdeveloper. Steps to import OSB project in Jdeveloper:   File⇾Import⇾Service Bus Resources⇾ Se...