Payables open interface rejections report

Payables open interface rejections report

 

In this post, We will discuss about payables open interface rejections report. This report helps to list all the rejected AP invoices/records which got error out during the Payables Open Interface Import Program. Oracle has given the Payables Open Interface Report to review detailed information for each invoice Payables imports during Payables Open Interface Import. The report has two sections, the Payables Open Interface Audit Report and the Payables Open Interface Rejections report.

Payables open interface rejections report Name

 

Use this report to review detailed information for each invoice Payables imports during Payables Open Interface Import. The report has two sections, the Payables Open Interface Audit Report and the Payables Open Interface Rejections report.

The Audit section lists the total number and amount of invoices that Payables successfully imported. The Rejections section lists invoices that Payables was not able to import and lists the rejection reasons.

Report Submission

Payables automatically generates this report when you submit the Payables Open Interface Import.

Sql scripts for Payables open interface rejections report.

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