Geocode Upgrade Manager Spawned Process 'User Defined City Upgrade Process' Errors with 'ORA-01403: no data found'
(Doc ID 2769513.1)
Last updated on AUGUST 21, 2024
Applies to:
Oracle HRMS (Canada) - Version 12.2.9 and laterOracle HRMS (US) - Version 12.2.9 and later
Information in this document applies to any platform.
Symptoms
When attempting to execute the Geocode Upgrade Manager process after installing <patch 31562844>:R12.PAY.C (ANNUAL GEOCODE UPDATE - 2020 FOR RELEASE 12.2),
the spawned process 'User Defined City Upgrade Process', ends with the following error,
ERROR
-----------------------
Oracle error occurred
Table=pay_population_ranges_pkg.perform_range_creation
sqlno=1642
ORA-01403: no data found
ORA-06512: at "APPS.HR_DYNSQL", line 1924
ORA-06512: at "APPS.HR_DYNSQL", line 1888
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
STEPS
--------
1) Navigate:
US Super HRMS Manager > Processes and Reports > Submit Processes and Reports > Single Request > Geocode Upgrade Manager
2) Enter parameter Upgrade Mode: DEBUG or UPGRADE
Changes
Applied <patch 31562844>:R12.PAY.C (ANNUAL GEOCODE UPDATE - 2020 FOR RELEASE 12.2)
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 |