CD_USER Is Missing UDF6 To UDF10 Per Data Mapping Guide
(Doc ID 2204608.1)
Last updated on MAY 23, 2019
Applies to:
Oracle Utilities Advanced Spatial and Operational Analytics - Version 2.6.0.0.1 and laterInformation in this document applies to any platform.
Goal
**Examples provided in this article do not represent real life personal/confidential information**
**Disclaimer:** This KM article may include the following abbreviations:
NMS - Oracle Network Management System
OUA - Oracle Utilities Analytics
UDF - User Defined Field
On OUA v2.6.0.0.1
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
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
Goal |
Solution |
References |