My Oracle Support Banner

PRODDIFFSIL And PRDITMUDSIL Failed Due To Value Larger Than Specified Precision Allowed For ROW_WID column (Doc ID 2767290.1)

Last updated on APRIL 09, 2021

Applies to:

Oracle Retail Merchandising Insights - Version 15.0.1 and later
Information in this document applies to any platform.

Symptoms

Sequence of RADM01.W_RTL_ITEM_GRP1_D_SEQ.NEXTVAL exceeded Maximum length.

Which need to be 10 and currently it’s extraction length is 11. Column in which data is been inserted is ‘ROW_WID’ of W_RTL_ITEM_GRP1_D table.

ERROR
-----------------------
ODI-1228: Task SIL_RetailItemDiffDimensionLoad (Integration) fails on the target ORACLE connection ORACLE_BI_APPLICATIONS.
Caused By: java.sql.SQLDataException: ORA-01438: value larger than specified precision allowed for this column

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)
at oracle.jdbc.driver.T4C8Oall.processError(T4C8Oall.java:931)
at oracle.jdbc.driver.T4CTTIfun.receive(T4CTTIfun.java:481)


Changes

 

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
Changes
Cause
Solution


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