Unable to Rehire Employee After Updating Tax Record. Receive Error APP-PAY-07201: Cannot perform a delete with child rows existing in the future (Doc ID 2049603.1)

Last updated on DECEMBER 06, 2016

Applies to:

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

Symptoms

On : 12.1.3 version, Core Payroll - General

We are not able to rehire an employee because we entered tax information on the employee’s original terminated record.
Oracle will not allow user to remove the tax updates and when we try to change the final process date prior to rehire we get the following error message: cannot perform a delete with child rows existing in future.

APP-PAY-07201: Cannot perform a delete with child rows existing in the future
Cause: You are attempting to do a date effective delete where child rows will exist in the future.
Action: Clear your changes and remove any future child rows.



Steps to Reproduce:
The issue can be reproduced at will with the following steps:



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