EAM: AMDPCALC fails with error: date format not recognized
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.
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
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
(SQR 5528) ORACLE OCIStmtExecute error 1821 in cursor 167:
ORA-01821: date format not recognized
The issue can be reproduced at will with the following steps:
1. ADD asset
2. Run depreciation
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms