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 JANUARY 27, 2023

Applies to:

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

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