User Defined City Upgrade Process Errors with 'ORA-01403: NO DATA FOUND'
(Doc ID 2828890.1)
Last updated on DECEMBER 09, 2022
Applies to:
Oracle HRMS (Canada) - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
When attempting to execute the 'Geocode Upgrade Manager' process after applying patch 2021 Year End Phase 1 patch (33403340)
the subprocess, 'User Defined City Upgrade Process', ends with the following error,
ERROR
-----------------------
SQLERRMC ORA-01403: no data found
ORA-06512: at "APPS.HR_DYNSQL", line 1924
ORA-06512: at "APPS.HR_DYNSQL", line 2451
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 287
ORA-06512: at "APPS.PAY_POPULATION_RANGES_PKG", line 593
ORA-06512: at line 1
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. apply 2021 Year End Phase 1 patch (33403340)
2. CA HRMS Manager > Processes and Reports > Single Request > Geocode Upgrade Manager process
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 |