BEN100A Snapshot Error: Cannot insert the value NULL into column 'BN_ACA_ELIG_IND', table 'HRDEV.dbo.PS_BN_SNAP_JOB'; column does not allow nulls. INSERT fails. (Doc ID 2062225.1)

Last updated on OCTOBER 13, 2015

Applies to:

PeopleSoft Enterprise HCM Benefits Administration - Version 9.2 to 9.2 [Release 9]
Information in this document applies to any platform.

Symptoms

The BEN100A snapshot process errors with the below error:


ERROR
-----------------------
Ben100A process ran to error


Cannot insert the value NULL into column 'BN_ACA_ELIG_IND', table 'HRDEV.dbo.PS_BN_SNAP_JOB'; column does not allow nulls. INSERT fails.

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