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

Applies to:

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

Symptoms

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.  

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.

STEPS
-----------------------
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

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


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