Payables open interface import errors in Oracle apps r12
In
this post, We will be discuss about Payables open interface import errors
in Oracle apps r12. Payables open interface helps to import the AP invoices
from external application into the Oracle Application system. When we do import
the AP invoices using the Payables Open interface import, then some invoices
got failed or rejected in the payables open interface due to some errors or
reasons. We need to go through the Payables open interface import errors
to process these failed or rejected records in the interface. Oracle has given
the Open Interface Import program to migrate the AP invoices from Payables
interface table into the Oracle application. 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 complete detail about Payables open interface import
errors in Oracle apps r12.
Payables open interface import errors in Oracle apps r12 |
Steps of Payables open interface
1.Prepare the External System data in the form of AP invoice Interface.
2.Insert record in the AP invoice Interface Tables.
3.Run the Payables Open interface Import program to import invoices from AP interface to AP base tables.
These are the two tables of AP Invoice Interface. These tables uses to import AP invoices from External System to the Oracle application.
Payables open interface import errors in Oracle apps r12 |
For example , This is the Invoice Test Data which we got from the External System and how i will insert this Data in these Two Interface tables As Below.
Payables open interface import errors in Oracle apps r12 |
Important Table of Payables open interface import errors in Oracle apps r12
1. AP_INTERFACE_REJECTIONS
Sample scripts to get the Payables open interface import errors in Oracle apps r12
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
Payables open interface import errors in Oracle apps r12 |
0 comments:
Post a Comment