My Oracle Support Banner

MX Payroll Archiver Error Error ORA-20001: Error At Step 34 IN Pay_mx_payroll_arch.archive_code ORA-20001: Unable to Determine the Legal Employer for this employee (Doc ID 2041761.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On Test : 12.2.4 version, Payroll - General

When attempting to run the Payroll archiver. the following error occurs.

ERROR
-----------------------

HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error at step 34 IN pay_mx_payroll_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 34 IN pay_mx_payroll_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 34 IN pay_mx_payroll_arch.archive_code
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3

PYUPIP shows

Entering hr_mx_utility.get_legal_employer-2
Leaving hr_mx_utility.get_legal_employer-2
Leaving hr_mx_utility.get_legal_employer
Entering hr_mx_utility.get_legal_employer
hr_mx_utility.get_legal_employer                                        10
Entering hr_mx_utility.get_legal_employer-2
Error in pay_mx_payroll_arch..arch_pay_action_level_data--20001-ORA-20001: Unable to Determine the Legal Employer for this employee.Please check the setup for the statutory reporting hierarchy
pay_mx_payroll_arch.arch_pay_action_level_data                          90
Error at step 34 IN pay_mx_payroll_arch.archive_code-ORA-20001:
ORA-06512: at "APPS.PAY_MX_PAYROLL_ARCH", line 4681
ORA-20001: Unable to Determine the Legal Employer for this employee. Please check the setup for the statutory reporting hierarchy
pay_core_utils.pop_message



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Payroll Run
2. Run Prepayment
3. Run Payroll Archiver

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!


In this Document
Symptoms
Cause
Solution


This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.