T_SRC_SALES_TMPL_ERR WITH ITEM IN SALES DOES NOT EXIST IN ITEMS

(Doc ID 1907455.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 7.3.1 version, LoadData

ACTUAL BEHAVIOR
---------------
On running data import to Demantra the import is failing with errors in the
t_src_sales_tmpl_err with 'item does not exist in Items'. Looking at the
tables, the item in question exists in t_ep_item, but it does not exist in Items.

There were no errors when running EP_LOAD_ITEMS.
There were no records in T_SRC_ITEM_TMPL_ERR.


EXPECTED BEHAVIOR
-----------------------
Data in t_ep_item should get loaded into items

 

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Load

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Run Data Load

 


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