My Oracle Support Banner

Run_Add_Leaf to Add a Key Dimension Takes a Long Time in Ledger_Stat_Load Table in OFSA 4.5 (Doc ID 1422463.1)

Last updated on JULY 28, 2017

Applies to:

Oracle Financial Data Manager - Version 4.5.39 to 4.5.41
Information in this document applies to any platform.
Oracle Financial Services Applications (OFSA) 4.5
Note: All OFSA 4.5 products have reached sustaining support.


When attempting to execute run_add_leaf to add a key dimension for Ledger Stat and Instrument tables, the process is taking a lot of time in LEDGER_STAT_LOAD table.

1. Go to the OFSA_INSTALL/dbs/<OFSA release>/utilities/add_leaf directory.

SQL> @run_add_leaf

2. Found the Add Leaf takes a long time in LEDGER_STAT_LOAD table where there is 19 million rows.


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

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