Unable to Terminate Employee - "APP-PAY-07201: Cannot perform a delete with child rows existing in the future" (Doc ID 566400.1)

Last updated on AUGUST 10, 2017

Applies to:

Oracle Human Resources - Version 11.5.10.2 and later
Information in this document applies to any platform.

Symptoms

When attempting to terminate an employee, the following error occurs:

ERROR
APP-PAY-07201: Cannot perform a delete with child rows existing in the future


Steps to Reproduce Scenario : Termination of employee.
The issue can be reproduced at will with the following steps:

     1. Navigate to end employment form from the people form.

     2. Entered the following dates in termination dates fields
              Notified '20/09/07' Projected 'Blank' Actual '29/10/07
              Last Standard Process '01/11/07' Final Process '29/01/08'
              Entered the following information to Person Type and Assignment Status
              Type ' Ex-Employee' Status 'Terminate Process Assignment'

     3.  press terminate button

     4.  receive error message

 
Steps to Reproduce Scenario : Entering final process date after termination


1. The employee was terminated on 01-JAN-2003.

2. The employee is final processed if and when the employee returns.

3. Now that this person is returning for rehire:
    a. Date track to 01-JAN-2006.
    b. Query the employee.
    c. Choose Others from People form.
    d. Choose End Employment from list.
    e. Enter final process date of 01-JAN-2006 in final process date.
    f. Save.

 

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