My Oracle Support Banner

GLAMAS: Run MassAllocations Errors: ORA-01422: exact fetch returns more than requested number of rows / ORA-00942: table or view does not exist (Doc ID 1490116.1)

Last updated on NOVEMBER 29, 2024

Applies to:

Oracle General Ledger - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

When attempting to run GLAMAS module: Run MassAllocations the following error occurs.

ERROR
-----------------------
ORA-01422: exact fetch returns more than requested number of rows
ORA-

*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-00942: table or view does not exist
  
sqlerrp: sqlerrd: 0 0 0 0 0 538976288
sqlwarn: sqltext:
*****************************************************

oracaid: oracabc: 0
oracchf: 0 oradbgf: 0 orahchf: 0 orastxtf: 0 orastxtl: 0
orastxtc:

orasfnmc: oraslnr: 0 orasfnml: 0
orahoc: 50 ormoc: 13 oracoc: 12
oranor: 0 oranpr: 598 oranex: 644

SHRD0015: glamtt failed:
SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1
*****************************************************

STEPS TO REPRODUCE
1.Log into general ledger
2. Navigate to Mass allocations-Generate
3. Generate Mass allocation

Changes

 

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.