I'm not having any luck getting the Payables Open Interface Import program picking up my entries.
I need to import a file and load into the interface tables.
I would then like to run Payables Open Interface Import and have those records brought into the main tables.
I have the following insert statements:
INSERT INTO AP_INVOICES_INTERFACE
(
INVOICE_ID,
INVOICE_NUM,
--INVOICE_DATE,
VENDOR_ID,
VENDOR_NAME,
VENDOR_SITE_CODE,
INVOICE_AMOUNT,
INVOICE_CURRENCY_CODE,
TERMS_ID,
CREATION_DATE,
CREATED_BY,
PAYMENT_METHOD_LOOKUP_CODE,
INVOICE_RECEIVED_DATE,
ORG_ID,
--SOURCE,
INVOICE_TYPE_LOOKUP_CODE
,PO_NUMBER
-- ,group_id
)
Values
(
425062, /**** Generated from Sequence Select AP_INVOICES_INTERFACE_S.NEXTVAL FROM Dual*******/
'LMN99934e', /*** Invoice Number for AP_Invoice****/
--'25/NOV/2011', /*** Invoice Creation Date *****/
26381, /*** VENDOR_ID *****/
'Guhring Ltd', /*** VENDOR_NAME ***/
'BIRMINGHAM', /*** VENDOR_SITE_CODE ***/
792.74,
'USD',
10180,
'06/APR/2016',
1130,
'CHECK',
'06/APR/2016',
102,
--'ERS',
'Standard'
,31409 /*** Invoice Type lookup code is "STANDARD ' if INVoice Amount >0 else 'CREDIT'******/
--,'Test1'
);
INSERT INTO AP_INVOICE_LINES_INTERFACE
(
INVOICE_ID,
LINE_TYPE_LOOKUP_CODE,
AMOUNT,
line_number,
DIST_CODE_COMBINATION_ID
)
Values
(
425062,
'ITEM',
792.74,
1,
171451
);
COMMIT;
I then run Payables Open Interface Import from Concurrent Manager.
I do not see the table entries moving along, nor do I see any entry in the ap_interface_rejections table.
The output from Concurrent Manager looks like this:
Report Date: 06-APR-2016 16:00
Page: 1
Payables Open Interface Import Report
Hold Name:
Source Name: Manual Invoice Entry Hold Reason:
Group: GL Date:
Purge: No
Summarize Report N
Report Date: 06-APR-2016 16:00
Page: 2
Payables Open Interface Import Report
Hold Name:
Source Name: Manual Invoice Entry Hold Reason:
Group: GL Date:
Purge: No
Summarize Report N
Any help / suggestions would be sincerely appreciated.