Dynamic Driver Allocation from Management Ledger with Transaction Table Driver Has Very Slow Performance
(Doc ID 2537407.1)
Last updated on MARCH 13, 2023
Applies to:
Oracle Financial Services Profitability Management - Version 8.0.0 and laterInformation 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 |