You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register
Get Started: AI Resources for Oracle Cloud HCM – Go Here

Progress with Redwood: Redwood Resources for Oracle Cloud HCM -  Go Here

Need an Correct SQL Query to get updated start time and stop time from OTL Submitted time entries

edited Nov 16, 2024 2:56PM in Workforce Management 1 comment
Below is the reference query which is pulling duplicates becuase of confusion between range and measures types.
SELECT
papf.person_number,
htc.start_time,
htc.stop_time
FROM
per_all_people_f papf,
hwm_tm_rec htc,
hwm_tm_rec_grp_usages htrgu,
hwm_tm_rec_grp htrg,
hwm_grp_type hgt
WHERE
htc.resource_type = 'PERSON'
AND htc.latest_version = 'Y'
AND htc.layer_code = 'TIME_RPTD'
AND htc.tm_rec_id = htrgu.tm_rec_id
AND htc.tm_rec_version = htrgu.tm_rec_version
AND htrgu.latest_version = 'Y'
AND htrgu.tm_rec_grp_id = htrg.tm_rec_grp_id

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!