Data Load Via Integration Interface With This Error ORA-01438: Value Larger Than Specified

(Doc ID 2207353.1)

Last updated on MARCH 08, 2017

Applies to:

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

Symptoms

On : 12.2.4 version, Workflow

When attempting to run an workflow with transfer step to load data in sales_data table,
the following error occurs.

ERROR
-----------------------

2016-09-03 12:39:56,557 SAST [Update_27228] ERROR update.process: Update Record: Update Data: Id: 1472890915490, User: dm, WS: 1657, Update Table: SALES_DATA, Combination: L22M1L497M4L424M5472, records:52, From Date: 10-05-2015
UPDATE SALES_DATA SET (HIST_2015,LAST_UPDATE_DATE) = (SELECT (CASE ? WHEN 0 THEN SALES_DATA.HIST_2015 ELSE (? * (CASE ? WHEN 1 THEN T_UPDATE_LIST.xx_hist_fcst * 1 WHEN 2 THEN T_UPDATE_LIST.GLOB_PROP * 1 ELSE T_UPDATE_LIST.PERIOD_ALLOC END) / ?)/(T_UPDATE_LIST.UNIT * ?) END) HIST_2015
,SYSTIMESTAMP LAST_UPDATE_DATE
FROM T_UPDATE_1657_387_90513329 T_UPDATE_LIST
WHERE SALES_DATA.ITEM_ID = T_UPDATE_LIST.ITEM_ID
AND SALES_DATA.LOCATION_ID = T_UPDATE_LIST.LOCATION_ID
AND SALES_DATA.SALES_DATE = T_UPDATE_LIST.SALES_DATE
AND T_UPDATE_LIST.SALES_DATE BETWEEN TO_DATE(?,'mm-dd-yyyy')
AND TO_DATE(?,'mm-dd-yyyy'))
WHERE EXISTS (SELECT 0
FROM T_UPDATE_1657_387_90513329 T_UPDATE_LIST
WHERE SALES_DATA.ITEM_ID = T_UPDATE_LIST.ITEM_ID
AND SALES_DATA.LOCATION_ID = T_UPDATE_LIST.LOCATION_ID
AND SALES_DATA.SALES_DATE = T_UPDATE_LIST.SALES_DATE
AND T_UPDATE_LIST.SALES_DATE BETWEEN TO_DATE(?,'mm-dd-yyyy')
AND TO_DATE(?,'mm-dd-yyyy'))
2016-09-03 12:39:56,559 SAST [Update_27228] ERROR update.process:
java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into Workflow Manager.
2. Run an workflow with a transfer step.
3. It fails.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot run the workflow with the transfer step. Because of this, the history data can not be loaded into demantra application.

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