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
Get Scheduled Hours From Assignment Work Schedules
We have a requirement to get the scheduled hours from Assignment Work Schedules.
We are trying with the below code but its not giving hours.
SELECT *
FROM
(
TABLE(PER_AVAILABILITY_DETAILS.GET_AVAILABILITY_DETAILS
(P_RESOURCE_TYPE => 'ASSIGN'
,P_RESOURCE_ID => '300000173930572'
,P_PERIOD_START => TO_DATE('2023-07-16','YYYY-MM-DD')
,P_PERIOD_END => TO_DATE('2023-07-22','YYYY-MM-DD')
)))
It would be helpful if you can provide any inputs on this.
0