My Oracle Support Banner

Asset Import Seeded Program Failing with Error value too large for column "INV"."MTL_EAM_ASSET_NUM_INTERFACE"."ERROR_MESSAGE" (actual: 264, maximum: 240) (Doc ID 2354325.1)

Last updated on APRIL 17, 2018

Applies to:

Oracle Enterprise Asset Management - Version 12.2.5 to 12.2.5 [Release 12.2]
Information in this document applies to any platform.

Symptoms

On :  12.2.5 version, Asset Definition

When attempting to import fixed asset in EAM, the Asset Number Import program fails with following error

UNEXPECTED ERROR IN OUTER BLOCK: ORA-12899:
value too large for column "INV"."MTL_EAM_ASSET_NUM_INTERFACE"."ERROR_MESSAGE" (actual: 264, maximum: 240)
ORA-01403: no data found


The issue can be reproduced at will with the following steps:
1. Enterprise Asset Management
2. Pending Asset Number form
3. Submit
4. observe error

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.