Import sql scripts for payables open interface import error table

Import sql scripts for payables open interface import error table

In this post , We will be discuss about the Payables open interface import error tables and the sql script to find out the payable open interface error details. We do call the payable open interface as a AP invoice interface. It helps to import the Payable Invoices from the External Source to Oracle Payables through Open Interface in oracle apps. Here below , I will try to share the Payables Open Interface error tables which do help to store the Errored out records information's and based on that information we do some actions to re process these error records in Payables Open Interface import error tables.

Important payables open interface import error table

1.AP_INTERFACE_REJECTIONS

 

Payables open interface tables

1.AP_INVOICES_INTERFACE
2.AP_INVOICE_LINES_INTERFACE

Detail SQL scripts for payable open interface import error table

Here below is the , detail SQL script which helps to find out the Payables open Interface import errors in both AP Invoice Interface Header and AP Invoice Interface Lines Tables in oracle apps.

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

Import sql scripts for payables open interface import error table