My Oracle Support Banner

Adding New Life to STL Depreciation Method Error: ORA-01438: value larger than specified precision allowed for this column. (Doc ID 2566164.1)

Last updated on AUGUST 16, 2020

Applies to:

Oracle Assets - Version 12.2.7 and later
Information in this document applies to any platform.

Symptoms


When attempting to add Depreciation Method Lives which results in Life_in_Months value > 4 digits
the following error occurs.

ERROR
-----------------------
Error ORA-01438: value larger than specified precision allowed for this column.

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Key Method = STL and tab
2. Click on the [Life Years] field
3. Enter a new life (ex 950y 11mths which is equal to 11412 mths)
4. Save and error spawns


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.