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 SEPTEMBER 09, 2016

Applies to:

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

Goal

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 3.13.5.2. 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
sqlerrmc:
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
orastxtc:

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 ...

 

Solution

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