My Oracle Support Banner

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

Last updated on FEBRUARY 05, 2019

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

Changes

 

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
Changes
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.