Run fix script to update the KPI weighted score field in the KPI score table
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.
Before you begin
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.
Procedure
Navigate to All > System Definition > Fix Scripts.
Search for the Backfill KPI Weighted Score script.
Open the fix script record.
Note: 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.
- Select Run Fix Script.
Parent Topic:Post-upgrade tasks for Supplier Case Management
Related topics
Run fix script to update the Aggregation method field in the KPI table
Run fix script to update the KPI Instruction field in the Supplier Task table
Run fix scripts to enable Automated KPI collection
Run fix script to migrate existing data from the deprecated Action type column after upgrade
Run fix script to use the Supplier Manager Workspace after upgrading to the Australia release
Enable deprecated case types after upgrade
Processing the skipped supplier catalog item records after upgrade