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

Work Schedule Report - Getting Hours On Date

Question
2
Views
0
Comments
edited Nov 17, 2021 4:12PM in Workforce Management

Summary:

As per the screenshot attached.

We have a requirement to fetch the Hours On Date. Example. If we pass parameter date as 03-Dec-2018 then 35 hours 77777700-7 (Need to get the "7"..that we will work on it.)

If the parameter date is 08-Dec-2018 then, we need to get the value "12" From 262 hours 48 hrs x 5 plus 12 over 6 wks-12

We have tried all the tables but unable to find the table which stores these information.

We are trying to use the Package Function Call in SQL (PER_AVAILABILITY_DETAILS.GET_SCHEDULE_DETAILS) and trying to get the information. But still the query is not getting ended only and its Infinitely running.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in.

Register

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