My Oracle Support Banner

Error in Executing SCD for DIM_ACTIVITY / DIM_ACCOUNT and DIM_ACTIVITY Have the Same MAP_REF_NUM (Doc ID 2524333.1)

Last updated on APRIL 20, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.5 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Enterprise Performance Management (EPM)
Slowly Changing Dimension (SCD)


On 8.0.5 version, SCD batch for DIM_ACTIVITY fails because DIM_ACCOUNT and DIM_ACTIVITY have the same MAP_REF_NUM.

It's been observed that with 8.0.5, there is new dimension DIM_ACCOUNT that has same map reference number (190) which was earlier assigned to DIM_ACTIVITY.



[2019/01/22 - 10:33:23] --- Summary report ---
[2019/01/22 - 10:33:23] Map Reference Number Processing Status
[2019/01/22 - 10:33:23] 190 FAILED
[2019/01/22 - 10:33:23] [ClsUModelRunner]-> Error in executing SCD.



The issue can be reproduced at will with the following steps:

1. Run SCD for DIM_ACTIVITY in similar scenario.

2. Check SCD log.


After upgrade from 7.5.3 to 8.0.5, the SYS_TBL_MASTER table didn't have any entry for DIM_ACTIVITY anymore (previously map_ref_num for DIM_ACCOUNT was '190'). The DIM_ACTIVITY batch was referring map_ref_number = 190, which was not present in SYS_TBL_MASTER.

Due to this, a new map_ref_num '903' was added for DIM_PRODUCT and '190' was added for DIM_ACTIVITY. Similarly, SYS_STG_JOIN_MASTER table has been updated for DIM_ACTIVITY.


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

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