My Oracle Support Banner

No Data Loaded to Demantra with Error : Code IS NULL - t_ep_i_att_1 (Doc ID 1179706.1)

Last updated on FEBRUARY 03, 2019

Applies to:

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

Symptoms


No Data Loaded to Demantra even though Collect Bookings and Shipment History completes
Error in seen  t_scr_items_tmpl_err table
Code IS NULL - t_ep_i_att_1;
Collect Shipment and booking history concurrent request is now 'completing' with no errors or warnings in the Requests screen but did not bring in any data to Demantra

Steps
-----
Run collect shipment and booking history

In the process of fixing this, while running Demantra collections, this error is seen in concurrent request log:
 +---------------------------------------------------------------------------+
 Demand Planning: Version : 11.5.0
 Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.
 MSDDEMCLT module: Collect Level Type
 +---------------------------------------------------------------------------+
 Current system time is 06-JUL-2010 14:11:01
 +---------------------------------------------------------------------------+
 **Starts**06-JUL-2010 14:11:02
 **Ends**06-JUL-2010 14:13:48
 ORA-12899: value too large for column
 "MSDEM"."T_SRC_ITEM_TMPL"."T_EP_I_ATT_1" (actual: 106, maximum: 100)
 +---------------------------------------------------------------------------+
 Start of log messages from FND_FILE
 +---------------------------------------------------------------------------+
 Collecting Items
 Step 1: Cleaning up staging tables for Items
 Step 2: Populating Temporary Tables Items
 Step 3: Populating Demantra Staging Tables Items
 ORA-12899: value too large for column
 "MSDEM"."T_SRC_ITEM_TMPL"."T_EP_I_ATT_1" (actual: 106, maximum: 100)


Cause

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
  Symptoms
  Cause
  Solution
  References

This document is being delivered to you via Oracle Support's Rapid Visibility (RaV) process and therefore has not been subject to an independent technical review.

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.