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 JUNE 17, 2019

Applies to:

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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.