EAM:AMDPREPT Error ORA-01858: a non-numeric character was found (Doc ID 1337612.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9 to 9.1 [Release 9]
Information in this document applies to any platform.
*** Checked for currency 31-Jan-2014***

Symptoms

After running the Load Depr Reporting table process (AMDPREPT), the following error occurred:
ORA-01858: a non-numeric character was found where a numeric was expected
Process ABENDED at Step AMDPREPT.DPRPT200.Step16 (SQL)

To replicate:
1. Add an asset with a pre year 2000 date.
2. Run the Depreciation Calculation process.
3. Run the Load Depr Reporting Table process.

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