My Oracle Support Banner

REQAPPRV Parallel Approval Subprocess Sporadically Erroring Post-approval ORA-06512: at "APPS.PO_REQAPPROVAL_INIT1" (Doc ID 2855334.1)

Last updated on MARCH 11, 2022

Applies to:

Oracle Contract Lifecycle Management for Public Sector - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.7 version, Requisition

REQAPPRV Parallel Approval Subprocess sporadically erroring post-approval

DETAILS
-----------------------

For CLM iProcurement Requistion approval, when one of the approvers in an AME group approves (parrallel approval process), the very next WF activity "Update Action History (Approve) AME" sporadically errors. It is not consistent.

ERROR
-----------------------
Failed Activity: Update Action History (Approve) AME
Activity Type: Function
Error Name: 100
Error Message = ORA-01403: no data found
  ORA-01403: no data found
  ORA-06512: at "APPS.PO_REQAPPROVAL_INIT1", line 7764
  ORA-06512: at "APPS.POR_AME_REQ_WF_PVT", line 2839
  ORA-01403: no data found
Error Stack =
Wf_Engine_Util.Function_Call(POR_AME_REQ_WF_PVT.UPDATE_ACTION_HISTORY_APPROVE, REQAPPRV, 200398-815989, 317664, RUN)

STEPS
-----------------------
The issue cannot be reproduced at will
1. Go to Purchasing responsibility
2. Create a requisition for approval
3. Submit for approval

Occasionally the error occurs

Changes

 

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
Changes
Cause
Solution
References


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