SCD Missing to Populate DIM_ACCOUNT from STG_OTHER_SERVICES
(Doc ID 2503681.1)
Last updated on JULY 26, 2019
Applies to:Oracle Financial Services Data Foundation - Version 8.0.0 and later
Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 184.108.40.206 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
For Oracle Financial Services Profitability Management (PFT) 8.0.x, no SCD data exists for STG_OTHER_SERVICES in SYS_TBL_MASTER and SYS_STG_JOIN_MASTER for the following:
TBL_NM = 'DIM_ACCOUNT'
STG_TBL_NM = 'STG_OTHER_SERVICES_V
There is no MAP_REF_NUM for STG_OTHER_SERVICES. As a result, there is no way to transfer Account Numbers from STG_OTHER_SERVICES into DIM_ACCOUNT.
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