iProcurement Cancel Line Action in Change Request Gets ORA-06512 in PORPOCHA at PROCESS_CANCEL_ACCEPTANCE When Buyer Accepts the Change (Doc ID 1562923.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle iProcurement - Version 12.1 and later
Information in this document applies to any platform.

Symptoms

Change request, initiated from iProcurement requisition for Cancel Line action, is stuck in pending status after Buyer approves the corresponding PO change order. The workflow shows #EXCEPTION -6512 ~ORA-06512: at line ~ Wf_Engine_Util.Function_Call(PO_ReqChangeRequestWF_PVT.PROCESS_CANCEL_ACCEPTANCE, PORPOCHA

ERROR

process accepted cancel request #EXCEPTION -6512 ~ORA-06512: at line ~ Wf_Engine_Util.Function_Call(PO_ReqChangeRequestWF_PVT.PROCESS_CANCEL_ACCEPTANCE, PORPOCHA, RESPONSE_344981_231316, 156425, RUN)

ERROR DETAILS from the workflow PORPOCHA

Workflow Status for Item_type = 'PORPOCHA' and Item_key = 'RESPONSE_344981_231316' [Top]
Workflow Activity Statuses

Execution Time Begin Date Process Activity Status Result Asg User
605 23-Apr-2013 ROOT Process Buyer's Response ACTIVE #NULL
606 23-Apr-2013 Process Buyer's Response Record buyer's response In Action History COMPLETE ACTIVITY_PERFORMED
608 23-Apr-2013 Process Buyer's Response process rejected request COMPLETE
610 23-Apr-2013 Process Buyer's Response process accepted cancel request ERROR #EXCEPTION

Errored Workflow Activities

Activity Result Error Name Error Message Error Stack
process accepted cancel request #EXCEPTION -6512 ~ORA-06512: at line ~ Wf_Engine_Util.Function_Call(PO_ReqChangeRequestWF_PVT.PROCESS_CANCEL_ACCEPTANCE, PORPOCHA, RESPONSE_344981_231316, 156425, RUN)


Error Handling Process Activity Status

Execution Time Begin Date Process Activity Status Result Asg User
61 23-Apr-2013 ROOT Notify Buyer of PO Change COMPLETE REJECTED
62 23-Apr-2013 Notify Buyer of PO Change Has PO changed after req change submitted? COMPLETE N
64 23-Apr-2013 Notify Buyer of PO Change Record 'Change Submit' In Action History COMPLETE ACTIVITY_PERFORMED
66 23-Apr-2013 Notify Buyer of PO Change Set the PO to IN PROCESS status COMPLETE
68 23-Apr-2013 Notify Buyer of PO Change Set buyer approval notification attributes COMPLETE
70 23-Apr-2013 Notify Buyer of PO Change Notify Buyer of New PO change COMPLETE APPROVE 14942
602 23-Apr-2013 Notify Buyer of PO Change Record buyer's acceptance COMPLETE
604 23-Apr-2013 Notify Buyer of PO Change Launch "Process Buyer's Response" workflow process COMPLETE
605 23-Apr-2013 ROOT Process Buyer's Response ACTIVE #NULL
606 23-Apr-2013 Process Buyer's Response Record buyer's response In Action History COMPLETE ACTIVITY_PERFORMED
608 23-Apr-2013 Process Buyer's Response process rejected request COMPLETE
610 23-Apr-2013 Process Buyer's Response process accepted cancel request ERROR #EXCEPTION
628 23-Apr-2013 Notify Buyer of PO Change Continue Flow COMPLETE #NULL
630 23-Apr-2013 Notify Buyer of PO Change End COMPLETE #NULL


Error Handling Process Errored Activities

Activity Result Error Name Error Message Error Stack
process accepted cancel request #EXCEPTION -6512 ~ORA-06512: at line ~ Wf_Engine_Util.Function_Call(PO_ReqChangeRequestWF_PVT.PROCESS_CANCEL_ACCEPTANCE, PORPOCHA, RESPONSE_344981_231316, 156425, RUN)

 

STEPS TO REPRODUCE
1. Create a requisition in iProcurement and approve
2. Autocreate the requisition onto a PO and approve
3. Submit a change request to cancel line
- See cancellation in the po_change_requests table
4. Accept and approve the requisition change
5. As Buyer approve the PO Change
- See the CHANGE_ACTIVE_FLAG remains as Y in the PO_CHANGE_REQUESTS table, and the PORPOCHA workflow gets the above exceptions after the buyer approved the change / cancel action against the PO



Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms