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

AOR Query Performance Issue

in Reporting and Analytics for HCM

Summary:

Hi Everyone,

Currently, I'm working on a report. The purpose of this report is to retrieve pending records. The main query works fine.

I'm facing an issue with the report parameter query. I created a query in which I get all those employee records whose transfers are in pending status. Furthermore, I also added an AOR clause to the query so the HRBP person would only be able to view their AOR-relevant employee list in the parameter. After adding the AOR clause in query, the running time of the report is about 5 to 7 minutes.

Please guide me if I missed any clauses or conditions that would enhance the performance of this query.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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