Refresh Employee Directory is ot populating tables PER_EMPDIR_PEOPLE and PER_EMPDIR_ASSIGNMENTS
(Doc ID 2629212.1)
Last updated on JANUARY 23, 2020
Applies to:Oracle Self-Service Human Resources - Version 12.1.3 and later
Information in this document applies to any platform.
When running the "Refresh Employee Directory" concurrent,
tables per_empdir_people and per_empdir_assignments are not populated and users cannot find any person when performing a search.
Check for the concurrent log file and noted the following lines which confirm the tables per_empdir_people and per_empdir_assignments are empty while other tables are getting populated:
Total # of records processed for per_empdir_people: 0
Total # of records processed for per_empdir_assignments: 0
Total # of records processed for per_empdir_organizations: nnnn
Total # of records processed for per_empdir_phones: zzzz
Total # of records processed for per_empdir_positions: yyyy
Expected to be able to search for employees when using Employee Directory search functions
The issue can be reproduced at will with the following steps:
1. Run the Refresh Employee Directory with the following parameters:
Refresh Mode: COMPLETE
Refresh Date: DD-MON-YYYY
Source System: PER
Process Multiple Assignments: Y
Refresh Images: Y
2. Check for the concurrent log file
3. Also, no results are returned when performing a search using Employee Directory
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