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


No comments:

Post a Comment

In how many ways we can link the requisition to purchase order in oracle ebs

 In Oracle E-Business Suite (EBS) R12 / R12.2, a Purchase Requisition can be joined to a Purchase Order across 4 primary levels , depending ...