EAM 8.9+: AMDPCALC Abended with Error in SQR START Insert-Future-Depr (AMDCTRFR.SQC) When Upgrading Tools from 8.47.16 to 8.50.00 in DB2 Where No Row was Found for FETCH TRF Transaction

(Doc ID 1350562.1)

Last updated on SEPTEMBER 15, 2016

Applies to:

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


After upgrading Tools from 8.47.16 to 8.50.00, when the Asset Management Depreciation Calculation process (AMDPCALC) is run against Transfer transactions, the following error occurs:
Error in SQR
START Insert-Future-Depr (AMDCTRFR.SQC)
do Set-Cf-No-Bind-Select
begin sql insert into ps_depreciation
$Dttm_Stamp_Select '2011-03-31-'
$Depr_Tmp_Table PS_DEPR_TMP2
(SQR 5528) ODBC SQL dbexec: SQLExecute error 100 in cursor 102:
[IBM][CLI Driver][DB2/NT64] SQL0100W No row was found for FETCH, UPDATE or DELETE; or the result of a query is an empty table. SQLSTATE=02000

However, prior to the Tools upgrade, AMDPCALC went to success.




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