Getting JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-06502: PL/SQL: numeric or value error When Opening the Statement Of Earnings (SOE) Report from Employee Assignment Processes Form
(Doc ID 3074326.1)
Last updated on FEBRUARY 28, 2025
Applies to:
Oracle HRMS (United Arab Emirates) - Version 12.2 and laterInformation in this document applies to any platform.
Symptoms
When attempting to open the Statement Of Earnings (SOE) Report from Employee Assignment Processes form, it has been observed that the following error message is displayed:
Error Page
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_SOE_UTIL", line 181
ORA-06512: at "APPS.PAY_SOE_UTIL", line 237
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_SOE_UTIL", line 181
ORA-06512: at "APPS.PAY_SOE_UTIL", line 237
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.JboException: JBO-29000: Unexpected exception caught: java.sql.SQLException, msg=ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_SOE_UTIL", line 181
ORA-06512: at "APPS.PAY_SOE_UTIL", line 237
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:886)
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:1009)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
## Detail 0 ##
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error
ORA-06512: at "APPS.PAY_SOE_UTIL", line 181
ORA-06512: at "APPS.PAY_SOE_UTIL", line 237
The issue can be reproduced at will with the following steps:
1. Navigate to AE HRMS Responsibility or equivalent
2. Go to View > Request > Submit a New Request.
3. Run Payroll Process.
4. Go to View > Assignment Process Results > search for one employee.
5. Click on SOE Report tab > the error message is displayed.
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 |