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 JUNE 07, 2024
Applies to:
PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 to 9.2 [Release 9]Information in this document applies to any platform.
Symptoms
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:
- Hire a new Employee.
- Modify Job Data Effective date to the future date.
- Assign Employee to a Benefit program with the same future date. Navigation:
- Run Full Build Index for HC_BEN_BENEFIT_HST2. Navigation:
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 |