My Oracle Support Banner

GLAMAS Mass Allocation Errors With SHRD0015 SHRD0033 SHRD0103 and ORA-00942: table or view does not exist (Doc ID 857664.1)

Last updated on DECEMBER 10, 2024

Applies to:

Oracle General Ledger - Version 12.0.0 and later
Information in this document applies to any platform.
Executable:GLAMAS - Run MassAllocations

Symptoms

When attempting to generate the Mass Allocations in General Ledger (GL), the following error occurs and is visible in the log file of the program:

ERROR
<< glamtt() 22-JUL-2011 11:35:12
SHRD0119: Deleted 0 record(s) from GL_ALLOC_JE_ID_INT.
*****************************************************
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: 0 ormoc: 0 oracoc: 0
oranor: 0 oranpr: 0 oranex: 0

SHRD0015: glamai failed:
SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1
*****************************************************
glamai() - fatal sql error

Process logging off database and exiting ...

STEPS TO REPRODUCE

  1. Under General Ledger responsibility > Journals > Generate > Allocations
  2. View the log of the program triggered

 

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!


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