Benefits Administration Error: Cannot insert the value NULL into column 'EFFDT', table PS_HEALTH_BENEFIT with PSPBAENR_I_HTH Statement
(Doc ID 1269201.1)
Last updated on AUGUST 07, 2024
Applies to:
PeopleSoft Enterprise HCM Benefits Administration - Version 9 and laterInformation in this document applies to any platform.
Symptoms
Benefits Administration Open Enrollment Information Center > Troubleshooting Benefits Administration > Troubleshooting Benefits Administration Errors
When attempting to run the benefit administration batch process, the following error occurs.
ERROR
-----------------------
Application Program Failed
Action Type : SQL UPDATE
In Pgm Section : SQLRT: EXECUTE-STMT
With Return Code: 08667
Error Message : [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'EFFDT', table 'HR90TST.dbo.PS_HEALTH_BENEFIT'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Native Client][SQL Server]The statement has been terminated. (SQ
Stored Stmt : PSPBAENR_I_HTH
SQL statement text not available.
See the SQL trace for statement text
when this cursor was last compiled.
ERROR EMPLID=xxxx ,BENEFIT_RCD#= 0
Application Program Failed
In Pgm Section : INSERT-HTH
With Return Code: 08667
Error Message : [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'EFFDT', table 'HR90TST.dbo.PS_HEALTH_BENEFIT'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Native Client][SQL Server]The statement has been terminated. (SQ
Application Program Failed
In Pgm Section : PROCESS-PAR-OPTIONS(PSPBAENR)
With Return Code: 08667
Error Message : [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'EFFDT', table 'HR90TST.dbo.PS_HEALTH_BENEFIT'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Native Client][SQL Server]The statement has been terminated. (SQ
Application Program Failed
In Pgm Section : MAIN(PSPBASCH)
With Return Code: 08667
Error Message : [Microsoft][SQL Native Client][SQL Server]Cannot insert the value NULL into column 'EFFDT', table 'HR90TST.dbo.PS_HEALTH_BENEFIT'; column does not allow nulls. INSERT fails.
[Microsoft][SQL Native Client][SQL Server]The statement has been terminated. (SQ
Enrollment did not finish at 11:10:22.01 !!!!!
ADDITIONAL ERROR message seen:
Option Processing Started at 16:32:37.78.
Plan Type 1O
entries not found in the benefit program CLK
Check Messages!!!
ERROR EMPLID=xxxx ,EMPLRCD#= 0
Application Program Failed
In Pgm Section : GET-EVENT-RULES
ERROR EMPLID=xxxx ,BENEFIT_RCD#= 0
Application Program Failed
In Pgm Section : ELECT-OPTIONS(PSPBAELT)
Application Program Failed
In Pgm Section : PROCESS-PAR-OPTIONS(PSPBAENR)
Application Program Failed
In Pgm Section : MAIN(PSPBASCH)
Enrollment did not finish at 16:32:39.38 !!!!!
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Goto: Benefits> Manage Automated Enrollment> Events> Run Automated Benefit Processing
2. Enter Schedule ID
3. Run the batch process and above error message is seen
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 |