GLAMAS ERROR ORA-00936: MISSING EXPRESSION WHILE RUNNING MASS ALLOCATION WITH LEDGER SET (Doc ID 1538631.1)

Last updated on MARCH 08, 2017

Applies to:

Oracle General Ledger - Version 12.1.3 to 12.1.3 [Release 12.1]
Information in this document applies to any platform.

Symptoms

When attempting to Run MassAllocations
the following error occurs.

ERROR
-----------------------
*****************************************************
sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
sqlerrmc:
ORA-00936: missing expression
  
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: 15 oracoc: 14
oranor: 0 oranpr: 99 oranex: 99

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


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Log into General Ledger Super user ->Journal ->Allocation ->Run Mass Allocation

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users are unable to run Allocation hence user can't close period

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