Import Payables Invoices Process Using LOAD_REQUEST_ID To Query Invoice Lines (Doc ID 2684193.1)

Last updated on SEPTEMBER 11, 2020

Applies to:

Symptoms

Import Payables Invoices process using LOAD_REQUEST_ID to query Invoice lines

Created a ESS job set to automate end-to-end process of extracting Payroll Voluntary Deduction data in AP Invoice FBDI format (CSV files), load into interface tables, and then launch "Import Payables Invoices" to create AP invoices in Payables Cloud. We are using "Load Multiple Interface Files for Import" in the ESS Job Set to load CSV files into AP Invoice interface tables.

ESS job "Import Payables Invoices" is rejecting valid records with "At least one invoice line is required" error message even though corresponding invoice lines exist in the AP_INVOICE_LINES_INTERFACE.

It seems that the program is using both INVOICE_ID & LOAD_REQUEST_ID values to join AP_INVOICES_INTERFACE & AP_INVOICE_LINES_INTERFACE tables (to query invoice lines).

Noticed that "Load Multiple Interface Files for Import" is inserting Process ID of child ESS jobs as LOAD_REQUEST_ID in interface tables so LOAD_REQUEST_ID is different for the records in AP_INVOICES_INTERFACE & AP_INVOICE_LINES_INTERFACE tables. 

However if you manually zip both Header & Lines CSV files and then submit ESS job "Load Interface File for Import", Process ID of “Load Interface File for Import” is inserted as LOAD_REQUEST_ID in both AP_INVOICES_INTERFACE & AP_INVOICE_LINES_INTERFACE tables and passes this validation.

Changes

Cause

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.