Error FRM-40831 When Creating Asset Number With Long Location Address
Last updated on JANUARY 24, 2017
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).
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 hundreds of Community platforms