ORA-06512: at line 1 occurred in table reset_rel_group_status at location 625 error occurs when process payroll for employee transferred from another payroll

(Doc ID 2414066.1)

Last updated on JUNE 21, 2018

Applies to:

Oracle Fusion Global Payroll Cloud Service - Version 11.12.1.0.0 and later
Information in this document applies to any platform.

Symptoms

On : 11.12.1.0.0 version, Global Payroll

When attempting to process payroll, the following error occurs for employees transferred from one  payroll to another

ERROR
-----------------------
A system error ORA-01422: exact fetch returns more than the requested number of rows

ORA-06512: at "FUSION.PAY_PAYROLL_RUN', line 2207 ORA-06512: at line 1 occurred in table reset_rel_group_status at location 625. Your help desk was notified.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Process Payroll
2. Status ends in error for employees who were transferred from another payroll




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