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 OCTOBER 07, 2019

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)

Symptoms

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.

 

ERROR

[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.

 

STEPS TO REPRODUCE

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

1. Run SCD for DIM_ACTIVITY in similar scenario.

2. Check SCD log.

Changes

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.

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!


In this Document
Symptoms
Changes
Cause
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.