R12 to R12.1: Depreciation (FADEPR) Errors With ORA-01858 'a non-numeric character was found where a numeric was expected' and APP-OFA-47644

(Doc ID 1578220.1)

Last updated on JULY 26, 2017

Applies to:

Oracle Assets - Version 12.0.1 to 12.1.3 [Release 12 to 12.1]
Information in this document applies to any platform.

Symptoms

When running depreciation and closing the period, the following error occurs:

ERROR
-----------------------
ORA-01858: a non-numeric character was found where a numeric was expected.
APP-OFA-47644: Error: Unable to update depreciation period records

From the FADEPR log:
APP-FND-01564: Error ORACLE 1858 in fadudp

Cause

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