My Oracle Support Banner

EAM: Build Search Index For EP_RE_PAYMENT_INS (Lease Payment Insights) Fails for MS SQL Server. (Doc ID 3077748.1)

Last updated on MARCH 24, 2025

Applies to:

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

Symptoms

When building full index for Search Definition EP_RE_PAYMENT_INS (Lease Payment Insights) dashboards, the process fails with the below error in SQL Server.

Error:

Stmt #: 8641 Error Position: 0 Return: 8603 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'TO_DATE' is not a recognized built-in function name.
Error in running query because of SQL Error, Code=8603, Message=[Microsoft][ODBC Driver 17 for SQL Server][SQL Server]'TO_DATE' is not a recognized built-in function name.


Steps to replicate:

1. Use the Deploy Search Definition page to deploy the search definition (PeopleTools, Search Framework, Administration, Deploy Search Objec1.1ts).
       i.e. EP_RE_PAYMENT_INS (Lease Payment Insights dashboard)
     
2.  Use the Schedule Search Index page to run the Build Index process (PeopleTools, Search Framework, Administration, Schedule Search Index).

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.