Improvements to outbound flow

When Business Plans are not used, the outbound flow in SCV for supply plans, specifically scheduled orders from Production Scheduling, prevented the deletion of completed orders or rescheduling of active (in-progress) orders in ERP. The XREF table (SC_XREF_PROD_ORDER) is used in the outbound flow to match ERP order numbers to PS batch numbers. The outbound flow is now improved to clean up completed orders from the XREF table.

These views are added to select XREF records that do not exist in SC_AS_PROCESS/TANK_BATCH tables but that do exist in SC_PROD_HIST_TRX:

  • SC_V_AS_CLEANUP_PROCESS_BATCH_COMPLETED
  • SC_V_AS_CLEANUP_TANK_BATCH_COMPLETED

These new mappings are added to delete completed orders from XREF table that are not published from PS to SCV as a batch anymore:

  • BASE_SC_V_AS_CLEANUP_PROCESS_BATCH_COMPLETED-SC_XREF_PROD_ORDER
  • BASE_SC_V_AS_CLEANUP_TANK_BATCH_COMPLETED-SC_XREF_PROD_ORDER

This new macro is added to delete completed orders from XREF table that are not published from PS to SCV as a batch anymore:

  • SCV_AS_Cleanup_XREF_Completed_Batches

These new SCV datasheets are added:

  • PS - SC_V_AS_CLEANUP_PROCESS_BATCH_COMPLETED
  • PS - SC_V_AS_CLEANUP_TANK_BATCH_COMPLETED

In the base template, this macro is updated to run SCV_AS_Cleanup_XREF_Completed_Batches as a new macro step:

  • SCV_AS_Outbound_Supply_Plan_Full

In the M3 template, this macro is updated to run SCV_AS_Cleanup_XREF_Completed_Batches as a new macro step:

  • SCV_M3_Outbound_Supply_Plan_Full (with condition: '%app_var_scv_use_business_plans_for_outbound%' == '0')
Note: This feature is enabled after loading the Production Scheduling template (productionScheduling.zip) for this version. A new role or privilege is not required to access this feature.