My Oracle Support Banner

EPC 9.2: Performance Issue is Observed When Building Search Index EP_PC_PROJ_RES_KIB at Step PTSF_GENFEED.INDXDATA.Step01. (Doc ID 3011709.1)

Last updated on MARCH 26, 2024

Applies to:

PeopleSoft Enterprise FIN Project Costing - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

Building the search index EP_PC_PROJ_RES_KIB is taking a longer time at step PTSF_GENFEED.INDXDATA.Step01. The PROJ_RESOURCE table has around 49 million rows.

Replication Steps:

  1. Ensure the Indexes are deployed (PeopleTools > Search Framework > Administration > Deploy/Delete Object).
  2. Schedule the search indexes EP_PC_PROJ_RES_KIB for a Full Sync. Navigation: PeopleTools > Search Framework > Administration > Schedule Search Instances - Open EP_PC_PROJ_RES_KIB run control. Use the defaults: Base Language, Full Sync.
  3. Process Monitor shows that the process is stuck at step PTSF_GENFEED.INDXDATA.Step01.



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.