My Oracle Support Banner

APP-PAY-7201: Cannot Perform A Delete With Child Rows Existing In The Future (Doc ID 2249748.1)

Last updated on OCTOBER 28, 2022

Applies to:

Oracle Payroll - Version 12.1.3 and later
Information in this document applies to any platform.


On : 12.1.3 version, Terminations

When attempting to enter Final Process date for termination 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 future

Action : Clear your changes and remove any future child rows

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

1. Go to People -> Enter and Maintain

2. Query the Employee to Terminate

3. Go to End Employment

4. Fill the Details (including Final Process date) and Terminate

The above error raises.



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.