My Oracle Support Banner

Maintain Summary Templates (Glsmst) Failed To Complete ORA-01427 (Doc ID 577934.1)

Last updated on AUGUST 21, 2019

Applies to:

Oracle General Ledger - Version 11.5.9 to 11.5.10.2 [Release 11.5.9 to 11.5.10]
Information in this document applies to any platform.
***Checked for relevance on 13-APR-2013***

Symptoms

Maintain Summary templates program failed to complete.

During this weekend Summary Templates have been dropped and re-built in course of Operational
maintenance. Dropped Summary Templates Added 5 new Budget Activities Templates were re-built and
are current.

Program - Incremental Add/Delete Summary Templates completed successfully.
Program - Maintain Summary Templates completed with an Error.

STEPS
Login to General Ledger
Navigate -> Others -> Request -> Single Request -> ok
submit "Program - Maintain Summary Templates"

Errors shown in the log of this program:

GLSMST module: Program - Maintain Summary Templates 

>> glsutc() 10-MAY-2008 22:06:10
SHRD0114: Executing Pro*C statement Update gl_temporary_combinations...

SHRD0043: ERROR: ORA-01427: single-row subquery returns more than one row


Changes

Added new Accounts and Summary Templates

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.