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 11.5.10.2 and laterInformation in this document applies to any platform.
Symptoms
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.
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)
Cause
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
| Symptoms |
| Cause |
| Solution |
| References |