Learn about the new Oracle AI Agent Studio for Fusion Applications: Watch Now
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
Progress with Redwood: Redwood Resources for Oracle Cloud HCM - Go Here
DB Table for Manage Planned Schedule page
Summary
DB table name for shifts assigned using manage planned schedule pageContent
Hi, we are creating a BI report with employee shift details. We are using the PER_SCHEDULE-asSIGNMENT table, but this does not store the shifts assigned using Manage Planned Schedule page in Time administrator. We have also tried ZMM_SR_SHIFT_DTLS, tables, but this table is also not having any record. HWM_TM_REC table is having only start time and stop time, but there is no shift id. Can anyone please help.
Thanks.
Tagged:
0