My Oracle Support Banner

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

Last updated on FEBRUARY 04, 2025

Applies to:

PeopleSoft Enterprise HCM 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

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