My Oracle Support Banner

How to Setup and Run a Type 3 Ledger Stat Load Using STG_GL_DATA (Doc ID 1278078.1)

Last updated on OCTOBER 19, 2018

Applies to:

Oracle Financial Services Analytical Applications Infrastructure - Version 7.1 and later
Oracle Financial Services Profitability Management - Version 6.1 and later
Oracle Financial Services Funds Transfer Pricing - Version 6.1 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)

Goal

This document provides detailed instructions for setting up and executing a Type 3 (Type III) Ledger Stat Load.  The Type 3 load takes data from STG_GL_DATA and transfers it into the LEDGER_STAT table.  This document clarifies and expands upon the instructions listed in the OFSAA Data Model Utilities Guide for a Type III Ledger Load load.

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_GL_DATA
 Step 2: Verify data exists in the view STG_GL_DATA_V
 Step 3: If using the Type 3 Ledger Stat Load for the first time, run the GTT table creation procedure.
 Step 4: Run the Ledger Stat Load
References


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