Run fix script to update the KPI Instruction field in the Supplier Task table

  • Release version: Yokohama
  • Updated January 30, 2025
  • 1 minute to read

    • Run this fix script to update the new field KPI Instruction added in the Supplier Task (sn_slm_task) table in the Yokohama release.

    Before you begin

    Role required: admin

    After the upgrade, a new field KPI Instruction is added in the Supplier Task (sn_slm_task) table.

    The new field KPI Instruction is derived from the KPI table (sn_kpi_kpi) Instructions field. Run this fix script to transfer data from the dot-walked kpi_data.kpi.instructions field to the KPI Instruction field in the Supplier Task table.

    Procedure

    1. Navigate to All > System Definition > Fix Scripts.
    2. Search for the SLO - Feb 25 data script script.
    3. Open the fix script record.
      Note:
      In the Script field, the batch size variable is set to 1000. If there are more than 1000 supplier task records, you can do one of the following:
      • Run the fix script repeatedly until all active records are checked and copied.
      • In the Script field, set the TASK_PROCESSING_LIMIT variable to a number equal to the number of supplier task records in your instance and select Update.
    4. Select Run Fix Script.
      The script updates the KPI Instruction field value for the records where all the following conditions are met:
      • The supplier task is active
      • The supplier task is created to collect KPI data
      • The KPI Instruction field is empty