Mexico Payroll Archiver Errors With "ORA-20001: Error IN step 14 of pay_mx_payroll_arch.process_actions"
(Doc ID 1116953.1)
Last updated on APRIL 04, 2025
Applies to:
Oracle HRMS (Mexico) - Version 12.1.2 and laterInformation in this document applies to any platform.
MX_PS_ARCHIVE module: Payroll Archiver
Symptoms
On 12.1.1 in Production:
When attempting to run Payroll Archiver the following error occurs
ERROR
-----------------------
Table=pay_archive.process_employee
sqlno=1108
ORA-20001: Error IN step 14 of pay_mx_payroll_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
HR_6881_HRPROC_ORA_ERR
SQLERRMC ORA-20001: Error IN step 14 of pay_mx_payroll_arch.process_actions
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 IN step 14 of pay_mx_payroll_arch.process_actions
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 IN step 14 of pay_mx_payroll_arch.process_actions
ORA-06512: at "APPS.PAY_ARCHIVE", line 1207
ORA-06512: at line 3
.
Action: Please contact your support representative.
PYUPIP shows
Entered get_personal_information
pay_emp_action_arch.initialization_process 10
pay_emp_action_arch.initialization_process 30
pay_emp_action_arch.initialization_process 50
p_assactid = 6930
p_assignment_id = 145
p_curr_pymt_ass_act_id = 6899
p_curr_eff_date = 30-APR-10
p_date_earned =
p_curr_pymt_eff_date = 30-APR-10
p_tax_unit_id = 147
p_time_period_id =
p_run_action_id = 6899
Opened c_employee_details of get_personal_information
Error IN step 14 of pay_mx_payroll_arch.process_actions-ORA-20001:
Error at step 21 IN pay_mx_payroll_arch.archive_code-ORA-20001: Error IN step 14
of pay_mx_payroll_arch.process_actions
pay_core_utils.pop_message 10
pay_assignment_actions_bru 10
pay_assignment_actions_bru 40
pay_payroll_actions_bru 10
pay_payroll_actions_bru
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 |