OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current Date — 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

OTBI Payroll Reporting - How to Generate Employee Data as of Payroll Period & not Current Date

edited Jan 30, 2024 5:26PM in Reporting and Analytics for HCM 14 comments

We currently have an OTBI report using the Payroll - Payroll Balance Real Time subject area. Currently, if we run this report it pulls in the employee Business Unit as of the date running the report. We added Advanced SQL Clauses in Prefix for SET VARIABLE PARAM_EFFECTIVE_DATE ='@{P_DATE}{@{system.currentTime}[YYYY-MM-DD]}'; so that we can utilize P_DATE to pull in as of effective date. However, even when I change the P_DATE to the Payroll Period Start Date it doesn't change the Business Unit field for the employee. It still defaults to the employee's current Business Unit and not as of the payroll period.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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