PORPOCHA: Process Change Acceptance Activity Error ORA-06512 (Doc ID 2243931.1)

Last updated on MARCH 02, 2023

Applies to:

Symptoms

On : 12.2.4 version, Change Order

When attempting to submit a change request on an approved PR (Purchase Requisition) the notification is never sent to the approver and when checking the workflow the following error shows:

ERROR
-----------------------
Item Type = PORPOCHA
Item Key = RESPONSE_1234_5678
User Key =

Error Name = -6512
Error Message = ORA-06512: at line
Error Stack =
Wf_Engine_Util.Function_Call(PO_ReqChangeRequestWF_PVT.PROCESS_CHANGE_ACCEPTANCE, PORPOCHA, RESPONSE_1234_5678, 292320, RUN)

Activity Id = 292320
Activity Label = PROCESS_BUYER_RESPONSE:PROCESS_ACCEPTANCE
Result Code = #EXCEPTION


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Login to iProcurement
2. Navigate to Non-Catalog Request
3. Create a PR from CPA (contract Purchase Agreement)  (Can enter the CPA or supplier name on the contract number)
4. Click View Cart and Check out
5. Fill out Tax Classification code and Billing Information
6. Click Submit
7. PR is routed to the approver and is approved
8. Then, submit a Change Request on the approved PR with Purchase Order
9. Change the Quantity, provide a reason and click Submit
10. Approver does not receive the notification for the Change Request (or if there is a notification and they attempt to approve the error occurs in the workflow)
11. Check the workflow and see the error

Cause

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