by-clause-for-group-by In OTBI/OBIEE reports
(Doc ID 2708150.1)
Last updated on JUNE 28, 2022
Applies to:Oracle Fusion Global Human Resources Cloud Service - Version 11.13.20.07.0 and later
Information in this document applies to any platform.
Scenario : To fetch job change date of employees. What is the logic for this scenario
Example scenario: Workforce Management - Worker Assignment Event Real Time subject area. The worker contains 4 effective dated record in his assignment history where 3 times his job has been changed.
Want another field in this report where Job change date to display on the report.
Example Expected result:
Effective Start Date Effective End Date Job Name Job Change Date( the new field)
09/22/2015 07/23/2017 Default
07/24/2017 06/13/2020 Floor Supervisor 07/24/2017
06/14/2020 07/14/2020 Floor Supervisor 07/24/2017
07/15/2020 12/31/4712 Shift Manager Trainee 07/15/2020
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document