My Oracle Support Banner

Performance Issue With HC_JPM_PERSON_PROFILE Search Index Process (Doc ID 3038552.1)

Last updated on AUGUST 05, 2024

Applies to:

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

Symptoms

Performance issue with building the Search Index: HC_JPM_PERSON_PROFILE. It is taking 7 hours or more to build the Index.
This process is performing a full table scan on PS_JPM_PROFILE.

Steps to reproduce the issue:
-----------------------------------
1. Main Menu > PeopleTools >  Search Framework  > Administration >  Schedule Search Index
2. Run search index for HC_JPM_PERSON_PROFILE , running for 7 hours or more

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!


In this Document
Symptoms
Changes
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.