RTI FPS Errors With HR_6881_HRPROC_ORA_ERR SQLERRMC ORA-20001 After Applying Patch 16095028 (Doc ID 1528702.1)

Last updated on JULY 11, 2016

Applies to:

Oracle HRMS (UK) - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms


When attempting to run the RTI process(FPS) concurrent request, after applying <Patch 16095028>, the following error occurs.


Find PLSQL_PROC_INSERT
  Out } pyxgpar
Action Parameter PLSQL_PROC_INSERT = Y
Oracle error occurred
Table=pay_population_ranges_pkg.perform_range_creation
sqlno=1642
ORA-20001:
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

Changes

<Patch 16095028> was applied

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms