My Oracle Support Banner

iRecruitment Data Purge Fails To Data Mask The User Details (Doc ID 2525323.1)

Last updated on DECEMBER 05, 2019

Applies to:

Oracle iRecruitment - Version 12.1 HRMS RUP11 and later
Information in this document applies to any platform.
This note provides a brief overview of

Symptoms

Problem Statement:
When there are pending workflow transactions  the purge program is removing the Assignment and Person records , however the FND user account is not removed .

APP-FND-01572:Invalid foreign key data was found for this record. Value xxxx for column PERSON_ID does not exist in table &TABLE (VIEW=HR_FNDSCAUS_PERSON_


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run iRecruitment Purge old Data Concurrent request to purge old Candidate details
2.Query the FND user Account associated with this purged candidate
3.Error

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.