Create Accounting in AR Gives ORA-00979: not a GROUP BY expression (Doc ID 1299964.1)

Last updated on JUNE 01, 2016

Applies to:

Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.
Concurrent Program: XLAACCUP - Create Accounting Program


Symptoms

Unable to post transactions to GL. Create Accounting debug log file shows:

-979 : ORA-00979: not a GROUP BY expression
l_bal_retcode = U
l_bal_msg_count = 1
l_bal_msg_data = FND FND_AS_UNEXPECTED_ERROR N PKG_NAME FUN_BAL_PKG N PROCEDURE_NAME JOURNAL_BALANCING N ERROR_TEXT ORA-00979 not a GROUP BY expression.

Cause

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