Run fix script to migrate existing data from the deprecated Action type column after upgrade
In the May Store 2024 release, the Action type column in the Supplier Task (sn_slm_task) table has been deprecated.
Before you begin
Role required: admin
About this task
In the May Store 2024 release, the Supplier Task (sn_slm_task) table uses the Action type for task column from its parent Service Task [sn_spend_sdc_service_task] table. After you upgrade to the May Store 2024 release, ensure that you run the fix script to migrate existing data from the deprecated Action type column to the newly added Action type for task column in the Supplier Task table.
Important: Before you run the fix script, ensure that you restructure the Supplier Task table to extend the Service Task table.
Procedure
Navigate to All > System Definition > Fix Scripts.
Search for the SLO - upgrade scripts for may 2024 script.
Open the fix script record.
In the Script field, set the batch size variable to a number equal to the number of supplier task records in your instance.
For example, if your instance has 10000 supplier task records, set the batch size variable as follows:
var batchSize = 10000;Select Update.
Select Run Fix Script.
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 script to update the KPI Instruction field in the Supplier Task table
Run fix scripts to enable Automated KPI collection
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 update the KPI Instruction field in the Supplier Task table
Run fix script to use the Supplier Manager Workspace after upgrading to the Australia release