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