Saturday, September 12, 2009

No approver found for Purchase Requisition||Requisition going to INCOMPLETE status

Issue:
Requisition could not be approved and goes to INCOMPLETE status after the final approver approves the requisition.

Symptom:
--Requestor and the final approver gets notification like "No approver found for Purchase Requisition"
--Requisiton goes to INCOMPLETE status.

Facts:
-- Requisition preparer is the manager of his subordinate/requestor.
-- There is a PO setup which restricts preparer from approving his/her own requisitoin.
-- REQAPPRV workflow completes with NO ERROR.
-- Following Events happened,
Preparer/Manager prepared the requisition for his subordinate/requestor and submitted for approval>PR went for requestor/suboridinate approval>Requestor approved the requisition>PR went for Manager of the requestor for approval who is the preparer/owner of the PR>Manager approved the PR>PR could not be approved and remained in INCOMPLETE status

Reason:
This is a standard functionality. There is a setup in PO which restricts the preparer from approving his/her own PO.
Here the Preparer is the manager of the requestor.

Suggested Fix:
Nothing can be done to this requisition. Ask the user to create a new Requisition and submit for approval.

Requisitoin not getting approved || Requisitoin remains in IN PROCESS || User-Defined Exception||Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VE

Issue:
Requisition is not getting approved. It remains in "IN PROCESS" status.

Symptom:
--Requestion remains in IN PROCESS status when viewed in iProc.
--No error notification is generated.

Facts:
1> Preparer and requestor are different persons.
2> Last approver has approved the requisition and has all the authorization limit. But still the requisition is in IN PROCESS status.

Reason:
Requisition is in error in the REQAPPRV workflow at following node,
Node: VERIFY_APPROVER_AUTHORITY
Process:VERIFY_APPROVER_AUTH_APPROVE
Error message:User-Defined Exception
Error stack: Wf_Engine_Util.Function_Call(PO_REQAPPROVAL_ACTION.VERIFY_AUTHORITY, REQAPPRV, ...

Suggested Fix:
Login to Oracle apps>Workflow Administrator>Status monitor>Retry the workflow for the ITEM TYPE:REQAPPRV and for the item key