My Oracle Support Banner

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 FEBRUARY 25, 2021

Applies to:

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


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

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.



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

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