In this post, I will provide you the list of the Interface tables for the AP Invoices import in Oracle cloud fusion and also the corresponding AP Invoice Interface error table.
The Invoices rejection interface table will provide you the Status of the records and the corresponding rejection reason if there are any errors during the Import Process.
Here is the list of the AP Invoice Interface tables in the Oracle fusion :
1. AP_INVOICES_INTERFACE
2. AP_INVOICE_LINES_INTERFACE
These tables will hold the records to be imported into the Oracle fusion. Each of these tables has reject lookup code. And say if there are any rejections or errors in the Interface records, the error records will be stored in the rejections table.
Following is the error/rejection table which will hold the error or the rejected reason for the interface records.
AP_INTERFACE_REJECTIONS
Here is the sample query to pull the error report for the rejected records.
AP Invoice Header - Error Information
SELECT aii.invoice_num ,
aii.invoice_id ,
NULL ,
fbu.bu_name ,
aii.vendor_name ,
aii_error.reject_lookup_code ,
aii.LOAD_REQUEST_ID
FROM ap_invoices_interface aii,
ap_interface_rejections aii_error,
fun_all_business_units_v fbu
WHERE aii_error.parent_id = aii.invoice_id
AND aii_error.LOAD_REQUEST_ID = aii.LOAD_REQUEST_ID
AND aii_error.parent_table = 'AP_INVOICES_INTERFACE'
AND aii.org_id = fbu.bu_id
Here is the sample query to pull the error report for the rejected records for the Invoices lines
AP Invoices Lines - Error Information
SELECT aii.invoice_num ,
aii.invoice_id ,
aili.line_number ,
fbu.bu_name ,
aii.vendor_name ,
aili_err.reject_lookup_code ,
aii.LOAD_REQUEST_ID
FROM AP_INVOICE_LINES_INTERFACE aili,
AP_INVOICES_INTERFACE aii,
AP_INTERFACE_REJECTIONS aili_err,
fun_all_business_units_v fbu
WHERE aili_err.parent_table = 'AP_INVOICE_LINES_INTERFACE'
AND aii.invoice_id = aili.invoice_id
AND aili_err.parent_id = aili.invoice_line_id
AND aili_err.LOAD_REQUEST_ID = aii.LOAD_REQUEST_ID
AND aili.org_id = fbu.bu_id
