We'd love to hear from you! Provide  feedback  to earn a badge today. Take our quick survey
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

Calculate Time at grade, location, time in role (not position) using Assignment Event Real Time in H

Received Response
edited Sep 2, 2021 10:48AM in Reporting and Analytics for HCM 3 comments



I am trying to use OTBI to look at an employee's assignment history and derive new calculated fields for the following:

  • Grade Effective Start Date and thus calculate time in grade
  • Location Effective Start Date and thus calculate time at location
  • Position Effective Start Date and thus calculate time in position
  • Job Effective Start Date and thus calculate time in job

I remember this being possible in Oracle EBS - has anyone tried to do this in OTBI successfully?  


I have attached some dummy data with a more detailed explanation.  Basically all the attributes can be independent of each other and there is only Effective Start and End Date for the combination of attributes.  Also an employee might return to a previous job, location, grade or position and therefore MIN and MAX isn't reliable.


Howdy, Stranger!

Log In

To view full details, sign in.


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