Number of Employees (Headcount) on SQWL Reports are Not Correct
Last updated on DECEMBER 06, 2016
Applies to:Oracle HRMS (US) - Version 12.1.3 and later
Information in this document applies to any platform.
The number of employees reported for Month1, Month2, and Month3 on the SQWL report do not seem to be correct.
For a semi-monthly payroll, if an employee only gets paid in the second period of the month, they are not included in number of employees for that month.
Also notice that new hires hired during the Bi-Weekly period that includes the 12th of the month are not getting counted (ie. hired on on 8-JUN-2015, in the Bi-Weekly period 8-Jun-15 to 21-Jun-15, with check date 25-Jun-15).
A_SQWL_MONTH2_COUNT, A_SQWL_MONTH3_COUNT, A_SQWL_MONTH1_COUNT all have no value. They seem to be excluded due to the SQWL_MONTH1_ROUTE, SQWL_MONTH2_ROUTE, and/or SQWL_MONTH3_ROUTE routes.
I'm not sure what the significance of the 12th of the month is ... that's hardcoded in the route.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms