RTI FPS Error PYGBFPSXMLGEN Pay_population_ranges_pkg.perform_range_creation ORA-01403 After Applying Patch.27040280TYE18: EDI DECOMMISSIONING CHANGES: FINAL PATCH
(Doc ID 2335390.1)
Last updated on JANUARY 19, 2021
Applies to:
Oracle HRMS (UK) - Version 12.1.3 and laterInformation in this document applies to any platform.
Symptoms
On : 12.1.3 version, UK Payroll
When attempting to run RTI - Full Payment Submission Process (FPS) after applying Patch.27096570 Further EDI Decommissioning changes, XML Output (PYGBFPSXMLGEN)
the following error occurs.
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 1890
ORA-06512: at "APPS.HR_DYNSQL", line 2417
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. RTI - Full Payment Submission Process (FPS) 2017/18 runs fine and can run the EDI version of this output with no issues
RTI - Full Payment Submission Process (FPS) - XML Output (PYGBFPSXMLGEN) ends with error
Changes
Applied Patches:
27096570 Further EDI Decommissioning changes : One Off patch(Patch 27096570:R12.PAY.B)
27040280 TYE18: EDI DECOMMISSIONING CHANGES: FINAL PATCH(Patch 27040280:R12.PAY.B)
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 |