ORA-01438

R12 WEB ADI: Errors With 'Cannot Execute SQL statement' And 'ORA-01438: value larger than specified precision allowed for this column' [ID 1107753.1]

Applies to:

Oracle Assets - Version 12.1.2 and later
Information in this document applies to any platform.
Checked for relevance on 14-Jun-2011

Symptoms

While uploading assets through WEBADI, the import process fails with below error message.

Error
-----

 "Cannot Execute SQL statement".

BNE Log

----------

Web ADI Upload Job 61129 ERROR BneBaseSQL.executeUpdate: Exception while running query.  Error Code: 1438, Message: ORA-01438: value larger than specified precision allowed for this column.

Web ADI Upload Job 61129 ERROR          BneBaseSQL.executeUpdate: Query: INSERT INTO FA_MASS_ADDITIONS(INVOICE_NUMBER,ALLOWED_DEPRN_LIMIT,...

Cause

The cause of this problem has been identified and verified in published Bug 9495140 : WEBADI FAILED WITH ORA-01438 VALUE LARGER THAN SPECIFIED PRECISION

The LIFE_IN_MONTHS field, in table FA_MASS_ADDITIONS, maximum allowed value is a 4 digit number whereas the entered value exceeds this maximum value.

Solution

Correct the data by changing the life of the asset so life in month does not exceed this maximum allowed value of a 4 digit number.