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

Last updated on MAY 19, 2016

Applies to:

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

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

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