Oracle Waveset Error With Oracle DB Table With Auto-increment Field (Doc ID 2054802.1)

Last updated on OCTOBER 19, 2016

Applies to:

Oracle Waveset - Version 8.1.1.7 and later
Information in this document applies to any platform.

Goal

Setup database table.  When saving user from OIM, we receive an error with USR_KEY field which is auto-increment field.  With the mssql db table we can work around by omitting the key field and instead use the usr_login field. That technique doesn't work with the Oracle db table.
 

Solution

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