How to Load a Hierarchy Using Fn_drmDataLoader
(Doc ID 1311002.1)
Last updated on AUGUST 01, 2023
Applies to:
Oracle Financial Services Analytical Applications Infrastructure - Version 7.2 and laterInformation 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 |