My Oracle Support Banner

When Attempting to Terminate Employee, "APP-PAY-07201: Cannot perform a delete with child rows existing in the future" Error Occurs (Doc ID 2571374.1)

Last updated on DECEMBER 11, 2023

Applies to:

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


Problem Statement:

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

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 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:

  1.  Login as HRMS Manager responsibility
  2.  Go to terminate form and enter information.
     (N) People > Enter and Maintain > (B) Others > End Employment
  3.  Error occurs when pressing the Terminate button



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.