My Oracle Support Banner

IE Data Alignment Archive Completes With Error HR_6881_HRPROC_ORA_ERR (Doc ID 2423372.1)

Last updated on JULY 16, 2018

Applies to:

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

Symptoms

IE Data Alignment Archive completes with Error


HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Errors found while archiving employer data.
ORA-06512: at "APPS.HR_DYNSQL", line 1924
ORA-06512: at "APPS.HR_DYNSQL", line 2451
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: Errors found while archiving employer data.
ORA-06512: at "APPS.HR_DYNSQL", line 1924
ORA-06512: at "APPS.HR_DYNSQL", line 2451
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: Errors found while archiving employer data.
ORA-06512: at "APPS.HR_DYNSQL", line 1924
ORA-06512: at "APPS.HR_DYNSQL", line 2451
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. Using IE HRMAS Manager Responsibility
2. Run IE Data Alignment Archive process
3. The process ends in error


Changes

 

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!


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