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)
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
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.
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