DM_ITEM_CODE = "NA" In T_SRC_SALES_TMPL Table After Shipment And History Collection Completed
Last updated on DECEMBER 18, 2017
Applies to:Oracle Demantra Demand Management - Version 22.214.171.124 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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms