Wednesday, January 20, 2010

3103: Attribute 'DOCUMENT_ID' does not exist for item 'PORPOCHA/RESPONSE_67359_39381'

Issue:PORPOCHA workflow goes to error at activity "START_PO_APPROVAL" (Launch PO Approval workflow).
This happens in case of PO Change requests for MODIFICATION (Not for cancellation)

Details:
Item type: PORPOCHA
Activity: "START_PO_APPROVAL" (Launch PO Approval workflow)
Item key: RESPONSE_%
WF Error message:3103: Attribute 'DOCUMENT_ID' does not exist for item 'PORPOCHA/RESPONSE_67359_39381'.

Here, the change request gets stuck in the workflow at the node as mentioned above.

The PO status goes to "REQUIRES REAPPROVAL".
Not all the PO change requests (for modification) goes to this condition. Some complete successfully without any error.

Retry does not work in this case. If retried then the workflow remains in the error at the same node but the error message shows "ORA-06512: at line ".

Workaround: Ask the buyer to manually approve the PO.

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