GLSTPM: Program Add/Delete Summary Templates Not Using Performance Hints

(Doc ID 2327753.1)

Last updated on NOVEMBER 15, 2017

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

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