Ora-01400 Ora-06512: When Attempting To Log In To SSO (Doc ID 1433371.1)

Last updated on APRIL 25, 2012

Applies to:

Oracle Application Server Single Sign-On - Version 10.1.2.0.2 to 10.1.4.3 [Release 10gR2 to 10gR3]
Information in this document applies to any platform.

Symptoms

1. Oracle Report URLs fail with SSO enabled, if disabled then Report URLs run without issue.
2. Reports use to run with SSO however started to fail recently.
3. When attempting to log into SSO the following errors are documented in the ssoServer.log:

java.sql.SQLException: ORA-01400: cannot insert NULL into ("ORASSO"."WWSSO_AUDIT_LOG_TABLE_T"."SUBSCRIBER_ID")
ORA-06512: at "ORASSO.WWSSO_AUDIT_LOG", line 216
ORA-06512: at line 1

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