Performance Issue - per_availability_details.Get_availability_details — Cloud Customer Connect
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

Performance Issue - per_availability_details.Get_availability_details

in Reporting and Analytics for HCM 5 comments

We've developed a BI Publisher Report, but it's experiencing performance issues. When run ad-hoc, the report times out (Timeout Error), and when scheduled, it takes over an hour to complete, despite a moderate record count.

The only potential bottleneck I've identified is the use of the per_availability_details.Get_availability_details function in the SQL query.

How can we identify the specific table or join causing performance issues?

I'd appreciate guidance on troubleshooting the root cause of this performance issue

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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