Error "ORA-01722: invalid number" While Running the Payroll ECC Dashboard
(Doc ID 3054525.1)
Last updated on OCTOBER 20, 2024
Applies to:
Oracle Payroll - Version 12.2.10 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run Payroll ECC Data Load, child process "ECC Run Data Load" fails with the following error.
ERROR
There is an error while trying to ingest data for this load rule pay_gen_ecc_data_load.GET_ECC_DATA_LOAD_INFO with dataset pay-dashboard for job 40,580 There is an error while trying to ingest data for this load rule pay_gen_ecc_data_load.GET_ECC_DATA_LOAD_INFO with dataset pay-dashboard for job 40,580 exception details: java.sql.SQLSyntaxErrorException: ORA-01722: invalid number
The issue can be reproduced at will with the following steps:
1. Login as HRMS Manager responsibility
2. Submit "Payroll ECC Data Load" using below navigation
3. Processes and Reports > Submit Processes and Reports > Single Request
4. The child process "ECC Run Data Load" fails with the above error.
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |