My Oracle Support Banner

EAM: Saving AM Transaction Reversal in MSSQL Database Results to Errors, i.e. [ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'SELECT' (Doc ID 3012616.1)

Last updated on MARCH 28, 2024

Applies to:

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

Symptoms

After populating Transaction Reversal page, then, saving, user gets the following errors.  This seemed to be an issue specific to MS SQL database.

Error/s:

First error:

A fatal PeopleCode SQL error occurred. Please consult your system log for details.

2nd error:

SQL error in Exec. (2,280) AM_TRANSACTION_REVERSAL.TransactionReversal.OnExecute Name:ReverseInitialAddition PCPC:10295 Statement:122
Called from:AM_TRANSACTION_REVERSAL.TransactionReversal.OnExecute Name:UpdateTablesInSavePostChange Statement:65
Called from:AM_TXN_REVERSAL.GBL.SavePostChange Statement:10

During the execution of SQL, an error occurred, shown in the logs in the Exec subroutine. The preceding message should have described the SQL being executed.

[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could noŜ
Statement: INSERT INTO PS_DPR_RPT_DEL_KIB (SELECT BUSINESS_UNIT,ASSET_ID,BOOK,FISCAL_YEAR,ACCOUNTING_PERIOD,CF_SEQNO,CATEGORY,:1 FROM PS_DEPR_RPT WHERE BUSINESS_UNIT = :2 AND ASSET_ID = :3)

Original Statement: INSERT INTO PS_DPR_RPT_DEL_KIB (SELECT BUSINESS_UNIT,ASSET_ID,BOOK,FISCAL_YEAR,ACCOUNTING_PERIOD,CF_SEQNO,CATEGORY,Útetimein(:3) FROM PS_DEPR_RPT WHERE BUSINESS_UNIT = :1 AND ASSET_ID = :2)
PSAPPSRV.2140 (1888) 1-4 17.49.34 100.775000 SQL error. Function: SQLExec

Error Position: 0

Return: 8601 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near the keyword 'SELECT'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Incorrect syntax near ')'.
[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Statement(s) could noŜ

Steps to replicate:

1.  Add a new Asset with future dates, then, Capitalize.
     (Asset Management > Asset Transactions > Owned Assets > Basic Add)
2.  Run Depreciation Calculation.
     (Asset Management > Depreciation > Processing > Calculate Depreciation)
3.  Make Transaction Reversal for the Asset.
     (Asset Management > Asset Transactions > Financial Transactions > Transaction Reversal)

See replication document here.

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.