Create Accounting in AR Gives ORA-00979: not a GROUP BY expression
Last updated on SEPTEMBER 05, 2017
Applies to:Oracle Receivables - Version 12.1.2 and later
Information in this document applies to any platform.
Concurrent Program: XLAACCUP - Create Accounting Program
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.
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