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
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)
begin sql insert into ps_depreciation
(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
Million Knowledge Articles and hundreds of Community platforms