Benefit Snapshot (BEN100A.SQR) Error: 1400, SQL Error = ORA-01400: Cannot Insert NULL (Doc ID 645757.1)

Last updated on AUGUST 15, 2016

Applies to:

PeopleSoft Enterprise HRMS Human Resources - Version 8.8 SP1 and later
Information in this document applies to any platform.

Symptoms

Refresh Benefit Snapshot process from Benefits > Interface with Providers > Refresh Benefit Snapshot errors with the following

SQL Status =  1400, SQL Error  = ORA-01400: cannot insert NULL into ("SYSADM"."PS_BN_SNAP_HIST"."OPRID")

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