Programs GLSMST Maintain Summary Templates and GLSTPM Add/Delete Summary Accounts Do Not Complete (Doc ID 258433.1)

Last updated on SEPTEMBER 19, 2016

Applies to:

Oracle General Ledger - Version 11.5.7 to 11.5.10.2 [Release 11.5.7 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 19-Sep-2013***
GLSMST - Program - Maintain Summary Templates
GLSTPM - Add/Delete Summary Accounts


Symptoms

Both the Add/Delete Summary Accounts (on creating a new template) and the Program - Maintain Summary Templates processes fail to complete.
They reach the << glstmt() process and go no further. The process runs for many hours - even days without completing.

If you do a trace most of the time is spent in gl_account_hierarchies which uses a full table scan.
Also, the record count on gl_account_hierarchies is a million or more.

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