Receiving Workflow Error For Purchase Order (PO) Change Records PORPOCHA (Doc ID 2109300.1)

Last updated on FEBRUARY 03, 2019

Applies to:

Symptoms

When attempting to process a change request, the following error occurs:

ERROR
-----------------------
An Error occurred in the following Workflow.

Item Type = PORPOCHA
Item Key = RESPONSE_383970_338570
User Key =

Error Name = -6512
Error Message = ORA-06512: at line
Error Stack =
Wf_Engine_Util.Function_Call(PO_ReqChangeRequestWF_PVT.PROCESS_CANCEL_ACCEPTANCE, PORPOCHA, RESPONSE_383970_338570, 227409, RUN)

Activity Id = 227409
Activity Label = PROCESS_BUYER_RESPONSE:PROCESS_ACCEPTED_CANCELLATION
Result Code = #EXCEPTION
Notification Id =
Assigned User =

STEPS TO REPRODUCE
----------------------------------
1. Create a requisition in iProcurement and approve it.
2. Autocreate a PO from the requisition and approve it.
3. Submit a change request to cancel a line.
4. Accept and approve the requisition change request.
5. As Buyer approves 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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.