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

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

In this post , We will be discuss about the AP invoice Interface Error information's. We know , we do use the Invoice interface to import the Payable Invoices from External source to Oracle application but when we do import , then sometime some of those records got rejected due to some errors. We need to know these error information's , so that we can do the required action to fix these rejected records to process again in AP Invoice Header and Lines information. I have designed the sample script , to get the detail error information's for these rejected records in AP invoice Headers and Lines In formations in Oracle apps. Here below i will try to share the sample script to get this detail error information from AP invoice headers and lines information in oracle apps.

Important error table for the sample scripts to get the Detail Error information’s from AP Invoices Headers and Lines

1.AP_INTERFACE_REJECTIONS

AP Invoices Headers and Lines Interface tables

1.AP_INVOICES_INTERFACE
2.AP_INVOICE_LINES_INTERFACE

Detail Sample scripts to get AP Invoices Headers and Lines Interface error information's.

Here below is the , detail SQL script which helps to find out the AP Invoices Headers and Lines 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