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 FEBRUARY 18, 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.


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!

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.