Programs GLSMST Maintain Summary Templates and GLSTPM Add/Delete Summary Accounts Do Not Complete
Last updated on SEPTEMBER 19, 2016
Applies to:Oracle General Ledger - Version 11.5.7 to 184.108.40.206 [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.
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms