Categories
- All Categories
- Oracle Analytics and AI Learning Hub
- 34 Oracle Analytics and AI Sharing Center
- 22 Oracle Analytics and AI Lounge
- 272 Oracle Analytics and AI News
- 47 Oracle Analytics and AI Videos
- 16.1K Oracle Analytics and AI Forums
- 6.3K Oracle Analytics and AI Idea Labs
- Oracle Analytics and AI User Groups
- 99 Oracle Analytics and AI Trainings
- 16 Oracle Analytics and AI Challenge
- Find Partners
- For Partners
Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture
Is there any possibility to get latest job change date in OTBI Report
Divya Kollipara
Rank 1 - Community Starter
Hi Experts,
Good Day!!
Can someone please let me know how to get the latest job change date in OTBI Report
For Example, one employee Job changed from "AA" to "BB" on 01-Jan-2022 then multiple assignment changes happened for the same person. I need to get the 01-Jan-2022 (As the job changed from "AA" to "BB") in OTBI Report.
Regards,
Divya
0
Answers
-
Hi Divya,
You can check subject area: Workforce Management - Worker Assignment Event Real Time
See Folder & Attribute: Additional Attributes - Job Creation Date
Also, you can refer to this post on various Calendar Date/Time Functions that you can apply with regards to your requirement:
https://docs.oracle.com/cd/E17904_01/bi.1111/e10544/appasql.htm#BIEUG539
Regards,
Dave
0