My Oracle Support Banner

When crawling index or running Audit on Search Definition, getting error like %QUERYFIELD:RECORD:FIELD% Is Not In The Query (Doc ID 2398515.1)

Last updated on JANUARY 13, 2020

Applies to:

PeopleSoft Enterprise ELM Enterprise Learning Management - Version 9.2 and later
PeopleSoft Enterprise HCM Human Resources - Version 9.2 and later
Information in this document applies to any platform.


When trying to schedule an index, or when trying to run an Audit on that index from the Deploy/Delete Object page, an error is thrown with the format:  %QUERYFIELD:RECORD:FIELD% Is Not In The Query
For example: %QUERYFIELD:LM_SRCH_ACT:LM_SRCH_TITLE% is not in the Query (241,218) PTSF_ES.ESIMPL.IngestService.OnExecute


Steps to replicate

  1. Schedule the Full index from PeopleTools - Search Framework - Administration - Schedule Search Index
  2. OR navigate to PeopleTools - Search Framework - Administration - Deploy/Delete Object
  3. Select the index in the grid
  4. Click the 'Audit' button




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.