My Oracle Support Banner

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

Last updated on FEBRUARY 14, 2019

Applies to:

Oracle General Ledger - Version 11.5.7 to [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


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.


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.