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 MARCH 20, 2018

Applies to:

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

Symptoms

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.

ERROR
-----------------------
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-00.00.00.000000. (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


STEPS
-----------------------
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.


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!


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