My Oracle Support Banner

Table Per_all_people_f Doesn't Show Data In APPS Schema And Same Statement Shown Output In HR Schema (Doc ID 2696249.1)

Last updated on JULY 30, 2020

Applies to:

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

Symptoms

On 12.2 version, Patch Application Issues

When attempting to access the Define User form (FNDCAUS)
the following error occurs.

ERROR
-----------------------
APP-FND-01572: Invalid foreign key data was found for this record.
Value:<person_id> for column PERSON_ID does not exist in table &TABLE (VIEW=HR_FNDSCAUS_PERSON_V)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. System Administrator
2. > Security > User > Define
3. Query on user name

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot access employee data from the apps schema where the data is held in HR_FNDSCAUS_PERSON_V

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.