Refresh Employee Directory Program Runs with Performance Issues
Last updated on SEPTEMBER 28, 2016
Applies to:Oracle Self-Service Human Resources - Version 12.1 HRMS RUP8 and later
Information in this document applies to any platform.
The "Refresh Employee Directory" concurrent program is causing the PER_EMPDIR_* table partitions to grow indefinitely without reusing space. The job currently slams the system any time it runs, because we have a server with lots of CPU threads.
Steps to Reproduce:
The issue can be reproduced at will with the following steps:
Responsibility: Global HRMS Manager
- Processes and Reports > Submit Processes and Reports
- Select "Single Request" then click Ok
- Run "Refresh Employee Directory", or have scheduled to run
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms