Credit Hold Report Errors With 'ORA-00979: Not A Group By Expression'
Last updated on AUGUST 24, 2016
Applies to:Oracle Receivables - Version: 18.104.22.168
Information in this document applies to any platform.
After upgrading database to 22.214.171.124.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.
-Receivables Manager, N: Requests : Run
-Select to run the Credit Hold Report
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