Slow Performance for Build Job Index (HRS_SRCH_IDX) When Run with Segment Value. (Doc ID 1564493.1)

Last updated on OCTOBER 09, 2015

Applies to:

PeopleSoft Enterprise HRMS Talent Acquisition Manager - Version 9.1 to 9.1 [Release 9]
Information in this document applies to any platform.

Symptoms

Build Job Index process is taking more than 39 hours when running with segment value.

STEPS TO REPLICATE
-------------------------
The issue can be reproduced at will with the following steps:
1. Go to Main Menu > Recruiting > Administration > Build Job Index.
2. Run control Parameter is as follows: Create new collection -selected
  From Application Date- 04/25/2012
  Applicant Status to be Indexed - select all (010,020,030,040)
  Attachment Temp Directory-/opt/psoft/hrmsq9/temp
  Segment Size-21
3. Run the program.

Cause

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 hundreds of Community platforms