Incremental Add/Delete Summary Templates Has Been Running For 72 Hours (Doc ID 396706.1)

Last updated on SEPTEMBER 29, 2010

Applies to:

Oracle General Ledger - Version: 11.5.9 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.
glsiap.lpc 115.5

Symptoms

Program - Incremental Add/Delete Summary Templates has been running for 72
hours and was terminated later. They have 2 summary templates--one for
locations and one for accounts.

Tried running it again. It still did not complete.
This time, the log shows..
ERROR: ORA-01652: unable to extend temp segment by 128 in tablespace TEMP
Had ct increase storage for TEMP table space.
This did not resolve the issue.
GLSIMS is hanging in glsiap.



Changes

Customer has hierarchy that has had more than 3,000 child ranges changed since the program 
was last run or since the summary template was created

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