Oracle Transactional Business Intelligence
Is there any possibility to get latest job change date in OTBI Report
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
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