When Enroll Review an Error is displayed : java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error (Doc ID 1299544.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle Learning Management - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

Goal

On : 11.5.10.2 version, Self-Service OTA

When Click on Enroll Review to Post Graduate Diploma Financial Information systems March 2010, the following error occurs.

ERROR
-----------------------
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "SYS.OWA_UTIL", line 354
ORA-06512: at "SYS.HTP", line 1367
ORA-06512: at "SYS.HTP", line 1442
ORA-06512: at "SYS.HTP", line 1734
ORA-06512: at "APPS.ORACLEAPPS", line 1111
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.ICX_SEC", line 3156
ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.HR_UTIL_DISP_WEB", line 3518
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 3644
ORA-20001: The approver identified by the following parameters is invalid:
originating system PER originating-system ID 291.
Please delete or replace this approver wherever they occur in AME data,
including approval groups, list-modification conditions, and substitution actions. This approver does not have an entry in wf_roles.
ORA-06512: at "APPS.HR_DYNAMIC_APPROVAL_WEB", line 7816
ORA-06512: at line 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Personalization Disabled.
1.CDC Learner SS
2.Learner Home
3.subcategories : Post Graduate
4.Courses : Post Graduate Diploma Financial Management
5.Offerings : Post Graduate Diploma Financial Information systems
6.Class Name : Post Graduate Diploma Financial Information systems March 2010
7.Click on Enroll Review to Post Graduate Diploma Financial Information systems March 2010
8.Error Stack is presented.

Solution

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