Global_name And Local_name NULL In Per_all_people_f For A Person Record
(Doc ID 1485862.1)
Last updated on AUGUST 11, 2022
Applies to:Oracle Human Resources - Version 188.8.131.52 and later
Information in this document applies to any platform.
On Applications 184.108.40.206
Find there are approximately 48 person records with global_name and local_name null in per_all_people_f table.
-- Expected Behavior
Expect all person records to have a populated global_name and local_name
Ran the following sql to determine the records
select * from per_all_people_f
where global_name is NULL
and current_employee_flag = 'Y'
and trunc(sysdate) between effective_start_date and effective_end_date
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