You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Poor Query Performance of CMP_ASG_SALARY_V

Received Response
11
Views
1
Comments

Summary: A simple query on this view runs 40+ minutes.

We are experiencing poor performance with the CMP_ASG_SALARY_V HCM view. When doing a simple SELECT statement with no WHERE clause, the query runs for 40+ minutes. We only have approximately 20,000 active employees. This is frustrating to our users.  

We submitted an SR to Oracle but can not get them to do anything about it.  It would seem that having the right indexes on appropriate underlying table columns or other performance best practices would be able to improve the performance.

Is anyone else encountering this challenge? 

Version: HCM 24A

Example Query: SELECT * FROM

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!