Run fix script to update the KPI weighted score field in the KPI score table

  • Rversion finale: Australia
  • Mis à jour 12 mars 2026
  • 1 minute de lecture

    • Run this fix script to update the KPI weighted score field values (from integer to decimal type) in the KPI score table (sn_kpi_score) after the March 2026 Australia release.

    Avant de commencer

    Role required: admin

    After the upgrade, the old field Weighted score is replaced by KPI weighted score field in the KPI score (sn_kpi_score) table.

    With the updated decimal type KPI weighted score field, all performance scores are calculated in decimal up to three decimal places.

    Procédure

    1. Navigate to All > System Definition > Fix Scripts.
    2. Search for the Backfill KPI Weighted Score script.
    3. Open the fix script record.
      Remarque :
      In the Script field, the batch size variable is set to 10000. If there are more than 10000 KPI 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 batch size variable to a number equal to the number of KPI records in your instance and select Update.
    4. Select Run Fix Script.