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 MARCH 15, 2022
Applies to:
Oracle iProcurement - Version 12.1 and laterInformation 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)
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
To view full details, sign in with your My Oracle Support account. |
|
Don't have a My Oracle Support account? Click to get started! |
In this Document
| Symptoms |
| Cause |
| Solution |
| References |