My Oracle Support Banner

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

Last updated on MARCH 25, 2019

Applies to:

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


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

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)

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

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


 Upgrade to 12.2


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

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