My Oracle Support Banner

No SCD Exists for STG_OTHER_SERVICES to Populate DIM_ACCOUNT in 8.0.6 (Doc ID 2431468.1)

Last updated on AUGUST 10, 2018

Applies to:

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

Symptoms

In Oracle Financial Services Analytical Applications (OFSAA) 8.0.6, no SCD data exists in SYS_TBL_MASTER and SYS_STG_JOIN_MASTER for TBL_NM = 'DIM_ACCOUNT' for the table STG_OTHER_SERVICES.  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.

Changes

 

Cause

To view full details, 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 a vibrant support community of peers and Oracle experts.