Business Plan-related changes

Changes in Production Scheduling related to Business Plans are listed below.
Note: Deleting production orders in the ERP is not supported any more when Business Plans are used in the new SCV Outbound Flow.

Publishing process/tank batches from Production Scheduling to SCV now includes these steps:

  • Publish batches to PS-specific Core tables in SCV
  • Purge previously published plans in the new SCV Core plan tables
  • Publish new plans to the new SCV Core plan tables
  • Log plans

Process/tank batches are published into the new SCV Core plan table:

  • SC_PRODUCTION_PLAN

Process/tank batches in Production Scheduling can now have one of the following status:

  • No Status: Newly created process/tank batch.
  • Planned
  • Firm Planned
  • New: Newly created process/tank batches which have been exported to the ERP to “create a new order”. ERP order number is not yet known in SCP.
  • Open: Orders that have already been exported to ERP and the ERP order number is known in SCP.
  • Released: Orders that have been released in ERP for execution (for example, released to the shop floor).
  • In Progress: Orders that are currently being executed. For purchase and transferred orders, corresponds to shipped but yet to be received.
  • Completed: Order for which the execution is completed, and all goods have been reported in inventory.
  • Cancelled: Cancelled orders.

Process/tank batches published from Production Scheduling have the following status:

  • Firm Planned
  • New
  • Open

These interface services are updated to publish batch status:

  • SCV: Write Process Batch
  • SCV: Write Tank Batch

New macro:

  • SCV - Production Scheduling Publish Orders (Batches) to SCV Core: Publishes process/tank batches from PS-specific SCV Core tables to SCV Core plan tables.

New SCV views:

  • SC_V_PS_PUB_PROCESS_BATCH_ORDERS
  • SC_V_PS_PUB_PROCESS_BATCH_ORDERS_RESOURCE
  • SC_V_PS_PUB_PROCESS_BATCH_FIRMPLANNEDORDERS
  • SC_V_PS_PUB_TANK_BATCH_ORDERS
  • SC_V_PS_PUB_TANK_BATCH_ORDERS_RESOURCE
  • SC_V_PS_PUB_TANK_BATCH_FIRMPLANNEDORDERS

New SCV mappings:

  • BASE_SC_V_PS_PUB_PROCESS_BATCH_ORDERS-SC_PRODUCTION_PLAN
  • BASE_SC_V_PS_PUB_PROCESS_BATCH_ORDERS_RESOURCE-SC_PRODUCTION_PLAN_OP
  • BASE_SC_V_PS_PUB_PROCESS_BATCH_FIRMPLANNEDORDERS-SC_PRODUCTION_PLAN
  • BASE_SC_V_PS_PUB_TANK_BATCH_ORDERS-SC_PRODUCTION_PLAN
  • BASE_SC_V_PS_PUB_TANK_BATCH_ORDERS_RESOURCE-SC_PRODUCTION_PLAN_OP
  • BASE_SC_V_PS_PUB_TANK_BATCH_FIRMPLANNEDORDERS-SC_PRODUCTION_PLAN

Loading planning data from SCV into Production Scheduling is aligned with publishing batches. A new "use business plans" model parameter is introduced to enable business plan-related logic in PS mapping views in SCV. In addition, the new scp_order_status column is used to populate the batch status in PS. In addition, a new ext_order_status column is now available for informational purposes in PS views. The new columns hold the order status in ERP.

New model parameter:

  • USE_BUSINESS_PLANS: Default value is "N".

These views are updated to add columns for status, ext_order_status and to update code column mappings:

  • SS_V_PROCESS_BATCH SS_V_PROCESS_BATCH_ERP
  • SS_V_PROCESS_BATCH_ERP_HIST
  • SS_V_PROCESS_BATCH_EXT_CODE
  • SS_V_PROCESS_BATCH_HIST
  • SS_V_PROCESS_BATCH_PUR_ERP
  • SS_V_TANK_BATCH
  • SS_V_TANK_BATCH_ERP
  • SS_V_TANK_BATCH_ERP_HIST
  • SS_V_TANK_BATCH_EXT_CODE
  • SS_V_TANK_BATCH_HIST
  • SS_V_TANK_BATCH_INVSTK

New views:

  • SS_V_ORDER_PROD_PLANNED_ORDER
  • SS_V_ORDER_PROD_FIRMPLANNED_ORDER

These Production Scheduling Interfaces are updated to add status to the mappings:

  • SCV: Read Process Batch
  • SCV: Read Process Batch ERP
  • SCV: Read Process Batch Purchase ERP
  • SCV: Read Tank Batch
  • SCV: Read Tank Batch ERP
  • SCV: Read Tank Batch Inv. Stock Location

New Production Scheduling Interfaces:

  • SCV: Read Order - Production Planned Orders Imported
  • SCV: Read Order - Production FirmPlanned Orders Imported
Note: This feature is available only after appending the base (base.zip) and production scheduling template (productionscheduling.zip) for this version. Publishing process/batches into new SCV Core plan tables are enabled after setting the model parameter USE_BUSINESS_PLANS = "Y" and setting the scv_use_business_plans_for_outbound application variable to 1. The default value for this model parameter is "N". Default value for this application variable is 0. No additional role or privilege is required to access this feature.