Search This Blog

invoice approved but didn't imported to ebs

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".