Approval List could not generated. Please contact your System Administrator to review AME rules setup.

Approval List could not generated. Please contact your System Administrator to review AME rules setup.

Cause:

Additional Requisitions (Cancelled, Incomplete, System Saved) getting inserted while creating PR.

Solution:

Execute the script to reset the Active_Shopping_Cart_Flag to null.

UPDATE po_requisition_headers_all h  

SET active_shopping_cart_flag = null  

WHERE 

h.authorization_status = :Status and 

active_shopping_cart_flag = 'Y' 

AND h.preparer_id in (select employee_id from fnd_user u where u.user_name = UPPER( :user_name ) )  

AND h.org_id =:org_id 

AND h.segment1 =:PR Number