My Oracle Support Banner

EGL9.2: Build Search Index for EP_GL_JOURNAL_KIB (PTSF_GENFEED) Result to Error 'Error in running query because of SQL Error, Code=8602, Message=[IBM][CLI Driver][DB2] SQL0199N The use of the reserved word "OR" following "" is not valid' in DB2 (Doc ID 2880230.1)

Last updated on JUNE 30, 2022

Applies to:

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

Symptoms

Running Build Search Index for EP_GL_JOURNAL_KIB (PTSF_GENFEED) result to error:

Error:

Steps to replicate:

1.  Navigate to PeopleTools > Search Framework > Administration > Schedule Search Indexes.
2.  Populate fields for Search Definition = EP_GL_JOURNAL_KIB and run PTSF_GENFEED process.

See full replication steps here.

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.