My Oracle Support Banner

Build Search Index EP_GL_LEDGER_KIB Fails In SQL Server (Doc ID 2819374.1)

Last updated on NOVEMBER 04, 2021

Applies to:

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

Symptoms

Tools: 8.58.09
App: FSCM 9.2.38
DB: MS SQL Server

Search Index EP_GL_LEDGER_KIB Fails in MS SQL Server

ERROR
-----------------------
Starting program PTSF_GENFEED (35,36)

Initiating document indexing (262,2001)

File: E:\PT858P09C_2101131159-retail\peopletools\src\pssys\qpm.cppSQL error. Stmt #: 8495 Error Position: 0 Return: 8602 - [Microsoft][ODBC Driver 17 for SQL Server][SQL Server]Conversion failed when converting the varchar value ' 0USD ' to data type smallint. (SQLSTATE 22018) 245


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1.Deploy search definition for EP_GL_LEDGER_KIB. Click on item and then click on Deploy at bottom of page
2.Build Search Index. Click on Run.

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.