EAM: Receiving Error When Running AMDPCALC On SQL Server (Doc ID 2141273.1)

Last updated on MAY 23, 2016

Applies to:

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

Symptoms

On : 9.2 version, PUM # 4.Depreciation - Global

 

ERROR
-----------------------

Receiving error when running AMDPCALC on SQL Server

We are receiving an error when running AMDPCALC on SQL Server:
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 208 in cursor 166:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid object name 'ps_depreciation'.
(SQR 5528) ODBC SQL dbdesc: SQLNumResultCols error 8180 in cursor 166:
  [Microsoft][SQL Server Native Client 11.0][SQL Server]Statement(s) could not be prepared.

Error in include file "d:\psoft\sqr\amdcglob.sqc" on line 1906:
  (SQR 3716) Error in SQL statement.



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Add an asset.
2. Run AMDPCALC process
3.

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot have depreciation on assets

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