6 Replies Latest reply on Nov 30, 2017 2:31 PM by user11110762

    PO Number from Invoice Number in KFI flow of AP automation


      Hi Experts,


      I need to write some customization in the Invoice Syncronization composite for which I would need the PO Number. I have the INVOICE_NUM and INVOICE_ID. I tried with the below query:-


      select aia.invoice_num, pha.segment1 PO_Number from ap_invoices_all aia, ap_invoice_lines_all aila, po_headers_all pha

      where aia.invoice_id = aila.invoice_id

      and aila.po_header_id = pha.po_header_id

      and aila.po_header_id is not null

      and aia.invoice_num = :INVOICENUM;


      The problem is that the above query is not working for the KFI flow. Any suggestions?



      Dipankar Banerjee