CM: FSX3004 Abends With 'to_char' Error (Doc ID 2246366.1)

Last updated on MARCH 21, 2017

Applies to:

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

Symptoms

 

ISSUE:
 
The query FIN3004_ACCOUNT_REGISTER fails when BI Report FSX4004 is run with
the following error:

ERROR:
 
[Microsoft][SQL Server Native Client 11.0][SQL Server]'TO_CHAR' is not a recognized built-in function name.

 

REPLICATION STEPS
 
Navigate to Banking>Analyze Exceptions>Transactions by Account
click the RUN REPORT button

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