My Oracle Support Banner

Global_name And Local_name NULL In Per_all_people_f For A Person Record (Doc ID 1485862.1)

Last updated on JULY 12, 2023

Applies to:

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

Symptoms

On Applications 11.5.10.2
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

Changes

 

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
Changes
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.