My Oracle Support Banner

Single Allocation Rule Execution Taking Longer Than Expected Time Running Merge SQL on Large Ledger Stat Table on Database 11.2 Versions (Doc ID 1905790.1)

Last updated on MAY 10, 2021

Applies to:

Oracle Financial Services Profitability Management - Version 6.0.3 and later
Information in this document applies to any platform.
Oracle Financial Services Analytical Applications (OFSAA)
Oracle Financial Services Profitability Management (PFT)
Oracle Financial Services Enterprise Performance Management (EPM)


On Oracle Financial Services Profitability Management (PFT) 6.0.3, a single dynamic driver allocation on Ledger Stat is taking more than five hrs to execute in Exadata database. When the allocation is executed on another instance with the same dataset, it takes ~50 minutes to execute. The same is true when the merge statement is run directly from SQL*Plus.  Other allocations do not have the same issue.

Long running single dynamic driver allocation. Run time is 5 hours.

Expect the allocation to finish in ~ 1 hour.

Steps to reproduce:

The issue is only reproducible on one instance.

1. Run the allocation via PFT.


2. Manually create the global temporary table (GTT) via SQL*Plus and run the merge statement via SQL*Plus.


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.