Identity Management (MOSC)

MOSC Banner

Reconciliation OracleDB11gR2 to OIM 11g

edited Feb 8, 2012 4:19AM in Identity Management (MOSC) 1 commentAnswered
Hi,
I have a table with the following structure in Oracle Database 11gR2:

CREATE TABLE MY_USERS
(
USER_ID VARCHAR2 (4000 BYTE) NOT NULL ENABLE,
FIRST_NAME VARCHAR2 (4000 BYTE) NOT NULL ENABLE,
LAST_NAME VARCHAR2 (4000 BYTE) NOT NULL ENABLE,
PASSWORD VARCHAR2 (4000 BYTE),
EMAIL VARCHAR2 (4000 BYTE),
PHONE_FIX VARCHAR2 (4000 BYTE),
PHONE_MOBILE VARCHAR2 (4000 BYTE),
USER_STATUS VARCHAR2 (4000 BYTE),
LOCATION VARCHAR2 (4000 BYTE),
JOB_POSITION VARCHAR2 (4000 BYTE),
ORGANIZATIONAL_UNIT VARCHAR2 (4000 BYTE),
CONSTRAINT MY_USERS_PK PRIMARY KEY (USER_ID));


but, when I start scheduled job for reconciliation "incremental" I see the following error :

-------100: Error occured in XL_SP_ReconBlkUsrRqdcValdnMtch while Processing Batch ID 26  One or more input parameter passed as null.--------------

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