Retrying to Approve an iStore user and Workflow Error ORA-06502 for JTF_APPR in 11.5.10.2 (Doc ID 1288840.1)

Last updated on MARCH 20, 2016

Applies to:

Oracle iStore - Version 11.5.10.2 and later
Information 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.'

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

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