Fix - Unable To Search a Specific Person record in Responsive UI and Person Management Screen - Fusion HCM



The person record should be present in PER_KEYWORDS and PER_PERSON_TYPE_USAGES_M to be able to search the person record in Person Management


Run below 2 ESS jobs to populate the person records in PER_KEYWORDS and PER_PERSON_TYPE_USAGES_M


1. 'Update Person Search Keywords' process to populate the records in PER_KEYWORDS.

Query to verify the same:

select * from fusion.PER_KEYWORDS where person_id IN
(SELECT person_id
FROM fusion.per_all_people_f
WHERE person_number = '<person_number');

2. 'Correct Employment Data Integrity Issues' with Parameter 'Mode' set to 'Update' from dropdown, to populate records in PER_PERSON_TYPE_USAGES_M

Query to verify the same:

select * from fusion.PER_PERSON_TYPE_USAGES_M where person_id IN
(SELECT person_id
FROM fusion.per_all_people_f
WHERE person_number = '<person_number');

Comments

Popular posts from this blog

Query to get Salary Change details in Fusion HCM

Oracle Fusion HCM - Enhancements to Summary of Changes and History Sections in Redwood Workforce Structures Pages

๐Ÿงพ Streamlining Payroll Operations with Oracle Payroll Activity Center