My Oracle Support Banner

R12 Error in Journal Posting in the Following Routines: fun_bal_pkg, glpciba, glpiil ORA-00979: not a GROUP BY expression (Doc ID 2372293.1)

Last updated on JULY 01, 2019

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

Error in Intercompany entries Posting ibn General Ledger. The posting log displays below error in fun_bal_pkg procedure:

 

ERROR:

GLPPOSS: Posting: Single Ledger
.....
>> fun_bal_pkg() 21-FEB-2018 13:00:51
<x fun_bal_pkg() 21-FEB-2018 13:00:51
<x glpciba() 21-FEB-2018 13:00:51
<x glpiil() 21-FEB-2018 13:00:51
<< glucmt() 21-FEB-2018 13:00:51
PPOS0002: Posting terminated with fatal errors

 

Relevant file version:

This version is returned:  $Header: funbalpkgb.pls 120.31.12010000.69


ERROR details
Intercompany journal balancing errored out at fun_bal_pkg.journal_balancing with the following reason: ORA-00979: not a GROUP BY expression 

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.