Determine the current planning period

These SP_V_* views are updated to consider planning period start date instead of current date to filter and fetch required information:

  • SP_V_CUSTOMER_ORDERS
  • SP_V_INITIAL_BACKORDERS
  • SP_V_QTY_ON_HAND
  • SP_V_EXPIRING_QTY_ON_HAND
  • SP_V_QTY_ON_HAND_WIP
  • SP_V_FIRM_RELEASED_PRODUCTION
  • SP_V_SCHEDULED_RELEASED_PRODUCTION
  • SP_V_FIXED_PRODUCTION
  • SP_V_FIRM_PRODUCTION
  • SP_V_SCHEDULED_PRODUCTION
  • SP_V_FIXED_SHIFTED_PRODUCTION
  • SP_V_FIRM_SHIFTED_PRODUCTION
  • SP_V_SCHEDULED_SHIFTED_PRODUCTION

This requires the SCP applications to pass the calendar ID as filter condition when reading from the above listed views.

In the APSCO integration, the standalone AP application imports calendar from SCV, hence it is not aware of the calendar loaded nor its first period. To allow users to specify the SCV calendar used by the standalone AP and the starting period in that calendar, following two new model parameters are used:

  • CALENDAR: Specifies the ID of one of the calendars in SC_CALENDAR. This calendar is loaded to AP.
  • CALENDAR_START_DATE: Start date of the planning calendar as specified in model parameter CALENDAR, in the format YYYY-MM-DD.

As before, the $scv_calendar_id variable in SCO must have the same value as the CALENDAR model parameter.

These existing SCO interfaces have been updated to specify the calendar filter scp_calendar_id = '$scv_calendar_id':

  • Quantity On Hand
  • Expiring Quantity On Hand
  • WIP Quantity On Hand
  • Customer Orders
  • Initial Backorders
  • Firm Released Production
  • Fixed Production
  • Fixed Shifted Production
  • Firm Production
  • Firm Shifted Production
  • Scheduled Released Production
  • Scheduled Production
  • Scheduled Shifted Production

This feature is enabled after appending the base template (base.zip) and APSCO template (apsco.zip) for this version and upgrading the SCO model to this version. You do not require to do anything to enable this feature.

Action required prior to activation:

Set the values of the CALENDAR and CALENDAR_START_DATE model parameters to the ID of the planning calendar in SCV and to the start date of the first planning period in that calendar.