SQL query help needed - Payroll tables — 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
Get Started with Redwood: Oracle Cloud SCM and Purchasing

SQL query help needed - Payroll tables

edited Jun 10, 2021 3:14PM in Reporting and Analytics for HCM 1 comment

Summary

Reporting on those employees who have had a garnishment added in the selected payroll

Content

Hi All,

I hope someone is able to help me out. I am trying to debug a query that was built for us to report on those employees that have a garnishment added to them in the selected payroll. The query has been getting slower for the last couple of pay periods and then this pay period, it gives a time out error.

I am trying to break the query down to see if there are any areas that I could improve performance but so far I haven't seen anything that would help

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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