EGL9.2: On Define CF Display Templates Page Encountered "Invalid column name 'SYSDATE'" Error (Doc ID 2196944.1)

Last updated on DECEMBER 12, 2016

Applies to:

PeopleSoft Enterprise FIN General Ledger - Version 9.2 to 9.2 [Release 9]
Microsoft SQLServer - Version 2008 SP1 to 2014
DB2 for Linux Unix and Windows - Version 9.1 to 10.5
Information in this document applies to any platform.

Symptoms

Issue:
-------

When navigate to Main Menu > Set Up Financials/Supply Chain > Common Definitions > Design Chartfields > Chartfield Display Templates > Define CF Display Templates. The system errors out with the following peoplecode/sql error:

[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SYSDATE'.


Error:
-------

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


[Microsoft][SQL Server Native Client 11.0][SQL Server]Invalid column name 'SYSDATE'.

 

Steps to replicate:
---------------------

Navigate to Main Menu > Set Up Financials/Supply Chain > Common Definitions > Design Chartfields > Chartfield Display Templates > Define CF Display Templates


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