Mexico Year End Archiver: ORA-20001: ERROR AT STEP 4 IN PAY_MX_YREND_ARCH.ARCHIVE_CODE

(Doc ID 1965275.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On Oracle Applications release 12.1, Year End Archiver fails.

  The "Year End Archiver" process status is Completed, however, review of employee no. 621 shows the process failed with error for the GRE employees 'RCA Panindícuaro'.



The issue can be reproduced at will with the following steps:

1. Ran the Year End Archiver
Parameters:
Effective date : 31-DEC-2014
Legal Employee: RCA
Assignment Set : DIM_FARAC and Null



BUSINESS IMPACT
---------------------------
Due to this issue, users cannot issue the Information Declaration Report (DIM) to employees that terminate throughout the year

 

----------------------------------------------------------

 

Verified the issue in the log file as noted below:

See the following error:


MX_YREND_ARCH module: Year End Archiver

***** Processing Ass Id 876 Status 1
Setting error text
declare
begin
  pay_archive.process_employee(:asg_action);
end;

passing asg action = 705406
for assignment id  = 876
Oracle error occurred
Table=pay_archive.process_employee
sqlno=1108
ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_code
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

assignment action rowid = AABC54AAgAAPduxAB4
max errors allowed = 20
errors encountered  = 1
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_code
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

SQL_NO 1108
TABLE_NAME pay_archive.process_employee
APP-PAY-06881: Error ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_code
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Cause:        an oracle error has occurred.  The failure was reported on table pay_archive.process_employee at location 1108 with the error text ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_code
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
.  

Action:        Please contact your support representative.

message text = Error ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_cod
e
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
has occurred in table pay_archive.process_employee at location 1108

Cause:        an oracle error has occ
message level = F,F
payroll_id text = 0
source_id text = 6,705406
line_text = 66, Error ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_co
de
line_text = 43, ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
line_text = 20, ORA-06512: at line 3
line_text = 68,  has occurred in table pay_archive.process_employee at location
1108
line_text = 0,
line_text = 37, Cause:        an oracle error has occ
status error
***** Processing Ass Id 878 Status 1
Setting error text
declare
begin
  pay_archive.process_employee(:asg_action);
end;

passing asg action = 705408
for assignment id  = 878
Oracle error occurred
Table=pay_archive.process_employee
sqlno=1108
ORA-20001: Error at step 4 IN pay_mx_yrend_arch.archive_code
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3


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