Generate

This table lists the SCV Core tables and the column to use for the Cartesian product:

• If the item-location-customer combination generated from the <current table> already exists in SC_VALID_COMBINATIONS:
  • The data generated is ignored, if the existing item-location-customer combination in SC_VALID_COMBINATIONS is imported through Inbox. The priority is provided to imported data when compared to generated data.
  • All existing records in SC_VALID_COMBINATIONS for the item-location-customer combination are replaced with the data generated, if the existing item-location-customer combination in SC_VALID_COMBINATIONS is generated.
    Note: This process replaces all existing records with new data that match item-location-customer combinations.
• If the item-location-customer combination generated from the <current table> does not exist in SC_VALID_COMBINATIONS, the generated data is inserted in SC_VALID_COMBINATIONS.
• If the <current table> contains multiple records for an item-location-customer combination (for example, open sales orders), all records are combined. Therefore, the common values (such as source and ae_id) are retrieved as the maximum value of the group.
• The generated data is saved in SC_VALID_COMBINATIONS as follows:

  item_id = From the input SCV Core table     
      location_id = If exists then from the input SCV Core table, otherwise from Cartesian product to SC_LOCATION (type=Warehouse)    
      customer_id = If exists then from the input SCV Core table, otherwise from Cartesian product to SC_CUSTOMER     
      effective_start_date = If exists and not-null then from the input SCV Core table, otherwise from the SCV configuration parameter SCP_DEFAULT_START_DATE  
      effective_end_date = If exists and not-null then from the input SCV Core table  
      spreading_factor = If exists and not-null then from the input SCV Core table, otherwise "1"  
      valid_combination_source = "Generated"  
      status = "Open"  
      source = From the input SCV Core table where location_id value is retrieved from: 
          If the input table already contains the location, then use the source value from the table itself. Examples: sales orders or item-location. 
          If the input table does not contain the location (in other words cartesian product is applied to locations)m then use the source value from the location table. Example: item-customer.  
      ae_id = From the input SCV Core table  
      created_by = "TFORM_GENERATE_VALID_COMBINATIONS:" + <current execution id>  
      creation_time = <current timestamp in UTC>
      modified_by = "TFORM_GENERATE_VALID_COMBINATIONS:" + <current execution id>  
      modification_time = <current timestamp in UTC>
  

  Note: The data processing logic can be implemented in the following ways:

  • Process one table at a time. When processing the current table, delete all existing records with matching item-location-customer combinations generated from the previous table, and insert the newly generated records from the current table.
  • Process all tables at the same time. The program sorts generated records based on the rank of the selected tables in the SCV Valid Combination definition. Insert only the records from the table with the highest rank. Currently, the implementation uses this process.