Infor LN Integration: Include generic items in forecasting
It is now possible to include generic items in forecasting. Forecasting at generic item level is controlled by the new SCV configuration parameter SCP_LN_FORECAST_GENERIC_ITEMS. The default value for the parameter is "N"; that is generic items are excluded from forecasting by default.
The Infor LN - Demand Planning integration by default imports all planning data from Infor LN. For items, this covers the master plan items and items whose generic/derived-from item is a master plan item. For sales orders, this covers all orders where the item fits into the above definition.
Depending on the value of the SCP_LN_FORECAST_GENERIC_ITEMS configuration parameter, planning data imported from Data Lake to Inbox is adjusted to work with regular items or with generic items. For items, and all item related master data, either generic items or derived items are removed from the imported item master (by setting the deleted flags to "Y"). For transactional data, when the parameter value is ’Y’, derived items are replaced with generic items. Currently this replacement happens for imported sales history, open sales orders and customer forecast.
The SCP__LN_FORECAST_GENERIC_ITEMS new SCV configuration parameter is added:
These new SCV database views are added:
- SI_V_LN_ITEM_FILTER
- SI_V_LN_ITEM_LOCATION_FILTER
- SI_V_LN_ITEM_SUPERSESSION_FILTER
- SI_V_LN_SALES_HIST_FILTER
- SI_V_LN_SALES_OPEN_FILTER
- SI_V_LN_DEMAND_FILTER
- SI_V_LN_ITEM_TO_GENERIC_ITEM
These new mappings are added to read from the newly created views and adjust the imported records in Inbox:
- BASE_SI_V_LN_ITEM_FILTER-SI_ITEM
- BASE_SI_V_LN_ITEM_LOCATION_FILTER-SI_ITEM_LOCATION
- BASE_SI_V_LN_SALES_HIST_FILTER-SI_SALES_HIST_TRX
- BASE_SI_V_LN_ITEM_SUPERSESSION_FILTER-SI_ITEM_SUPERSESSION
- BASE_SI_V_LN_SALES_OPEN_FILTER-SI_SALES_OPEN_TRX
- BASE_SI_V_LN_DEMAND_FILTER-SI_DEMAND
These macros have been updated to apply the generic item adjustments after the import to Inbox is completed:
- SCV - LN Import Demand Master Incremental
- SCV - LN Import Demand Transactional Incremental