My Oracle Support Banner

PDRT Check Constraint Program Terminating in the Mid-run (Doc ID 2833259.1)

Last updated on FEBRUARY 02, 2024

Applies to:

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


When running the Check Constraint in Person Data Removal Tool, the program seems to end abruptly even though the concurrent request shows completed successfully. Status of the record show "In Progress (c)"

PDRT Check Constraint Program should not be terminating in the mid-run

1) US Super HRMS Manager
2) Navigate: People>Enter and Maintain
3) Retrieve Empno 111 (Employe Name: ABC)
4) ABC Hire date is 01-JAN-2010
5) Terminate ABC as of 1st Feb 2011
6) Go to Empno 222 (Employee Name: ABC)>> Others>Contact> Add 'ABC' and relationship as Brother, 1st Dec 2009
7) Navigate: System Administrator> Person Data Removal
8) Search for "ABC"
9) Select "ABC" and under Actions select 'Check Constraints' and click Go
10) You will notice "ABC" record "In Progress"
11) However when you click on Last Run ID
12) It shows >> Concurrent request completed successfully
13) However Person Data Removal screen still shows "ABC" as "In Progress (C)"


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.