6.2-r17

Important To Know For Upgrade

• stg Fixed: inv.v_stocks does not produce duplicate records. DEV-3891
• stg Toolbox improvements:
  New tb.create_procedure to create a skeleton procedure.
  New tb.add_synonym to add synonyms. Better error handling in lock/unlock schema.
  Improved error logging in merge procedure.
  Audit list showing initial status of object.
  Improved intelligence for stg element type in tb.add_element.
  Adding migration DEV-3886

Database Update Scripts

• Check out db_scripts\compare_reports for the update reports for updating and patching
  

  (Note that all schema changes listed in the patch reports are applied every time you patch the databases, so please check the report and see if you have any customizations in the objects listed there.)

Release notes

• See list on Jira
• See list of pull requests involved in this update on GitHub

Bugs

• stg Fix inv._ex views and changed to tb DEV-4087
• item-card Aggregate/sum values over period for series that are marked as aggregated_over_period = false AND aggregation_calc_func = 'sum' so that they are visible in the Item Card Grid. DEV-4065
• Forecasts Fix Settings Cache: When applied demand on Saturdays in global settings it didn't work on item level when rerun forcast DEV-3967
• stg Making sure all raw stg elements and included when the system is installed and using "other erp" DEV-3915
• reports/Item Fixing safetystock bug for floating order frequency items. DEV-4009
• stg Fixed: inv.v_stocks does not produce duplicate records. DEV-3891
• reports/items Make report list refresh after group is edited DEV-3858
• Forecasts Number of Christmas/Easter Weeks Required for Custom Day Distribution to settings table and forecast code added. DEV-3833
• orders Change the primary key of item_order_routes_extra_info tables to match the item_order_routes table (a requirement for extra info database trigger to function properly) DEV-3723
• Forecasts Settings Cache now works on item level when demand on Saturdays is applied in global setting when forecast is rerun. DEV-3595
• Forecasts, orders Altering batch_id in forecast_processes table to use sequence instead of non-threadsafe select max + 1 method DEV-3242
• reports/items fix: Cannot remove columns from report after changing language DEV-2809
• translations Wrong Icelandic translations in column filters DEV-2308

Tasks

• user-management Prompt users who sign in using their Microsoft account for account selection DEV-4100
• user-management fix: SSO - Refresh token not used when authentication token is expired DEV-4116
• core tb.events improvements - printing help in the message tabs and returning partial data DEV-3914
• stg  tb.batch_info improvements DEV-3897
• stg Toolbox improvements: New tb.create_procedure to create a skeleton procedure. New tb.add_synonym to add synonyms. Better error handling in lock/unlock schema. Improved error logging in merge procedure. Audit list showing initial status of object. Improved intelligence for stg element type in tb.add_element. Adding migration DEV-3886
• datafactory, stg Adding the ability to run one db setups through datafactory DEV-3882
• stg Add tb.run_info and tb.run_list DEV-3849
• stg Moving the create extra info helper from core to tb schema DEV-3658
• item-card Client: Show undelivered orders sorted by date, such that those that are expected to be delivered first are on top. DEV-2189