OUBI 2.2.1 - TD_STATUS_KEY is not being populated from CD_TD_STATUS dimension table

(Doc ID 1154384.1)

Last updated on JULY 20, 2010

Applies to:

Oracle Utilities Customer Care and Billing - Version: 2.2.0 and later   [Release: 2.2 and later ]
Information in this document applies to any platform.

Goal



TD_STATUS_KEY is not being populated from CD_TD_STATUS dimension table for 2 fact tables CF_RECENT_TD_ENTRY & CF_RECENT_TD_ENTRY

###Steps ###
1. Extract data files from CCB 2.3
a. CD_TD_STATUS
b. CF_RECENT_TD_ENTRY
c. CF_TD_ENTRY

2. Load data data into OUBI database.

3. TD_STATUS_KEY in the 2 fact tables will be mapped to "0" Key, due to the reason, TD_STATUS_CD do not have matching records in CD_TD_STATUS table

4. Please see following Queries :
------------------------------------------------------------------------------
SELECT DISTINCT TD_STATUS_CD FROM STG_RECTD_EXT ;

C
O
W
------------------------------------------------------------------------------
SELECT DISTINCT TD_STATUS_KEY FROM CF_RECENT_TD_ENTRY ;

0

------------------------------------------------------------------------------
SELECT DISTINCT TD_STATUS_CD FROM STG_TDENT_EXT ;

C
O
W
------------------------------------------------------------------------------
SELECT DISTINCT TD_STATUS_KEY FROM CF_TD_ENTRY ;

0
------------------------------------------------------------------------------
SELECT distinct TD_STATUS_KEY, TD_STATUS_CD FROM CD_TD_STATUS ;

0 ***
18 WRKD
19 OPWR
20 OPEN
16 ALLE
17 CMPL


Solution

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms