DM LOAD Collect Shipment And Booking History Is Failing With Error ORA-12899 value too large for column T_EP_I_ATT_1, actual 165, maximum 100 (Doc ID 1522622.1)

Last updated on SEPTEMBER 08, 2016

Applies to:

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

Symptoms

On : 7.3.0 version, LoadData

When attempting torun Collect Shipment and Booking History (CTO), Request Set Collect Shipment and Booking History (CTO), request set is failing while trying to collect the shipment history.
One of the request in the request failing was Collect Level Type with error "ORA-12899: value too large for column "MSDEM"."T_SRC_ITEM_TMPL"."T_EP_I_ATT_1" (actual: 165, maximum: 100)"
As a result of this we could not collect any shipment history and analyze the demantra reports.

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