Run this fix script to update the new field KPI Instruction added in the Supplier Task (sn_slm_task) table in the Zurich 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 .
-
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