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

Latest Assignment Change

edited Aug 31, 2020 7:12PM in Reporting and Analytics for HCM 8 comments

Content

Hello,

I'm trying to pull the latest assignment change row using the Assignment Event Subject area, but it doesn't seem to be working anymore. In the past I've used (RCOUNT("Assignment Event Details"."Effective Start Date") IN (RMAX(RCOUNT("Assignment Event Details"."Effective Start Date")))) with a group by function on "Worker"."Person Number".

 

I'm wondering if anyone else has anyway to pull the latest assignment row without the Logical SQL Query?

Version

20C
Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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