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: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Identify Hire Dates that are any date in the Next Week

edited Jun 2, 2024 4:41PM in Reporting and Analytics for HCM 10 comments

Summary:

I have an OTBI report using subject area Workforce Management - Work Relationship Real Time. On the Advanced tab, I have already entered the prefix SET VARIABLE PARAM_EFFECTIVE_DATE='4712-12-31'; so that it will pick up future dates.

The report runs several times during the week, identifying new hires (Work Relationship Start Dates) that are any date in the NEXT WEEK (Sun - Sat).

FOR EXAMPLE:

If the report runs on Mon 6/3/24, it will pick up Hire Dates that are any date during NEXT week, for example 6/9, 6/12, 6/15

If the report runs again on Thur 6/6/24, it will pick up those same Hire Dates that are NEXT week 6/9, 6/12, 6/15

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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