Publish to Supply Chain Vault (SCV)

This functionality enables you to view the schedule data that is published by the Production Scheduling Desktop Client application within SCV. The published data can be used for reporting and additional data processing.

This is the process of publishing a model:

1. The latest SCP production scheduling template must be loaded, using the Load Template screen in the SCP application. When you load a template, the 47 SCV Core tables are added. The Load Template screen can be accessed from the Maintenance menu of the Configuration module.
2. The selected model must be published, using the Publish option from the Sharing menu in the Production Scheduling Desktop Client application.
   Note: 

   • You can also publish the model by running the Sharing.Publish macro on the Automation menu.
   • The model name on the Global Preferences screen must be unique. Else, an error message is displayed.
3. The Publish to SCV switch must be selected in the Production Scheduling Desktop Client application. This switch determines whether to export data to SCV when you publish a model.
   Note: 

   • This switch is displayed on the Features tab of the Global Preferences screen.
   • By default, this switch is set to Off. Data is published without exporting to SCV.
   • If this switch is set to On, data is exported to SCV after publishing when a template is loaded in the SCP application.
4. The published data is displayed on the SCV SQL Previewer or SCV Data Viewer screen in the SCP application. These screens can be accessed from the Utilities menu.
   Note: 

   • You must have the ‘SCV Main System Administrator’ role or ‘SCV SQL Previewer (utilities)’ permission to access these screens.
   • You can execute a query to view the required data and export data manually to CSV.

These SCV Core tables are updated when a model is published:

• SC_PS_COUPLED_PRODUCT_FLOW
• SC_PS_DOWNTIME
• SC_PS_ENDITEM
• SC_PS_INVENTORY_LEVEL
• SC_PS_INVENTORY_LEVEL_TRANSPOSED
• SC_PS_ORDER
• SC_PS_ORDER_BATCH_RELATIONSHIP
• SC_PS_PROCESS_BATCH
• SC_PS_PROCESS_BATCH_BY_PRODUCT
• SC_PS_PROCESS_BATCH_CLAIMED_RESOURCE
• SC_PS_PROCESS_BATCH_CLAIMED_UTILITY
• SC_PS_PROCESS_BATCH_INFLOW_PRODUCT
• SC_PS_PROCESS_STEP
• SC_PS_PROCESS_STEP_BY_PRODUCT
• SC_PS_PROCESS_STEP_INFLOW_PRODUCT
• SC_PS_PROCESS_STEP_MATRIX_CRITERION
• SC_PS_PROCESS_STEP_RESOURCE_DEPENDENT_RULE
• SC_PS_PROCESS_STEP_RESOURCE_GROUP
• SC_PS_PRODUCT
• SC_PS_PRODUCT_GROUP
• SC_PS_PUBLISH_DATA
• SC_PS_RESOURCE
• SC_PS_RESOURCE_AVAILABILITY
• SC_PS_RESOURCE_AVAILABILITY_EXCEPTION
• SC_PS_RESOURCE_CLAIM
• SC_PS_RESOURCE_GROUP
• SC_PS_RESOURCE_GROUP_RESOURCE
• SC_PS_RESOURCE_TRANSITION
• SC_PS_RESOURCE_UTILIZATION
• SC_PS_ROUTE_CONSTRAINT
• SC_PS_STAGE
• SC_PS_STAGE_PRODUCT_GROUP
• SC_PS_STAGE_RESOURCE_GROUP
• SC_PS_TANK_BATCH
• SC_PS_TANK_BATCH_CLAIMED_RESOURCE
• SC_PS_TANK_BATCH_CLAIMED_UTILITY
• SC_PS_TIME_PERIOD
• SC_PS_TIME_TABLE
• SC_PS_TIME_TABLE_TIME_PERIOD
• SC_PS_TRANSITION_MATRIX
• SC_PS_TRANSITION_MATRIX_ELEMENTS
• SC_PS_UTILITY
• SC_PS_UTILITY_AVAILABILITY
• SC_PS_UTILITY_AVAILABILITY_EXCEPTION
• SC_PS_UTILITY_CLAIM
• SC_PS_UTILITY_LEVEL
• SC_PS_VIEW

The timestamp of the latest published model is recorded and displayed on these screens:

• SCP > Model name > Model details tab
• File > Models > Model name (Desktop client)
• SCP > Process > Audit Log

These SQL queries on the SQL Previewer screen can be used to search for the published data:

• To view all models that are published in the tenant: SELECT * FROM SC_PS_PUBLISH_DATA
• To view published process batch data in the 'my model' model: SELECT * FROM SC_PS_PROCESS_BATCH WHERE ps_model_name = 'my model'