My Oracle Support Banner

How Are the DIM_COMMON_COA, DIM_PRODUCT, DIM_ORG_UNIT, DIM_LOB, DIM_<DIMENSION> Tables Populated? (Doc ID 2723748.1)

Last updated on NOVEMBER 12, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - 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 Profitability Management - Version 8.0.0 and later
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics - Version 8.0.0 and later
Information in this document applies to any platform.
Oracle Business Intelligence Enterprise Edition (OBIEE)
OBIEE Repository Database (RPD)
Oracle Financial Services Asset Liability Management and Funds Transfer Pricing Analytics (ALMBI / FTPBI)
Oracle Financial Services Enterprise Financial Performance Analytics (EFPA/PFTBI)
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 Enterprise Performance Management (EPM)
Attributes Members Hierarchies Module (AMHM)
User Interface (UI)
Table to Table (T2T) Data Mapping
Data Management Tools (DMT)
Reporting

Goal

Added some common chart of accounts on the AMHM UI, but dimensions are only added to some of the related tables:

-- none added to these tables
DIM_COMMON_COA
DIM_COMMON_COA_HIER
DIM_COMMON_COA_MLS

-- These tables added some custom records.

DIM_COMMON_COA_ATTR
DIM_COMMON_COA_B
DIM_COMMON_COA_TL

Most of the T2T using dim_common_coa to move data, how can to add rows to the dim_common_coa dimension table manually?

Solution

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
Goal
Solution


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