My Oracle Support Banner

Refresh Benefits Snapshot Error: Cannot insert the value NULL into column 'STATE_OTHER', table 'PS_BN_SNAP_PER'; column does not allow nulls. UPDATE fails. (Doc ID 2749825.1)

Last updated on FEBRUARY 28, 2023

Applies to:

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


When running the Refresh Benefits Snapshot process (BEN100A.sqr), the following error is received:

The same error also happens to the following fields: ADDRESS1_OTHER, ADDRESS2_OTHER, ADDRESS3_OTHER, ADDRESS4_OTHER, STATE_OTHER, POSTAL_OTHER.

The issue can be reproduced at will with the following steps:
1.  Run the Refresh Benefits Snapshot process. Navigation: Benefits > Interface with Providers > Refresh Benefit Snapshot




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

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.