Number of Employees (Headcount) on SQWL Reports are Not Correct (Doc ID 1923930.1)

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.

Goal

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.
 

Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms