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.

Symptoms

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

 
 

FILE VERSION

---------------

 

To check the file version:

 

This version is returned

$Header: funbalpkgb.pls 120.31.12010000.69



ERROR
-----------------------

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




STEPS
-----------------------
 
Run posting for an adjustment journal

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.