Work Schedule (DBI) is not being retrieved using Assignment ID in OTL Fast Formula.

Summary:

Requirement: Retrieve scheduled hours based on a specific Assignment ID.

Issue: When passing the Assignment ID to Employee Work Schedule using CHANGE_CONTEXTS(), the formula consistently returns the primary assignment’s work schedule instead of the schedule corresponding to the provided Assignment ID.

Note: The DBI HWM_CTXARY_SUBRESOURCE_ID[nidx] correctly returns multiple Assignment IDs, but the schedule lookup appears to ignore the context and defaults to the primary assignment.

Content (please ensure you mask any confidential information):

CHANGE_CONTEXTS(HR_ASSIGNMENT_ID = HWM_CTXARY_SUBRESOURCE_ID[nidx])
(
a = HWM_EMP_SCHD_START_DATE_TIME.FIRST(-1)
ShiftCount = HWM_EMP_SCHD_START_DATE_TIME.count