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
Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now

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

Get History Data Using Workforce Management - Person Real Time Subject Area

in Reporting and Analytics for HCM 8 comments

Good Day Experts,

As stated in the subject area description, Person Real Time subject area only retrieves latest and current personal information as of today but can use a prefix SQL to include history or future dated data using 'SET VARIABLE PARAM_EFFECTIVE_DATE'.

I was able to use this to get future dated data by inputting SET VARIABLE PARAM_EFFECTIVE_DATE='4712-12-31'; for Workforce Management - Worker Assignment Event Real Time subject area.

Getting history data for Person Real Time, is it the same date (4712-12-31) to get history data?


Thank you.

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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