Restructured Supplier Task table

  • Release version: Xanadu
  • Updated August 1, 2024
  • 1 minute to read

    • The Supplier Task table architecture has been restructured in the Washington DC release.

    In releases before the Washington DC release, the Supplier Task [sn_slm_task] table extended the Task [task] table.

    Starting with the Washington DC release, the Supplier Task [sn_slm_task] table extends the Service Task [sn_spend_sdc_service_task] table.

    Figure 1. Supplier Task table structure
    Supplier Task table structure

    After you upgrade to the Xanadu release, verify that your existing supplier task data has been migrated correctly. If you notice that your active Supplier Task table did not migrate properly, use the Now Support Portal to raise a new case with the Technical Support team.

    Also, after you upgrade to the Washington DC release, the fix script glidefix_script_reparent_sn_slm_task.xml runs to reparent the Supplier Task table on instances with huge count of records (in millions). Therefore, it’s advisable to run the upgrade during a period of low interaction.
    Note:
    This is a mandatory one-time fix script run on instances upgrading directly to Washington DC from Vancouver or older versions.