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 18.104.22.168 [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!