My Oracle Support Banner

Canadian Legislation Year End Report > RL1 Register Report & Payroll Worker Process Erroring APP-PAY-06859: REP-1401: 'afterpform': Fatal PL/SQL error occurred. ORA-01403: no data found an Error Has Been Detected (Doc ID 2988273.1)

Last updated on NOVEMBER 20, 2023

Applies to:

Oracle HRMS (Canada) - Version 12.2.9 and later
Information in this document applies to any platform.
PYCARLRG Canadian RL1 Register Report

Symptoms

The issue occurs for customer(s) who have upgraded from EBS Oracle Applications 12.1.3 to 12.2 or higher.

When attempting to Submit the 'RL1 Register Report' and spawned 'Payroll Worker Process', which are part of the request set, 'RL1 Register Report CA' failed to run with the below error messages:

ERROR
-----------------------
RL1 Register Report error message:

HR_6859_HRPROC_OTHER_PROC_ERR
APP-PAY-06859: An error has been detected by another process.

Payroll Worker Process error messages:
Enter Password:
REP-1401: 'afterpform': Fatal PL/SQL error occurred.
ORA-01403: no data found

The issue can be reproduced with the following steps:

1. Using the responsibility > : CA Super HRMS Manager or Equilvalent.
2. Navigate to Submit Process and Reports  >  Year end Pre process
3. Submit the Request Set: RL1 Register Report CA with the following parameters:
           a) Reporting Year: 2023
           b) PRE Archived by Year End Processes: Customer's GRE

          


Changes

 Upgrade from 12.1.3 to 12.2 Oracle Applications.

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
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.