My Oracle Support Banner

"ORA-22814: attribute or element value is larger than specified in type" Error When Compiling CSD_EID_REPAIRS_V and CSD_EID_REPAIRS_INCR_V Views (Doc ID 2815780.1)

Last updated on SEPTEMBER 24, 2024

Applies to:

Oracle Depot Repair - Version 12.2.10 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.10 version, Endeca Integration (v5 and lower)

After upgrading from 12.1.3 to 12.2.10, the CSD_EID_REPAIRS_V and CSD_EID_REPAIRS_INCR_V views are invalid. When compiling them, the following error occurs:

ERROR
-----------------------
ORA-22814: attribute or element value is larger than specified in type


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Compile  CSD_EID_REPAIRS_V and  CSD_EID_REPAIRS_INCR_V views:

ALTER VIEW CSD_EID_REPAIRS_V COMPILE;
SHOW ERRORS VIEW CSD_EID_REPAIRS_V;
ALTER VIEW CSD_EID_REPAIRS_INCR_V COMPILE;
SHOW ERRORS VIEW CSD_EID_REPAIRS_INCR_V;
 
 
 

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
References


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