DM_ITEM_CODE = "NA" In T_SRC_SALES_TMPL Table After Shipment And History Collection Completed
(Doc ID 2278761.1)
Last updated on FEBRUARY 20, 2019
Applies to:Oracle Demantra Demand Management - Version 220.127.116.11 and later
Information in this document applies to any platform.
dm_item_code is not populated in t_src_sales_tmpl table after Collection completed successfully.
It shows a value of "NA" even though item_name was collected in t_src_item_tmpl table and loaded into Demantra base tables items and t_ep_items.
dm_item_code should appear in t_src_sales_tmpl table
STEPS TO REPRODUCE
1. Run Collect Shipping and Booking History concurrent request with "Launch EP Load" = No
2. Check the t_src_sales_tmpl staging table
3. See dm_item_code is not populated.
Due to this issue Sales History is not loaded into Demantra sales_data table.
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document