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

resource availability in collected data not respecting shifts

Received Response
edited Jun 14, 2020 9:44PM in Supply Chain Planning and Collaboration 2 comments


resource availability in collected data not respecting shifts


We are seeing an issue where Resource Availability is not respecting work day patterns of shifts defined. Basically, we have a calendar which is 7 days ON attached to the organization. Then the same calendar has a shift defined which is 4 days ON and 3 days OFF. This shift is attached to certain resources in the org. All this data is coming over correctly to ODS. We are observing that Resource Availability is getting calculated for the OFF days as well.

 On further debugging, found that all the tables of  msc_calendars, msc_calendar_shifts, msc_workday_patterns, msc_department_resources and msc_resource_shifts are getting populated with correct data. The problem is the table msc_net_resource_avail is not getting populated with the shift number and hence follows the org calendar (7 days ON). In case of ASCP, this table gets populated with the shifts and hence respects the 4 days ON, 3 days OFF. Wanted to check if anyone has seen this working. 

Howdy, Stranger!

Log In

To view full details, sign in.


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