My Oracle Support Banner

How to Load a Hierarchy Using Fn_drmDataLoader (Doc ID 1311002.1)

Last updated on JUNE 17, 2020

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
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)

Goal

How do you load a new Hierarchy using the OFSAA Hierarchy Loader program fn_drmDataLoader?

Note: You cannot use the Hierarchy Loader to make incremental changes to a Hierarchy.  For more information, see <Document 1475199.1> "Can Fn_drmDataLoader Hierarchy Loader Make Incremental Updates to a Hierarchy?".

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
 Step 1: Populate STG_HIERARCHIES_INTF
 Step 2: Populate the STG_<dimension>_HIER_INTF table with Hierarchy information
 Step 3: Populate STG_<dimension>_B_INTF and STG_<dimension>_TL_INTF
 Step 4: Verify Correct Data Exists in FSI_DIM_LOADER_SETUP_DETAILS
 Step 5: Execute fn_drmDataLoader
 Step 6: Run the Reverse Population program to populate OFSA_IDT_ROLLUP
References

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