Credit Hold Report Errors With 'ORA-00979: Not A Group By Expression'

(Doc ID 1259815.1)

Last updated on AUGUST 24, 2016

Applies to:

Oracle Receivables - Version: 11.5.10.2 and later   [Release: 11.5.10 and later ]
Information in this document applies to any platform.

Symptoms

After upgrading database to 11.1.0.7.0, Credit Hold report fails with the following error in the log file :

ORA-00979: not a GROUP BY expression

==> SELECT ps . invoice_currency_code Currency_Main , nvl ( status . meaning , '' ) Account_Status , decode ( upper ( : p_order_by ) , 'CUSTOMER' , substrb ( party . party_name , 1 , 50 ) , NULL ) Dummy_Cust , decode ( upper ( : p_order_by ) , 'CUSTOMER
Please see attached apps check for ANY and ALL versions you wish to know about.

STEPS
--------------------------
-Receivables Manager, N: Requests : Run
-Select to run the Credit Hold Report
-Click Submit

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