Import of demo data and transfer to Core tables

You can optionally purge the Inbox and Core tables to clear out the data in SCV prior to importing demo data. System macro must be created and executed manually which contain these commands:

  • RunSCV(“PURGE_PLANNING_DATA”,”-TABLE_AREA=Inbox”)
  • RunSCV(“PURGE_PLANNING_DATA”,”-TABLE_AREA=Core”)
To import the demo data from the provided csv files, the following macros must be executed in the specified order from Process > Cycle Periods.
Note: If you are assigned with all the required roles and cannot view the macro, restart the browser and login.
  • SCV_S3_All_Inbound_Full: This macro imports data into SCV Inbox. After the macro execution is completed, you can check the Inbox Table from the SCV menu for the imported data.
  • SCV - Inbound All Full: Moves data from SCV Inbox to SCV Core.
    • You must ensure that the BASE_SC_DEMAND_PLAN_AGGR_FK_CALPER constraint is disabled. This constraint is disabled automatically when loading the configuration.zip file.
    • If you have not imported prices into SCV, you must update the application variable Convert Currency (base_convert_currency) by setting Override Value to False. This application variable is updated automatically when loading the configuration_override.zip file. This ensures the currency conversion step is skipped when you run the macro. Currency conversion uses the original currency value and overwrites the main equivalent fields after conversion to the common currency. For example, std_cost_orig is converted to std_cost.
    • Map routing transformations is required only if Production Scheduling is used. To disable the RunSystemMacro(“SCV_Transform_Map_Routing_Version_All”) step within the macro set the condition to 1==0.
    • This macro performs these actions:
      • Validate Inbox data
      • Transfer data from inbox to core
      • Apply currency conversion
      • Apply routing effective date transformations
      • Apply map routing transformations
      • Apply routing quantity calculations
      • Prepare SCV Hierarchy
      • Prepare SCV profile
  • SCV_APSCO_Prepare_Profile_All: This macro must be executed when using Supply Chain Optimization.