Error from BEN100a.SQR Run- SQL Status = 1400, SQL Error = ORA-1400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_PER"."MEDICARE_ELIG_RSN")

(Doc ID 2062794.1)

Last updated on JANUARY 04, 2018

Applies to:

PeopleSoft Enterprise HCM Human Resources - Version 9.1 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

When the benefits snapshot BEN100a.sqr runs, it generates an error for NULL values.

SQL Status = 1400, SQL Error = ORA-1400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_PER"."MEDICARE_ELIG_RSN")

The issue can be replicated in certain circumstances:

1. Create a fresh run control ID and date for the Ben100a run
2. Run the process.
3. Check the log for this message:

The following error was generated: SQL Status = 1400, SQL Error = ORA-1400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_PER"."MEDICARE_ELIG_RSN")


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