Error at step 19 in pay_ca_payroll_arch.process_actions-ORA-20001, Error at step 7 in pay_ca_payroll_arch.create_child_actions_for_gre-ORA-20001 in the Canadian Payroll Archiver Process (Doc ID 1267064.1)

Last updated on MAY 30, 2017

Applies to:

Oracle HRMS (Canada) - Version 11.5.10.2 and later
Information in this document applies to any platform.
ConcurrentProgram:PYCAPYAR - Canadian Payroll Archiver


Symptoms

Canadian Payroll

When attempting to run the Canadian Payroll Archiver,the following error occurs.

ERROR

p_run_action_id = 70704616
Opened c_employee_details of get_personal_information
pay_ca_payroll_arch.process_actions 500
Error at step 19 in pay_ca_payroll_arch.process_actions-ORA-20001: Error at step 19 in pay_ca_payrol
l_arch.process_actions
pay_ca_payroll_arch.create_child_actions_for_gre 500
Error at step 7 in pay_ca_payroll_arch.create_child_actions_for_gre-ORA-20001: Error at step 19 in pa
y_ca_payroll_arch.process_actions
pay_ca_payroll_arch.action_archive_data 500
Error at step 7 in pay_ca_payroll_arch.action_archive_data-ORA-20001: Error at step 19 in
pay_ca_payroll_arch.process_actions
pay_core_utils.pop_message 10


STEP
The issue can be reproduced at will with the following steps:
1. Process payroll - Payroll run (Generic) concurrent process
2. Run Prepayment's
3. Submit the Canadian Payroll Archiver.

Changes

 

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