Canadian Archive Error For Employee Has Two Assignments One Inactive With No Run Results

(Doc ID 2077409.1)

Last updated on APRIL 27, 2017

Applies to:

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


On : 12.1.3 version, Canadian Payroll
Production Instance
When attempting to run  Canadian Payroll Archive Process
the following error occurs for one employee who has one payroll run within this period  without run results.

Error ORA-20001: Error at Step 10 in pay_ca_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

The issue can be reproduced at will with the following steps:
1. Process Payroll and Prepayments for this one employee
2. Run the Canadian Payroll Archive process from beginning of the year
3. See this one employee in error for every archive run this year


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