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 AUGUST 20, 2018

Applies to:

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


On : 12.1.3 version, Posting

Error in Inter Division Entries Posting

Getting error in posting of BSV (Balancing Segment Value)  journal entries in General Ledger.


The posting log displays below error in fun_bal_pkg

GLPPOSS: Posting: Single Ledger

Current system time is 21-FEB-2018 13:00:51


>> glpmai() 21-FEB-2018 13:00:51
>> glpciba() 21-FEB-2018 13:00:51

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

<x glpmai() 21-FEB-2018 13:00:51





To check the file version:


This version is returned

$Header: funbalpkgb.pls 120.31.12010000.69


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

Run posting for an adjustment journal




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.