My Oracle Support Banner

ORA-06502: PL/SQL: NUMERIC OR VALUE ERROR: CHARACTER TO NUMBER CONVERSION (Doc ID 2580324.1)

Last updated on AUGUST 28, 2019

Applies to:

Oracle Credit Management - Version 12.2.5 to 12.2.9 [Release 12.2]
Information in this document applies to any platform.

Symptoms

 Oracle Credit Management - Version 12.2.5 and later

ERROR

-----------------------

ORA-06502: PL/SQL: numeric or value error: character to number conversion

Wf_Engine_Util.Function_Call(ar_cmgt_wf_engine.gather_data_points, ARCMGTAP,6634284, 286012, RUN

Issue 1: Review type: Manual Review
ORA-06502: PL/SQL: numeric or value error: character to number conversion error

Wf_Engine_Util.Function_Call(ar_cmgt_wf_engine.gather_data_points, ARCMGTAP,6634284, 286012, RUN

Issue 2: Review type: ORDER_HOLD
R_CMGT_WF_ENGINE.CALCULATE_SCORE(ARCMGTAP, 781582, Calculate Score )
Wf_Engine_Util.Function_Call(ar_cmgt_wf_engine.calculate_score, ARCMGTAP, 781582, 330846, RUN)

STEPS

-----------------------

The issue can be reproduced at will with the following steps

1. Navigate to Credit Managemnt super user responsibility.
2.Create Credit Application.
3.Credit Review type Manual Review (Issue happening with Review_type:ORDER_HOLD).
4.Run the workflow back process for credit application.
5.Workflow failing with error.


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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.