resource availability in collected data not respecting shifts
Summary
resource availability in collected data not respecting shiftsContent
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.