Questions Related to the Definition of the SCD for DIM_LOB
(Doc ID 2436890.1)
Last updated on AUGUST 20, 2020
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)
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.
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?
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