Tip: The Demantra Local Application replaces Collaborator Workbench. You may see both names in this text.
This chapter covers the following topics:
CDP provides the following workflows:
| Workflow Name | Purpose | Description |
|---|---|---|
| CDP All Engine Runs | Engine Run | Master workflow to run all 3 CDP engine workflows. |
| CDP Archive DM Consensus Forecast | Forecast Archival | Archives the last four versions of the Consensus Forecast Series. |
| CDP Archive Store Sell through Forecast | Forecast Archival | Archives Store Sell through Forecast and Store Sell through Final Forecast Lag Series defined on CDP GL Data table. Executes the Execute_Profiles stored procedure, with parameter = CDP. |
| CDP BLE Cluster Site Sell in Weekly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Site Sell in Weekly) on Sales Data as part of the weekly process. For more information on these profiles, refer to Business Logic Engine. |
| CDP BLE Cluster Store Sell in Weekly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Store Sell in Weekly) on CDP GL as part of the weekly process. For more information on these profiles, refer to Business Logic Engine. |
| CDP BLE Cluster Replenishment Weekly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Replenishment Weekly) on CDP GL as part of the weekly process. |
| CDP BLE Cluster Store To Site Sync Weekly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Store To Site Sync Weekly) on Sales Data as part of the weekly process. |
| CDP BLE Cluster Site Sell in Nightly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Site Sell in Nightly) on Sales Data as part of the nightly process. |
| CDP BLE Cluster Store Sell in Nightly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Store Sell in Nightly) on CDP GL as part of the nightly process. |
| CDP BLE Cluster Replenishment Nightly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Replenishment Nightly) on CDP GL as part of the nightly process. |
| CDP BLE Cluster Store To Site Sync Nightly | BLE Calculations | Runs the BLE profile (CDP BLE Cluster Store To Site Sync Nightly) on Sales Data as part of the nightly process. |
| CDP BLE On Demand | BLE Calculations | Executes BLE process in Save Data Mode. This workflow is called from Update Data workflow. |
| CDP Cancel Product Launch | Launch Management | Used in the CDP New Product Launch Management worksheet to run the Cancel Launch Request method, which cancels a new product or new store launch request. Launch requests that have a Status of Processing or Completed, cannot be cancelled. Also, Launch requests that have a Status of Valid and Launch Mode of Now cannot be cancelled. |
| CDP Edit Product Launch | Launch Management | Used in the CDP New Product Launch Management worksheet to run the Edit Product Launch method, which updates a product launch request. |
| CDP Edit Store Launch | Launch Management | Used in the CDP New Store Launch Management worksheet to run the Edit Product Launch method, which updates a store launch request. |
| CDP Engine Org Site Consumption | Engine Run | Runs the Proport procedure and the Analytical Engine on Consumption Engine Profile defined to the SALES_DATA table. |
| CDP Engine Shipment | Engine Run | Runs the Proport procedure and Analytical Engine on the Shipment Engine Profile defined to the SALES_DATA table. |
| CDP Engine Store Consumption | Engine Run | Runs the Proport and the Engine to the CDP GL (Store Level Consumption). |
| CDP Export Forecast Account | Export Forecast | Export to Legacy Item/Acct. Levels exported: Item/Account Series exported: Final Forecast |
| CDP Export Forecast Local | Export Forecast | Export to ASCP/Legacy Item/Org Levels exported: Item/Org Series exported:
|
| CDP Export Forecast Store | Export Forecast | Export to Legacy Item/Store. Levels exported: Item/Store Series exported: Store Sell-in Final Forecast |
| CDP Import All Site Data | Data Load | Master workflow to execute all Site Level Data Load workflows. |
| CDP Import All Store Data | Data Load | Master workflow to execute all Store Level Data Load workflows. |
| CDP Import CDP Level | Data Load | Loads the CDP General Level. |
| CDP Import Site Consumption | Data Load | Loads the Site Level Consumption Data to the SALES_DATA table. |
| CDP Import Site Inventory | Data Load | Loads the Site Level Beginning On Hand Inventory Data to the SALES_DATA table. |
| CDP Import Site WOS Lead | Data Load | Loads the Weeks of Supply, Lead Time data at Site Level. |
| CDP Import Store Consumption | Date Load | Loads the Store Level Consumption Data to the CDP GL data table. |
| CDP Import Store Consumption - Item/Store/Org/Site | Data load. | Loads store-level consumption data into the T_EP_CDP_DATA data table. |
| CDP Import Store Inventory In Transit On Order | Data Load | Loads Store Level On Hand Inventory, In Transit, and On Order data to the CDP GL data table. |
| CDP Import Store Replenishment Parameters | Data Load | Loads the Store Level Replenishment Parameters (Inv Minimum, Inv Maximum, Lead Time, Days of Supply, and so on) to the CDP GL Matrix table. |
| CDP Launch Management Batch | Launch Management | Executed by the CDP Nightly Batch Process workflow to process launch requests with Status of Valid and Launch Mode of Batch. |
| CDP Launch Management Ongoing | Launch Management | Executed by the CDP Weekly Batch Process workflow to process product and store launch requests with Status of Processed and Ongoing. If the new product or store launch date is greater than or equal to “max_sales_date” system parameter, then the it sets the Launch Status to Completed. |
| CDP Launch Management Realtime | Launch Management | Runs continuously in background for to process launch requests with Status of Valid and Launch Mode of Now. This workflow is scheduled to Launch on Startup. It runs whenever the Demantra Web application is restarted. |
| CDP Method BLE - Site Sell in Forecast | BLE Calculations | Invoked by the Sell in Forecast Recalculation method. |
| CDP Method BLE - Store Sell in Forecast | BLE Calculations | Invoked by the Store Sell in Forecast Recalculation method. |
| CDP Method BLE - Store Safety Stock Replenishment Order | BLE Calculations | Invoked by the Store Sell in Forecast Recalculation method. |
| CDP New Product Launch | Launch Management | Used in the CDP New Product Launch Management worksheet to initiate a new product launch request. |
| CDP New Store Launch | Launch Management | Used in the CDP New Store Launch Management worksheet to run the New Store Launch method, which initiates a new store launch request. |
| CDP Nightly Batch Process | Batch | Master workflow calls all relevant workflows which need to be run as part of Nightly Batch process. |
| CDP Order Export | Export Orders | Exports the CDP Order Export data. |
| CDP Standard Error Calculation Item/Org | Error Calculations | Computes Standard Error defined on SALES_DATA. |
| CDP Standard Error Calculation Item/Store | Error Calculations | Computes the Standard Error defined to the CDP GL Matrix table. |
| CDP Start Simulation Engine | Engine Run | Starts the Engine in Simulation Mode. |
| CDP Stop Simulation Engine | Engine Run | Stops the Simulation Engine. |
| CDP Weekly Batch Process | Batch | Master workflow calls all relevant workflows which need to be run as part of the Weekly Batch process. |
| CDP Weekly Data Tables Maintenance | System Performance | Runs the table reorganization procedure TABLE_REORG.REORG to improve system performance. By default running this workflow will reorganize the T_EP_CDP_DATA and SALES_DATA tables. This workflow is called as part of the CDP Weekly Batch Process master workflow. For more information about the table reorganization procedure, see "Database Health Check" in the Oracle Demantra Implementation Guide. |
| Create Launch Management Views | Launch Management | This workflow validates the NPI_SERIES_DATA definitions and should be run when the NPI_SERIES_DATA table is modified. If all definitions in this table are valid, then the workflow modifies and refreshes the launch management integration interfaces. The Status column in NPI_SERIES_DATA will be set to either Valid or Invalid. If the status is set to Invalid, then the ERROR_MESSAGE column will be populated with the appropriate error message. |
Perform the following to run or schedule a CDP workflow:
Log in to the Workflow Manager.
Select one of the following options from the View according to Schema Groups list:
CDP - Displays all CDP workflows, except the CDP Launch Management workflows.
CDP - Sites - Displays only CDP site-related workflows.
CDP - Store - Displays only CDP store-related workflows.
CDP Launch Management - Displays only CDP workflows associated with CDP launch management process.
To edit a CDP workflow, click the schema name or click Edit, and then click OK. Make the necessary updates to the Edit Schema page, and then validate and save your changes.
Note: You must be logged into Workflow Manager as the component owner (cdp) to modify any of these workflows.
Click Start to run the workflow, or click Schedule to display the Schema Scheduler and define workflow run time.
When done, click Logout to exit the Workflow Manager.