
6.2-r16	release/6.2.x	2022-03-17T15:17:34Z		6.2.13	6.2.15	6.2.16	1 / 30	6.2-r16.zip 6.2-r16.zip
6.2-r16 What's new? In this patch we are releasing several improvements to STG2 with the aim to simplify implementations, see further detail below. Database Update Scripts Check out the update reports for updating and patching in the db_scripts\compare_reports folder of the release zip file. (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.) Known Issues/Bugs Unaddressed issues in JIRA Issues Issues that were addressed and fixed in this release See list on Jira See list of pull requests involved in this update on GitHub See code changes on GitHub compare # Release Notes - Version 6.2-r16 Tasks `stg` - Unnecessary prep and raw tables and views removed, simplifying the data mapping since data doesn't need to go through both prep and inv layers. DEV-3702 `stg` - Location setup improved, see further details in the technical manual DEV-3535 `stg` - Data transfer pipeline shorter for extra info data. Now only needed to ALTER one view and run two stg elements DEV-3701 `Forecasts` - Fixes to avoid forecast errors while running scheduled orders. Passing the error from the exe to the AppService where it logs the error DEV-3636 `core` - Adding toolbox proc to display cus objects and source object if cus object is an override DEV-3631 `core` - Now logging AppServer task started/completed/stopped/error in core.event_batch DEV-3616 `stg` - Adding an "action center" table to log when consultant need to take action to ensure the correctness of customized objects. DEV-3506 `core` - tb.create_erp_table replacing tb.script_erp_table and core.create_erp_table DEV-3136 `core` - Added nest_level filter in tb.events + log_merge_rows/maxdop in core.stg_element DEV-3722 `scheduler` - Creating a server side element that can trigger a data factory build DEV-2793 `scheduler` - fixing stability issues where certain kind of exceptions (errors) in app-service can cause the worker in scheduler to stop working. DEV-3550 `allocation` - allowing filtering of items independent from inventory DEV-3754 `allocation` - With changes, when user deletes an allocation proposal it is not deleted from table alloc.allocation_proposal, instead column deleted is update to deleted=1. DEV-3474 Bugs `core` - fix: authData.requiresRefresh property is not set when logged in as O365. This caused caused slowness in loading workspaces in the client. DEV-3780 `orders` - fixing issues in demand calculation where worker table switching causes day old data to be used for DC level DEV-3714 `Forecasts` - Fix: the forecast is now using the setting key forecast_safety_stock_pow_max in stead of safety_stock_pow_max DEV-3662 `Forecasts` - Global skip forecast to date is added to core.settings table to fix AIS-679. Note that if you want to use the whole sales history for forecasting you might need to expand the global setting field (by default it is set to 36 months (3 years)). DEV-3637 `allocation` - When negative minimum allocation quantity is inserted by user it is changed to 0. DEV-3614 `promotional Planner` - Changes in dbo.data_element_ref_tables that promo_cus tables use id column [id] and not [promotion_id] and [promotion_line_id]. Also remove column [promo_location_k_group_name] from view 'Select Items into Promotion'. DEV-3608 `core` - Now when you navigate to / you will be redirected to the login page instead of the dashboard. The login page then uses the nav.homepage property to redirect you to the correct page. DEV-3607 `item-card` - Fix ignoring zeros issue in item card grid stock history DEV-3572 `orders` - Data sanity check in demand calculations. Checking if you have multiple order routes for an item DEV-3568 `Forecasts` - Fixing outlier detection cache issue + not going into forecast_outliers table DEV-3566 `orders` - Fixing demand formula (again), promo not being added on top of everything DEV-3560 `allocation` - Use dbo.v_stock_select instead of dbo.stocks in Allocation module, it was causing duplicate error when creating allocation proposal. DEV-3557 `scheduler` - fixing stability issues where certain kind of exceptions (errors) in app-service can cause the worker in scheduler to stop working. DEV-3550 `reports/items` - Enabling the MOQ days mbe column so that report 4.03 will function properly DEV-3510 `reports/items` - Changing column aggregation of the Stock Units column to sum DEV-3576 `workspaces` - Fix bug where drill-down was loaded incorrectly when using transferView and refreshGridAfterAction at the same time DEV-3502 `allocation` - Remove Days filter from Allocation view "Incoming PO". Data serie alloc_product_group_per_location_act_fcst changed so history_sale taken into account before the forecast in the coalesce. Column updated_at updated when alloc.purchase_order table is changed. DEV-3037

6.2-r16

What's new?

In this patch we are releasing several improvements to STG2 with the aim to simplify implementations, see further detail below.

Database Update Scripts

Check out the update reports for updating and patching in the db_scripts\compare_reports folder of the release zip file. (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.)

Known Issues/Bugs

Unaddressed issues in JIRA

Issues

Issues that were addressed and fixed in this release

See list on Jira
See list of pull requests involved in this update on GitHub
See code changes on GitHub compare

# Release Notes - Version 6.2-r16

Tasks

stg - Unnecessary prep and raw tables and views removed, simplifying the data mapping since data doesn't need to go through both prep and inv layers. DEV-3702
stg - Location setup improved, see further details in the technical manual DEV-3535
stg - Data transfer pipeline shorter for extra info data. Now only needed to ALTER one view and run two stg elements DEV-3701
Forecasts - Fixes to avoid forecast errors while running scheduled orders. Passing the error from the exe to the AppService where it logs the error DEV-3636
core - Adding toolbox proc to display cus objects and source object if cus object is an override DEV-3631
core - Now logging AppServer task started/completed/stopped/error in core.event_batch DEV-3616
stg - Adding an "action center" table to log when consultant need to take action to ensure the correctness of customized objects. DEV-3506
core - tb.create_erp_table replacing tb.script_erp_table and core.create_erp_table DEV-3136
core - Added nest_level filter in tb.events + log_merge_rows/maxdop in core.stg_element DEV-3722
scheduler - Creating a server side element that can trigger a data factory build DEV-2793
scheduler - fixing stability issues where certain kind of exceptions (errors) in app-service can cause the worker in scheduler to stop working. DEV-3550
allocation - allowing filtering of items independent from inventory DEV-3754
allocation - With changes, when user deletes an allocation proposal it is not deleted from table alloc.allocation_proposal, instead column deleted is update to deleted=1. DEV-3474

Bugs

core - fix: authData.requiresRefresh property is not set when logged in as O365. This caused caused slowness in loading workspaces in the client. DEV-3780
orders - fixing issues in demand calculation where worker table switching causes day old data to be used for DC level DEV-3714
Forecasts - Fix: the forecast is now using the setting key forecast_safety_stock_pow_max in stead of safety_stock_pow_max DEV-3662
Forecasts - Global skip forecast to date is added to core.settings table to fix AIS-679.
Note that if you want to use the whole sales history for forecasting you might need to expand the global setting field (by default it is set to 36 months (3 years)). DEV-3637
allocation - When negative minimum allocation quantity is inserted by user it is changed to 0. DEV-3614
promotional Planner - Changes in dbo.data_element_ref_tables that promo_cus tables use id column [id] and not [promotion_id] and [promotion_line_id]. Also remove column [promo_location_k_group_name] from view 'Select Items into Promotion'. DEV-3608
core - Now when you navigate to / you will be redirected to the login page instead of the dashboard. The login page then uses the nav.homepage property to redirect you to the correct page. DEV-3607
item-card - Fix ignoring zeros issue in item card grid stock history DEV-3572
orders - Data sanity check in demand calculations. Checking if you have multiple order routes for an item DEV-3568
Forecasts - Fixing outlier detection cache issue + not going into forecast_outliers table DEV-3566
orders - Fixing demand formula (again), promo not being added on top of everything DEV-3560
allocation - Use dbo.v_stock_select instead of dbo.stocks in Allocation module, it was causing duplicate error when creating allocation proposal. DEV-3557
scheduler - fixing stability issues where certain kind of exceptions (errors) in app-service can cause the worker in scheduler to stop working. DEV-3550
reports/items - Enabling the MOQ days mbe column so that report 4.03 will function properly DEV-3510
reports/items - Changing column aggregation of the Stock Units column to sum DEV-3576
workspaces - Fix bug where drill-down was loaded incorrectly when using transferView and refreshGridAfterAction at the same time DEV-3502
allocation - Remove Days filter from Allocation view "Incoming PO". Data serie alloc_product_group_per_location_act_fcst changed so history_sale taken into account before the forecast in the coalesce. Column updated_at updated when alloc.purchase_order table is changed. DEV-3037