My Oracle Support Banner

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 OCTOBER 02, 2018

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

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
Cause
Solution
References


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