DM_ITEM_CODE = "NA" In T_SRC_SALES_TMPL Table After Shipment And History Collection Completed (Doc ID 2278761.1)

Last updated on JUNE 20, 2017

Applies to:

Oracle Demantra Demand Management - Version 12.2.5.1 and later
Information in this document applies to any platform.

Symptoms

ACTUAL BEHAVIOR 
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.
 

EXPECTED BEHAVIOR
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.


BUSINESS IMPACT
 Due to this issue Sales History is not loaded into Demantra sales_data table.

Cause

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