Get Started: AI Resources for Oracle Cloud HCM – Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Effective Date Issue?
Content
Hi Experts,
I've built an analysis in OTBI to extract Work Schedules doe Employees. Even though my report has the P_DATE effective date SQL prompt, it is bringing back multiple rows for our employees - see image.
All Work Schedules have a Schedule End Date of 31/12/2049 when they are active - so if someone changes their work schedule we put the correct end date in, add a new row and change the end date of the new record to 31/12/2049
I'm struggling to understand what I need to do in order to just bring back the valid Work Schedule on an effective date
Tagged:
0