EAR 9.2: AR30003 Error Getcurdt.sqc Incorrect Syntax Near the Keyword CURRENT_DATE for MSSQL

(Doc ID 1613599.1)

Last updated on MARCH 09, 2017

Applies to:

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

Symptoms

ENVIRONMENT
-------------------------
9.2 Image 1

Statement of Issue
-----------------------------------
AR30003 Error Getcurdt.sqc Incorrect Syntax Near the Keyword 'CURRENT_DATE' for MSSQL

What is Working
------------------------------
AR30003 did not error on Oracle Environment

Business Impact
---------------------------------------
Unable to complete testing

Error Message
-----------
[Microsoft][SQL Server Native Client 11.0][SQL Server]Incorrect syntax near the keyword 'CURRENT_DATE'.
getcurdt.sqc

Steps to Replicate
----------------------------
1. Log in to MSSQL environment
2. Go to AR > Receivables Analysis > Aging > Aging Detail by Unit Rpt
3. Run AR30003

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