In Migration from OFSAA 6.1 to 8.0, LEGAL_ENTITY_ID Has a DIMENSION_ID Which Overlaps With An Existing User Defined Dimension (Doc ID 2155032.1)

Last updated on JUNE 28, 2016

Applies to:

Oracle Financial Services Profitability Management - Version 8.0.0 and later
Oracle Financial Services Funds Transfer Pricing - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management - Version 8.0.0 and later
Oracle Financial Services Analytical Applications Infrastructure - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Funds Transfer Pricing (FTP)
Oracle Financial Services Asset Liability Management (ALM)
Oracle Financial Services Analytical Applications Infrastructure (OFSAAI)

Goal

Prior to running the migration of metadata from OFSA 6.1 to OFSA 8.0 it seems that the DIMENSION_ID of LEGAL_ENTITY_ID (new dimension introduced in OFSAA 8.0) overlaps with an existing dimension.

It will be quite challenging to change the DIMENSION_ID of the pre-existing custom OFSAA 6.1 dimension. Therefore, would like to change the DIMENSION_ID of LEGAL_ENTITY_ID to a different dimension ID.   How can this be done? In other words in which tables/configuration files in a running OFSAA 8.0.2 application do changes need to be made, so that the DIMENSION_ID or LEAF_NUM_ID of the LEGAL_ENTITY_ID hierarchy is no longer 5 (as it is at the moment) but rather some other value, say 20?

Solution

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 hundreds of Community platforms