Retrying to Approve an iStore user and Workflow Error ORA-06502 for JTF_APPR in 220.127.116.11
Last updated on JUNE 01, 2018
Applies to:Oracle iStore - Version 18.104.22.168 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)
ORA-06502: PL/SQL: numeric or value error: character string buffer too small
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)
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