My Oracle Support Banner

EAM Parameter Locator Error ORA-12899: Value Too Large For Column (Doc ID 2424290.1)

Last updated on MARCH 07, 2019

Applies to:

Oracle Enterprise Asset Management - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

On : 12.1.3 version, Asset Definition

When attempting to set the Intermediate Locator in EAM Parameters,
the following error occurs.

ERROR
-----------------------
ORA-12899: value too large for column "WIP"."WIP_EAM_PARAMETERS"."INTERMEDIATE_LOCATOR" (actual: 26, maximum: 20)
--------------------------------------------------------------
FRM-40735: ON-UPDATE trigger raised unhandled exception ORA-12899.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Oracle Enterprise Asset Management
2. Setup-->Parameters-->Choose any Locator which more than 20 characters-->Save
3. Error pops up

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot select the Locators which has more than 20 characters

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.