EAM: AMDPCALC fails with error: date format not recognized

(Doc ID 2062146.1)

Last updated on AUGUST 22, 2017

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Depreciation process in in error

Depreciation process is failing with the error message as "Process AMDPCALC sqr gave error and process instance is 19612. Fix the problem and restart AM_DEPR_C ALC. (8800,18) " .
The AMDPCALC SQR is going into error.
The SQR is running to error at the below SQL:

  SELECT TO_CHAR(SYSTIMESTAMP,'DD-MON-YYYY_HH:MI:SS.FF_AM') FROM DUAL
 

ERROR
-------

This error is given by AM_DEPR_CALC app engine
Process 19611 ABENDED at Step AM_DEPR_DATE.911021.Step20 (PeopleCode) -- RC = 4 .19611 AM_DEPR_DATE 911021 Step20 PeopleCode 4

This error is given by AMDPCALC SQR
Round-Generic
(SQR 5528) ORACLE OCIStmtExecute error 1821 in cursor 167:
  ORA-01821: date format not recognized 

STEPS
------
The issue can be reproduced at will with the following steps:
1. ADD asset
2. Run depreciation

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