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

Last updated on FEBRUARY 02, 2024

Applies to:

Symptoms

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)"

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

STEPS:
-----------
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)"

Cause

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