My Oracle Support Banner

OBIA 7.9.6.4: While Creating Administrator User For DAC Receive Error - ORA-01400: cannot insert NULL into ("DAC_REPO"."W_ETL_USER"."VERSION_ID") (Doc ID 2364468.1)

Last updated on MARCH 29, 2018

Applies to:

Business Intelligence Applications Consumer - Version 7.9.6.4 to 7.9.6.4 [Release V7]
Information in this document applies to any platform.

Symptoms

DAC Administrator account password was lost. A truncate was done on table W_ETL_USER. Now attempt to create administrator encounters error:

Error while trying to create record.
MESSAGE:::INSERT INTO W_ETL_USER(ROW_WID, LAST_UPD, INACTIVE_FLG, NAME, PASSWORD, ROLES) VALUES (?, ?, ?, ?, ?, ?)
ORA-01400: cannot insert NULL into ("DAC_REPO"."W_ETL_USER"."VERSION_ID")


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.