EGL9.2: Elastic Search error on deploying EP_GL_JOURNAL Search Definition : "The current user has insufficient privileges to complete this operation"

(Doc ID 2414941.1)

Last updated on JUNE 25, 2018

Applies to:

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

Symptoms

On : 8.56.08 Finance 9.2 image 27 version from 8.55.13 FM 9.2 Image 22 , Journal / Ledger Inquiry

After installing the Elastic search DKP version 04 and trying to deploy the search category EP_GL_JOURNAL , the following error occurs :


ERROR
-----------------------
 "The current user has insufficient privileges to complete this operation"


Query security check
User does not have access to query/records involved in the query : GL_SRCH_JRNL_LN
  
Query field check
Fields are not found in query : GL_SRCH_JRNL_LN.A.FOREIGN_CURRENCY, GL_SRCH_JRNL_LN.A.JRNL_LN_REF, GL_SRCH_JRNL_LN.A.LINE_DESCR

STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Build search indexes for EP_GL_JOURNAL
2. Error occurs
3. Running audit, and other error occurs

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