Reconciliation OracleDB11gR2 to OIM 11g
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.--------------
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.--------------
0