Error HR_6881_HRPROC_ORA_ERR, ORA-20001: PAY_33084_LK_INP_VAL_WARN_ERR On Generate Element Links Process (Doc ID 1351151.1)

Last updated on JULY 12, 2016

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

Multiple element links are created in batch mode and all links are in unprocessed status.  While running the process "Generate Element Links" with Generate type parameter = ALL to create the above links an error is received.  There are no mutually exclusive links.

ERROR
-----------------------
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: PAY_33084_LK_INP_VAL_WARN_ERR:
ORA-06512: at "APPS.HR_DYNSQL", line 1863
ORA-06512: at "APPS.HR_DYNSQL", line 2367
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

SQL_NO 1642
TABLE_NAME pay_population_ranges_pkg.perform_range_creation
APP-PAY-06881: Error ORA-20001: PAY_33084_LK_INP_VAL_WARN_ERR:
ORA-06512: at "APPS.HR_DYNSQL", line 1863
ORA-06512: at "APPS.HR_DYNSQL", line 2367
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
has occurred in table pay_population_ranges_pkg.perform_range_creation at location 1642

Cause: an oracle error has occurred. The failure was reported on table pay_population_ranges_pkg.perform_range_creation at location 1642 with the error text ORA-20001: PAY_33084_LK_INP_VAL_WARN_ERR:
ORA-06512: at "APPS.HR_DYNSQL", line 1863
ORA-06512: at "APPS.HR_DYNSQL", line 2367
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.HRMS Administrator responsibility
2. Total Compensation > Basic >Links
3. Create links for multiple elements in batch mode (check "Create batch mode" check box)
4. Run "Create Batch Mode" concurrent program with Generate type parameter = ALL

WORKAROUND
------------------------
- Run the "Create Batch Mode" concurrent program for individual links. However due to high volume of links this may not be possible

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