Get Started with Redwood for Oracle Cloud HCM Begin Now
To ensure that questions get required attention from community members and are NOT left unanswered, it’s important for the author to indicate (by selecting “Yes” or “No” when prompted) whether the question was answered. (newly added) Please note that it is also important to respond to EACH comment your question receives. Your Yes or No response ensures an accurate status for your question.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
For more information, please refer to this announcement explaining best practices for getting answers to questions.
Calculate Time at grade, location, time in role (not position) using Assignment Event Real Time in H
Content
Hello,
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.
0