My Oracle Support Banner

Dynamic Driver Allocation from Management Ledger with Transaction Table Driver Has Very Slow Performance (Doc ID 2537407.1)

Last updated on MAY 01, 2021

Applies to:

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

Symptoms

In Oracle Financial Services Profitability Management (PFT) 8.0.3, when attempting to complete a Batch for month-end processing, there is a slow running Dynamic Driver Allocation that takes data from Management Ledger and distributes it to an instrument table using a transaction table as the driver.  The process has been running for a long time and does not complete.

The Allocation has a setup similar to the one below:

Source: Management Ledger
Driver: FSI_D_OTHER_SERVICES_TXNS
Target: FSI_D_OTHER_SERVICES

Reviewing the Execution Plan of the Allocation, it is doing a full table scan against FSI_D_OTHER_SERVICES and FSI_D_OTHER_SERVICES_TXNS:

TABLE ACCESS STORAGE FULL FSI_D_OTHER_SERVICES_TXNS
TABLE ACCESS STORAGE FULL FSI_D_OTHER_SERVICES

This appears to be causing the performance issue and you do not know how to get the process to use an index.

Cause

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
Symptoms
Cause
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.