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.


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.

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(
at oracle.jdbc.driver.T4CTTIoer.processError(
at oracle.jdbc.driver.T4C8Oall.processError(
at oracle.jdbc.driver.T4CTTIfun.receive(




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

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