Identity Management (MOSC)

MOSC Banner

OIM: DBAT connecter passing NULL value instead of Pre-Populate value

edited Jul 19, 2016 3:08AM in Identity Management (MOSC) 3 commentsAnswered ✓

Hi,

We have table structure like below. We are using DBAT to provision user from OIM to DB table.

Provision is happening. When we add pre-populate values, USERNAME in child table passing NULL value instead of prepopulate value.

Here KeyColumn is "ID"

desc LOSUPLOAD_USERS2

Name Null Type

-------- ---- ------------

USERNAME VARCHAR2(20)

ROLE VARCHAR2(20)

EMAIL_ID VARCHAR2(40)

STATUS VARCHAR2(20)

BRANCH VARCHAR2(20)

ID VARCHAR2(10)

desc LOSUPLOAD_MAPPEDBRANCH2

Name Null Type

-------- ---- ------------

USERNAME VARCHAR2(20)

BRANCH VARCHAR2(20)

ID VARCHAR2(10)

USERNAME ROLE EMAIL_ID STATUS BRANCH ID

-------------------- -------------------- ---------------------------------------- -------------------- -------------------- ----------

USER06 11 user06@test.com active MUMBAI THANE 104

USER04 1

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center