My Oracle Support Banner

HC_BEN_BENEFIT_HST2 Search Index Fails with "cannot update PS_BEN_SRCH_JH_TMP.BENEFIT_PROGRAM to NULL" Error on Future Dated Hires (Doc ID 3006892.1)

Last updated on FEBRUARY 26, 2024

Applies to:

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


HC_BEN_BENEFIT_HST2 search index fails when BEN_PROG_PARTIC has future dated row for New Hire Employee.

The issue can be reproduced at will with the following steps:

  1. Hire a new Employee.
  2. Modify Job Data Effective date to the future date.
  3. Assign Employee to a Benefit program with the same future date. Navigation: Benefits > Enroll In Benefits > Assign to Benefit Program > Assign to Benefit Program.
  4. Enroll Employee to Health Benefits with the same future date. Navigation: Benefits > Enroll In Benefits > Health Benefits > Health Benefits.
  5. Clone Employee Benefit Program with EFFDT greater than enrollment date from the previous steps. Navigation: Set Up HCM > Product Related > Base Benefits > Benefit Clone Utility > Benefit Clone Utility.
  6. Run Full Build Index for HC_BEN_BENEFIT_HST2. Navigation:PeopleTools > Search Framework > Administration > Schedule Search Index > Build Search Index.




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

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