My Oracle Support Banner

GLSTPM: Program Add/Delete Summary Templates Not Using Performance Hints (Doc ID 2327753.1)

Last updated on JANUARY 29, 2019

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
GLSTPM: Program - Add/Delete Summary Templates
GLSIMS: Program - Incremental Add/Delete Summary Templates
GLSMST: Program - Maintain Summary Templates

Goal

Executing any of the following summary templates programs results in poor performance:

GLSTPM: Program - Add/Delete Summary Templates
GLSIMS: Program - Incremental Add/Delete Summary Templates
GLSMST: Program - Maintain Summary Templates

After setting up the recommended performance hints per R12: GLSTPM Performance Issue with Add/Delete Summary Templates Program (Doc ID 960769.1), the programs are still not using the defined performance hints during execution, resulting in continued poor performance.
Reviewing the trace files and tkprof results reveals that full table scans are still being performed on gl_code_combinations, gl_balances, etc.

Why are the performance hints not being utilized?

Solution

To view full details, 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 a vibrant support community of peers and Oracle experts.