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

Last updated on AUGUST 01, 2016

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

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