Tuesday, 23 August 2016

Invoice Status Showing as "Needs Revalidation"


First check the Invoice distributions, whether all the lines are accounted or not.
 If all the lines are accounted, then do the below step, otherwise never try this.

 update ap_invoice_distributions_all
set MATCH_STATUS_FLAG ='A'
where invoice_id = :invoice_id
and MATCH_STATUS_FLAG is null


Uploading PO Attachments from EBS to FTP Server

 create or replace PROCEDURE xx_upload_po_attachment(errbuff out varchar2, retcode out number)  IS CURSOR cur_new_attmt IS    select ponumbe...