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

(Doc ID 645757.1)

Last updated on DECEMBER 13, 2017

Applies to:

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


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")


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