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 DECEMBER 09, 2022
Applies to:
Oracle Human Resources - Version 12.2 HRMS RUP14 and laterInformation 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 |