RTI FPS Errors With HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-20001 After Applying Patch 16095028
(Doc ID 1528702.1)
Last updated on APRIL 17, 2018
Applies to:Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.
When attempting to run the RTI process(FPS) concurrent request, after applying <Patch 16095028>, the following error occurs.
Out } pyxgpar
Action Parameter PLSQL_PROC_INSERT = Y
Oracle error occurred
ORA-06512: at "APPS.HR_DYNSQL", line 1887
ORA-06512: at "APPS.HR_DYNSQL", line 2414
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 to Reproduce:
The issue can be reproduced at will with the following steps:
1. From UK HRMS Manager responsibility
2. Submit the RTI FPS process as detailed above, with the parameters: First FPS = N, First FPS Date = 1/11/12
3. Review the log file generated
<Patch 16095028> was applied
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!