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 and later
Information in this document applies to any platform.
ConcurrentProgram:PYCAPYAR - Canadian Payroll Archiver


Canadian Payroll

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


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
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
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_core_utils.pop_message 10

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.




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