EAM: AM_DEPR_CALC Error: Process 592941 ABENDED at Step AM_DEPR_DATE.720000.Step05 (SQL) -- RC = 932 (108,524) (Doc ID 660325.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

PeopleSoft Enterprise FIN Asset Management - Version 9 and later
Information in this document applies to any platform.

This document was previously published as Customer Connection Solution 201062783




Symptoms


PeopleSoft Asset Management Information Center > Listing of AMDPCALC Error Messages and Troubleshooting Tips to Resolve Each Error > Note 660325.1


The Depreciation Calculation process AM_DEPR_CALC triggers the following error:

SQL error. Stmt #: 1604 Error Position: 122 Return: 932 - ORA-00932:
inconsistent datatypes: expected CHAR got DATE

SELECT 'Y' , A.ACCOUNTING_PERIOD , A.FISCAL_YEAR ,
TO_CHAR(A.BEGIN_DT,'YYYY-MM-DD') , TO_CHAR(A.END_DT,'YYYY-MM-DD') , ((
NULL) - (A.BEGIN_DT)) , ((( A.END_DT) - (A.BEGIN_DT)) + 1) FROM
PS_AM_DEPRCA_TAO4 A WHERE A.PROCESS_INSTANCE = 592941 AND A.SETID =
'TU1' AND A.CALENDAR_ID = '01' AND NULL BETWEEN A.BEGIN_DT AND A.END_DT

Process 592941 ABENDED at Step AM_DEPR_DATE.720000.Step05 (SQL) -- RC =
932 (108,524)

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