AP invoice interface error tables in oracle apps r12

AP invoice interface error tables in oracle apps r12

In this post , We will be discuss about the AP invoice interface error tables in oracle apps r12 . We know AP Invoice Interface helps to import the AP Invoices from the External Source to Oracle Payables through AP Invoice interface in oracle apps. Here below , I will try to share the AP invoice interface error tables which do store the Error out Interface records information's and based on that information we do some actions to re process these error records from AP invoice interface error tables in oracle apps r12.

Important AP invoice interface error tables in oracle apps r12

1.AP_INTERFACE_REJECTIONS

 

AP invoice interface tables in oracle apps r12

1.AP_INVOICES_INTERFACE
2.AP_INVOICE_LINES_INTERFACE

Detail SQL scripts Using AP invoice interface error tables in oracle apps r12

Here below is the , detail SQL script which helps to find out the AP invoice interface error 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

AP invoice interface error tables in oracle apps r12