My Oracle Support Banner

Update Dependent/Beneficiary Error: msg=ORA-01400: cannot insert NULL into ("SYSADM"."PS_DEP_BEN"."BIRTHDATE") (Doc ID 2417444.1)

Last updated on JUNE 29, 2018

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 and later
Information in this document applies to any platform.


If there is an employee that only has one dependent and we try to delete that dependent because it was added in error, we get a SQL error.  

1400 msg=ORA-01400: cannot insert NULL into ("SYSADM"."PS_DEP_BEN"."BIRTHDATE")

It only occurs in Production and a copy of Production, not Demo nor other environments.

The issue can be reproduced at will with the following steps:
1. Remove all Dependent rows and click save. Navigation: Benefits > Employee/Dependent Information > Update Dependent/Beneficiary




To view full details, 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 a vibrant support community of peers and Oracle experts.