Retrying to Approve an iStore user and Workflow Error ORA-06502 for JTF_APPR in 22.214.171.124
(Doc ID 1288840.1)
Last updated on FEBRUARY 03, 2019
Applies to:Oracle iStore - Version 126.96.36.199 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)
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