My Oracle Support Banner

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

Last updated on JANUARY 26, 2022

Applies to:

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

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

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
Symptoms
Cause
Solution
References


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