My Oracle Support Banner

11i: Retrying to Approve an iStore user and Workflow Error ORA-06502 for JTF_APPR (Doc ID 1288840.1)

Last updated on JULY 11, 2022

Applies to:

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


Retrying to Approve a user registration due to earlier failure in Oracle Workflow, again results in the error message:

An unexpected error has occurred in the Approval Workflow for the request with Confirmation Number 12345. 
Please contact your System Administrator if this problem persists.
Note to Administrators: Workflow errors are often caused by temporary database issues, restarting the failed workflow activity may resolve the problem; please see the Workflow documentation for more information.

The following information about the Workflow error is available:

Item Type: JTF_APPR (JTF Approval)
Item Key: 12345
Failed Activity: SELECT_APPROVER (Select Approver)
Assigned To:
Notification Id:
Error Message:

ORA-06502: PL/SQL: numeric or value error: character string buffer too small

Error Stack:

JTF_UM_WF_APPROVAL.SelectorApprover(JTF_APPR, 12345, 166726, RUN)
Wf_Engine_Util.Function_Call(JTF_UM_WF_APPROVAL.SELECTAPPROVER, JTF_APPR, 12345, 166726, RUN)


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.