My Oracle Support Banner

AIF/RI: W_PDS_PRODUCT_ATTR_D_JOB Failed with Error "ORA-12899: value too large for column" (Doc ID 2953496.1)

Last updated on SEPTEMBER 26, 2024

Applies to:

Oracle Retail Demand Forecasting Cloud Service Plus - Version 23.1 and later
Oracle Retail Assortment & Item Planning Enterprise Edition Cloud Service - Version 23.1 and later
Oracle Retail Merchandise Financial Planning Cloud Service - Version 23.1 and later
Oracle Retail Predictive Application Server Cloud Edition - Version 22.1 and later
Oracle Retail AI Foundation Cloud Service - Version 23.1 and later
Information in this document applies to any platform.

Symptoms

The Retail Insights Nightly Batch job W_PDS_PRODUCT_ATTR_D_JOB has failed. The following error is seen in the POM log:
ORA-12899: value too large for column \\\"RDX01\\\".\\\"W_PDS_PRODUCT_ATTR_D\\\".\\\"INTEGRATION_ID\\\" (actual: 82, maximum: 80)\\

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!

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