Invoice approved but didn't Imported to EBS R12
The following query give the status of the invoice, in our case its REJECTED.
select attribute3,status, i.* from ap_invoices_interface i where attribute3 = 1234;
The following query give the status of the invoice interface, in our case 'DUPLICATE INVOICE_NUM'
SELECT apr.*
FROM ap_interface_rejections apr,
ap_invoices_interface inv
WHERE apr.parent_id = inv.invoice_id
AND inv.status='REJECTED'
and inv.attribute3 in (1234)
--AND inv.source='GLOBAL_INTERCOMPANY'
UNION
SELECT apr.*
FROM ap_interface_rejections apr,
ap_invoices_interface inv,
ap_invoice_lines_interface ln
WHERE apr.parent_id =ln.invoice_line_id
AND ln.invoice_id= inv.invoice_id
AND inv.status='REJECTED'
AND inv.source='GLOBAL_INTERCOMPANY' ;
Solution:
Invoice_num = ABC/Lot8
The query show 2 records with this invoice_num means 1 record was already exist, so this invoice is rejected in import / interface.
I have added 01 at the end of the invoice.
update ap_invoices_interface
set invoice_num='ABC/Lot8)01'
where invoice_id in (1234);
After update rerun the “Payables Open Interface Import” request.
Now the status is changed to "PROCESSED".