CD_USER Is Missing UDF6 To UDF10 Per Data Mapping Guide (Doc ID 2204608.1)

Last updated on NOVEMBER 28, 2016

Applies to:

Goal

On : 2.6.0.0.1 version, Install / Upgrade

CD_USER is missing UDF6 to UDF10 per Data Mapping Guide

The OUA 2.6.0 Data Mapping Guide for NMS has listed the UDF1-10for CD_USER
yet in the actual DWADM schema, CD_USER only consists of UDF1-5

missing UDF6-10

desc cd_user
Name Null Type
--------------- -------- ------------
USER_KEY NOT NULL NUMBER(10)
DATA_LOAD_DTTM NOT NULL DATE
DATA_SOURCE_IND NOT NULL NUMBER(6)
USER_DESCR NOT NULL VARCHAR2(60)
USER_CD NOT NULL VARCHAR2(16)
UDF1_CD VARCHAR2(32)
UDF1_DESCR VARCHAR2(60)
UDF2_CD VARCHAR2(32)
UDF2_DESCR VARCHAR2(60)
JOB_NBR NOT NULL NUMBER(12)
EFF_START_DTTM NOT NULL DATE
EFF_END_DTTM NOT NULL DATE
UDF3_CD VARCHAR2(30)
UDF3_DESCR VARCHAR2(60)
UDF4_CD VARCHAR2(30)
UDF4_DESCR VARCHAR2(60)
UDF5_CD VARCHAR2(30)
UDF5_DESCR VARCHAR2(60)
 

Solution

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.