EAM:AMDPREPT Error ORA-01858: a non-numeric character was found
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***
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)
1. Add an asset with a pre year 2000 date.
2. Run the Depreciation Calculation process.
3. Run the Load Depr Reporting Table process.
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