My Oracle Support Banner

E-SES: Unable to Schedule Search Index: 'ORA-00942: table or view does not exist' (Doc ID 2666826.1)

Last updated on MAY 05, 2020

Applies to:

PeopleSoft Enterprise PT PeopleTools - Version 8.54 to 8.55 [Release 8.4]
Information in this document applies to any platform.

Symptoms

When using a cloned Database from Production and trying to schedule any search definitions, crawl was failing with:

Return: 942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT FILL.PTSF_SRCH_PROVIDER,FILL.PTSF_SEQ_NO,FILL.FIELDNAME,FILL.LABEL_ID,FILL.PTSF_OPT_DEFVAL,FILL.MESSAGE_SET_NBR,FILL.MESSAGE_NBR FROM PS_PTSF_OPTN_LOAD FILL where PTSF_SRCH_PROVIDER=:1

942 - ORA-00942: table or view does not exist
Failed SQL stmt: SELECT FILL.PTSF_SRCH_PROVIDER,FILL.PTSF_SEARCH_PNAME,FILL.PTSF_SEQ_NO,FILL.PTSF_SEARCH_PVALUE FROM PS_PTSF_OPTN_SAVED FILL where PTSF_SRCH_PROVIDER=:1 

 

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