My Oracle Support Banner

Error FRM-40831 When Creating Asset Number With Long Location Address (Doc ID 2152940.1)

Last updated on FEBRUARY 21, 2019

Applies to:

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


When create asset numbers when passing the HZ Location Code with long address, the following error occurs.


FRM-40831: Truncation occurred: value too long for field CURRENT_LOCATION.


The issue can be reproduced at will with the following steps:
1. Use API EAM_AssetNumber_Pub.Update_Asset_Number to update the location of Asset.
2. The API throws an error: FND FND_AS_UNEXPECTED_ERROR N PKG_NAME EAM_ASSET_LOG_PVT N PROCEDURE_NAME instance_update_event N ERROR_TEXT ORA-06502: PL/SQL: numeric or value error: character string buffer too small
3. Create an Asset from form 'Asset Number' form using same location, results in the above error (FRM-40831).


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.