My Oracle Support Banner

HC_JPM_PERSON_PROFILE SES Index Is Built But The Search Is Not Working And Gives Error-"Query field referred in %QUERYFIELD:JPM_SRCH_PERSON_PROFILE_ITEMS:A.JPM_CAT_ITEM_ID2% is not in the Query (241,218) PTSF_FEED.SESFeedDataSource.OnExecute" (Doc ID 2376220.1)

Last updated on JULY 22, 2020

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.


On : 9.2 version, Other
PeopleTools 8.54.19 and HCM 9.2

HC_JPM_PERSON_PROFILE index is built but the search is not working.

 All the other searches are working except the personal profile search.

Starting program PTSF_GENFEED

Resuming the previously failed schedule from: Generating index data ,recrawl mode :Full index,langu age: Base Language and prompt: 1900-01-01- (262,92)

Generating feed for Search Definition HC_JPM_PERSON_PROFILE , for language code ENG scheduled with re-crawl mode Y

Query field referred in %QUERYFIELD:JPM_SRCH_PERSON_PROFILE_ITEMS:A.JPM_CAT_ITEM_ID2% is not in the Query (241,218) PTSF_FEED.SESFeedDataSource.OnExecute Name:execute PCPC:22699 Statement:366 Called from:PTFP_FEED.Feed.OnExecute Name:execute Statement:677 Called from:PTFP_FEED.FeedFactory.OnExecute Name:getFeedDoc Statement:244 Called from:PTSF_GENFEED.FEEDGEN.GBL.default.1900-01-01.Step01.OnExecute Statement:126

Process 394205 ABENDED at Step PTSF_GENFEED.FEEDGEN.Step01 (PeopleCode) -- RC = 25

394205 PTSF_GENFEED FEEDGEN Step01 PeopleCode 25

The issue can be reproduced at will with the following steps:
1. Go to PeopleTools> Search Framework>Administration>Deploy/Delete Object

2. Deploy the HC_JPM_PERSON_PROFILE index

3. Error pops up.




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.