How to Setup and Run a Type 3 Ledger Stat Load Using STG_GL_DATA
(Doc ID 1278078.1)
Last updated on FEBRUARY 05, 2021
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)
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.
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
|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|