CLE: FA Asset Disposal Report is Ending in Error: "ORA-06502: PL/SQL: numeric or value error: character string buffer too small"
(Doc ID 2834662.1)
Last updated on JANUARY 21, 2022
Applies to:
EMEA Add-on Localizations - Version 12.1 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run CLE: FA Asset Disposal Report,
the following error occurs.
ERROR
-----------------------
Calling XDO Data Engine...
[121421_142427391][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
[121421_142427391][][EXCEPTION] SQLException encounter while executing data trigger....
java.sql.SQLException: ORA-06502: PL/SQL: numeric or value error: character string buffer too small
ORA-06512: at line 2
STEPS TO REPRODUCE
-----------------------
The issue can be reproduced at will with the following steps:
1. Create and Asset / Query an existing Asset → Retire the Asset
2. Once the Asset is retired, Run program ‘Calculate Gain and Losses’.
3. Run CLE: FA Asset Disposal Report for the details.
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 |