Incorrect "where is null" Code Generated in ODI 12.2.1.3 Mapping Using Knowledge Module 'CKM Oracle'
(Doc ID 2490873.1)
Last updated on NOVEMBER 03, 2020
Applies to:
Oracle Data Integrator - Version 12.2.1.3.0 to 12.2.1.3.2 [Release 12c]Information in this document applies to any platform.
Symptoms
In an Oracle Data Integrator (ODI) 12c Mapping, the following code is observed on a Check Knowledge Module (CKM) task that loads data to an Oracle Database.
Task Type : EX_UNIT_MAIN
Task Name 1: insert Not Null errors
Task Name 2: CKM Oracle
Exe Channel: JDBC
....
Target Command:
insert into <STAGE_SCHEMA>.E$_LOOKUP_DIM
(
ODI_PK,
ODI_SESS_NO,
ODI_ROW_ID,
ODI_ERR_TYPE,
ODI_ERR_MESS,
ODI_CHECK_DATE,
ODI_ORIGIN,
ODI_CONS_NAME,
ODI_CONS_TYPE,
LOOKUP_TYPE,
LOOKUP_CODE,
LAST_UPDATE_DATE,
LOOKUP_SHORT_DESCRIPTION
)
select
SYS_GUID(),
'<SYS_GUID_VALUE>',
rowid,
'F',
'',
sysdate,
'(122)<NAME>.int_UPDT_LOOKUP_DIM',
'',
'NN',
LOOKUP_TYPE,
LOOKUP_CODE,
LAST_UPDATE_DATE,
LOOKUP_SHORT_DESCRIPTION
from <STAGE_SCHEMA>.I$_LOOKUP_DIM
where is null
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 |
References |