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 FEBRUARY 01, 2017

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9 and later
Information 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=12055 ,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=12055 ,EMPLRCD#= 0

Application Program Failed
In Pgm Section : GET-EVENT-RULES

ERROR EMPLID=12055 ,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

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