Payables open interface import error table

Payables open interface import error table

In this post, We will discuss about payables open interface import error table. . When we import the AP invoices from the external system to the Oracle system then oracle system validated all those external AP Invoices in the interface table and if some transactions failed in the validations then system put those error or rejected transactions in the payables open interface import error table. In this table we will get the complete information about the payables open interface import error table. Here below is the payables open interface import error table.

 

Payables open interface import error table

AP_INTERFACE_REJECTIONS

 

Sample scripts to get the Detail Error information’s from AP Invoices Headers and Lines.

Import sql scripts for payables open interface import error table

SELECT PARENT_TABLE, REJECT_LOOKUP_CODE, APIR.CREATION_DATE

 FROM APPS.AP_INTERFACE_REJECTIONS APIR

WHERE PARENT_TABLE = 'AP_INVOICES_INTERFACE' AND PARENT_ID IN

                                                               (SELECT INVOICE_ID

                                                                 FROM APPS.AP_INVOICES_INTERFACE

                                                                WHERE INVOICE_NUM = :INVOICE_NUM)

UNION

SELECT PARENT_TABLE, REJECT_LOOKUP_CODE, APIR.CREATION_DATE

 FROM APPS.AP_INTERFACE_REJECTIONS APIR

WHERE PARENT_TABLE = 'AP_INVOICE_LINES_INTERFACE' AND PARENT_ID IN (

                                                               SELECT APILI.INVOICE_LINE_ID

                                                                 FROM APPS.AP_INVOICES_INTERFACE APII,

                                                                   APPS.AP_INVOICE_LINES_INTERFACE APILI WHERE INVOICE_NUM = :INVOICE_NUM

                                                                   AND APILI.INVOICE_ID=APII.INVOICE_ID

                                                               )

ORDER BY CREATION_DATE DESC