My Oracle Support Banner

How to Use the STG_xxxxx_MASTER Staging Tables to Load Dimension Members (Doc ID 1233304.1)

Last updated on APRIL 01, 2021

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

How do you use the STG_xxxxx_MASTER staging tables to load dimension members using the fn_STGDimDataLoader program?

These tables are:

STG_COMMON_COA_MASTER
STG_GL_MASTER
STG_ORG_UNIT_MASTER
STG_PRODUCT_MASTER

Important: This program only loads leaf level values.  It cannot load node level values.  If you need to load node level values, use the alternative dimension loading program fn_drmDataLoader.  See the Data Model Utilities User Guide for instructions on using fn_drmDataLoader.

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
References


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