My Oracle Support Banner

Questions Related to the Definition of the SCD for DIM_LOB (Doc ID 2436890.1)

Last updated on OCTOBER 10, 2018

Applies to:

Oracle Financial Services Data Foundation - Version 8.0.5 and later
Oracle Financial Services Profitability Management - Version 8.0.5 and later
Oracle Financial Services Asset Liability Management - Version 8.0.5 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.6 to 8.0.6 [Release 8]
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

Qn1: In Oracle Financial Services Data Foundation (FSDF) 8.0.5, why are there 13 extra column entries present in SYS_STG_JOIN_MASTER for DIM_LOB (MAP_REF_NUM = 132)?  The columns do not exist on DIM_LOB_V or on the target table DIM_LOB.

D_HEDGE_END_DATE
V_PROSP_EFF_MEASURE_METHOD
V_CREATED_BY
V_HEDGE_TYPE
V_INCEP_EFF_MEASURE_METHOD
V_RETRO_EFF_MEASURE_METHOD
V_LAST_MODIFIED_BY
D_LAST_MODIFIED_DATE
D_CREATED_DATE
V_HEDGE_NAME
N_HEDGE_SKEY
N_HEDGE_ID
D_HEDGE_START_DATE
 
Qn2: Why is there a mismatch is size between the columns DIM_LOB_V.V_LOB_NAME (VARCHAR2(150)) and DIM_LOB.V_LOB_NAME (VARCHAR2(20)) which can result in an error when trying to insert a name larger than 20 into DIM_LOB?

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


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