---
sourceDocument: Yokohama Finance and Supply Chain
sourceDocumentLink: https://servicenow-prod.fluidtopics.net/r/yokohama/source-to-pay-operations

 Release :

    - yokohama

ft:locale :

    - en-US

ft:publication_title :

    - Yokohama Finance and Supply Chain

ft:clusterId :

    - stpop

bundleId :

    - stpop

workflow :

    - Employee


---

# Run fix script to update the Aggregation method field in the KPI table

# Run fix script to update the Aggregation method field in the KPI table {#ariaid-title1}

* Release version: Yokohama
* 
* Updated January 30, 2025
* 
* ![](https://www.servicenow.com/docs/portal-asset/ico-clock) 1 minute to read

Run this fix script to update the new fields added in the KPI table (sn_kpi_kpi) after the May 2025 Yokohama release.

## Before you begin

Role required: admin

After the upgrade, the new fields Aggregation method, Collection level, and Current threshold value are added in the KPI table
(sn_kpi_kpi).

It is mandatory to run the script to be able to use new features for the existing KPI records. Without the aggregation method and current threshold values, the calculated KPI behavior and KPI
performance calculations might get impacted.  
Note:  
For new KPI templates and KPIs, there's no impact even if the script is not run.

## Procedure

1. Navigate to AllSystem DefinitionFix Scripts.
2. Search for the KPI - May 2025 data upgrade script script.
3. Open the fix script record.  
   Note:  
   In the Script field, the batch size variable is set to 9500. If there are more than 9500 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 LIMIT variable to a number equal to the number of KPI records in your instance and select Update.
   {#run-fixscript-update-kpi-aggregation-method__ul_zhm_ppv_12c}
4. Select Run Fix Script.
**Related concepts**   

* [Processing the skipped supplier catalog item records after upgrade](https://servicenow-prod.fluidtopics.net/tclJpvmd1~TUffB8ivvPtQ "After you upgrade to Yokohama, the latest supplier catalog items may get skipped and therefore may not be available after the upgrade.")  
**Related tasks**   

* [Run fix script to update the KPI weighted score field in the KPI score table](https://servicenow-prod.fluidtopics.net/J_IjYYLWUksVvZHLgZdRxQ "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 Yokohama release.")
* [Run fix script to update the KPI Instruction field in the Supplier Task table](https://servicenow-prod.fluidtopics.net/uYeTr1fLsaquN~naJqCVQw "Run this fix script to update the new field KPI Instruction added in the Supplier Task (sn_slm_task) table in the Yokohama release.")
* [Run fix scripts to enable Automated KPI collection](https://servicenow-prod.fluidtopics.net/CBy58oIDUstjDURtzncg2w "Run the fix scripts to enable the Automated KPIs feature that automatically calculates KPI data from database tables instead of manually entering values.")
* [Run fix script to migrate existing data from the deprecated Action type column after upgrade](https://servicenow-prod.fluidtopics.net/BeqW~SSd7MvZnkNL8rtoIA "In the May Store 2024 release, the Action type column in the Supplier Task (sn_slm_task) table has been deprecated.")
* [Run fix script to use the Supplier Manager Workspace after upgrading to the Yokohama release](https://servicenow-prod.fluidtopics.net/gkf0T4RE06VFEiIo21sxdg "After upgrading to the Yokohama release, you can see only the Source-to-Pay Workspace on the All navigation tab. You don't have to do anything if you choose to continue to use the Source-to-Pay Workspace.")
* [Enable deprecated case types after upgrade](https://servicenow-prod.fluidtopics.net/qbW98GqNMvFjKF1ubCTpsw "After you upgrade to Yokohama, you can enable deprecated case types if you have the admin role.")

*[\>]: and then