Requisition Approval Completing With Error ORA-06502 (Doc ID 2150343.1)

Last updated on NOVEMBER 22, 2016

Applies to:

Oracle Workflow - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On 12.2.4 version when attempting to approve Requisitions if the approval list cannot be built and No Approver Found notification needs to be sent to the requisition preparer this error occurs

ERROR
-----------------------
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
Wf_Item_Activity_Status.Result(REQAPPRV, 1155923-592688, 11070) Wf_Item_Activity_Status.Root_Status(REQAPPRV, 1155923-592688) WF_ITEM.SetEndDate(REQAPPRV, 1155923-592688) Wf_Item_Activity_Status.Create_Status(REQAPPRV, 1155923-592688, 11070, COMPLETE, NO_APPROVER_AVAILABLE) Wf_Engine_Util.Complete_Activity(REQAPPRV, 1155923-592688, 11070, NO_APPROVER_AVAILABLE) Wf_Engine_Util.Complete_Activity(REQAPPRV, 1155923-592688, 316289, #NULL) Wf_Engine_Util.Execute_Activity(REQAPPRV, 1155923-592688, 316289, RUN)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Submit requisition for approval
2. In this case -- approver does not respond and timeout occurs
3. The supervisor is not available for the approver and approval list cannot build and error occurs when trying to send No Approver Found notification

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot resubmit Reqs when No Approver Found occurs when approval list failure happens

Changes

 Upgrade to 12.2

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