EAM: MTM DELETE ASSET ACCNTG ENTRIES ABENDED AT STEP MTM_LIB_AM.00000170.STEP10 (Doc ID 2202941.1)

Last updated on NOVEMBER 11, 2016

Applies to:

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

Symptoms

MTM Delete Asset Accntg Entries Transaction goes to No Success with the following error on Microsoft SQL RDBMS:

 

ERROR
-----------------------
Process XXXXX ABENDED at Step MTM_LIB_AM.00000170.Step10 (SQL) -- RC = 8601
(108,524)

File: e:\pt85505c-retail\peopletools\src\psappeng\aedebug.hSQL error. Stmt #:
1723 Error Position: 0 Return: 8601 - [Microsoft][SQL Server Native Client
11.0][SQL Server]Incorrect syntax near 'DIST_ LN'. [Microsoft][SQL Server
Native Client 11.0][SQL Server]Statement(s) could not be prepared. (SQLSTATE
37000) 8180 Failed SQL stmt: DELETE FROM PS_DIST_LN DIST_LN WHERE
DIST_LN.BUSINESS_UNIT = 'US001' and DIST_LN.BO OK = 'FEDERAL' and
DIST_LN.ACCOUNTING_DT = '2016-08-24'



STEPS
-----------------------
The issue can be reproduced at will with the following steps:
Step 1: Go to Run Mass Transactions
Step 2: Select "Delete Asset Accntg Entries"
Step 3: Pick a BU, Book, and Date (US001, FEDERAL, Today)
Step 4: Run



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