Full Table Scan on Temp Table for Ledger to Ledger Allocations (Doc ID 273543.1)

Last updated on JULY 13, 2009

Applies to:

Oracle Financial Services Applications (OFSA) 4.5
Oracle Performance Analyzer - Version: 4.5 to 4.5.39
This problem can occur on any platform.
Checked for relevance on 13-Jul-2009.

Symptoms

In Oracle Performance Analyzer (PA) 4.5, a LEDGER_STAT to LEDGER_STAT allocation with percent distribution is experiencing slow performance.  Looking at a trace file of the process, a full table scan is done on the temporary table.

The columns in the Ledger Stat unique index are in the correct order per <<Note:158126.1>> "What are Ledger Stat Unique Index Requirements".  You have included ISO_CURRENCY_CD in the index.

You have multiple currencies/multiple ISO_CURRENCY_CD values in your LEDGER_STAT table.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms