Run fix script to update the KPI Instruction field in the Supplier Task table
Run this fix script to update the new field KPI Instruction added in the Supplier Task (sn_slm_task) table in the Australia 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 added in the Supplier Task (sn_slm_task) table 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
Navigate to All > System Definition > Fix Scripts.
Search for the SLO - Feb 25 data script script.
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 batch size variable to a number equal to the number of supplier task records in your instance and select Update.
- 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
Parent Topic:Post-upgrade tasks for Supplier Case Management
Related topics
Run fix script to update the KPI weighted score field in the KPI score table
Run fix script to update the Aggregation method field in the KPI 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
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