My Oracle Support Banner

GLAMAS:12.2.5 Mass Allocation Does Not Work with Full Cost Allocation Option Error "ORA-00979: not a GROUP BY expression" (Doc ID 2179299.1)

Last updated on JUNE 07, 2021

Applies to:

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


Upgraded from Rel 12.1.3 to Rel 12.2.5
Wish to use the new Mass Allocation functionality in 12.2.x

See R12.1 / R12.2 : Oracle E-Business Suite Releases 12.1 and 12.2 Release Content Documents (Doc ID 1302189.1).
Section Share Allocation Formula across Ledger Currencies which states:
You may now generate allocation journals for all the ledgers in a ledger set using a single mass allocation formula.
The mass allocation formula now has the ability to override the ledger currency entered in the mass allocation formula lines allowing one mass allocation formula to be used to process each ledger within the ledger set.
This new functionality eliminates the need to create and maintain multiple instances of the same mass allocation formula for ledgers with different functional currencies.

While running mass allocations, with the full allocation option selected,
the program errors out with,
the following message in the log file:

Log files showing the error
glafcp() - execute insert sqlstmt

sqlcaid: sqlabc: 0 sqlcode: 0 sqlerrml: 0
ORA-00979: not a GROUP BY expression
sqlerrp: sqlerrd: 0 0 0 0 0 538976288
sqlwarn: sqltext:

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

orasfnmc: oraslnr: 0 orasfnml: 0
orahoc: 50 ormoc: 17 oracoc: 16
oranor: 0 oranpr: 232 oranex: 240

SHRD0015: glafcp failed:
SHRD0033: Error Status: 0
SHRD0103: Function warning number: -1
SQL error at errexit

Process logging off database and exiting ...



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

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