Receipts Reports Issue: Receipt Journal Report ORA-00979: not a GROUP BY expression (Doc ID 1531252.1)

Last updated on JANUARY 16, 2017

Applies to:

Oracle Receivables - Version 12.1 to 12.1.3 [Release 12.1]
Oracle Receivables - Version 12.2.4 to 12.2.4 [Release 12.2]
Information in this document applies to any platform.

Symptoms

When submitting ARXRJR module: Receipt Journal Report, the logfile shows an error

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

MSG-01001: Checking if there any periods other than closed and closed pending
ORA-00979: not a GROUP BY expression
'||gc.SEGMENT7 , st . meaning ) C_FLEX_OR_STATUS_2 , cr . cash_receipt_id C_CASH_RECEIPT_ID , rc . name C_RECEIPT_CLASS , rm . name C_PAYMENT_METHOD , cr . receipt_number C_RECEIPT_NUM , substrb ( party . party_name , 1 , 50 ) C_CUSTOMER_NAME , cust_
REP-0069: Internal error
REP-57054: In-process job terminated:Terminated with error:
REP-300: MSG-01001: Checking if there any periods other than closed and closed pending
ORA-00979: not a GROUP BY expression
'||gc.SEGMENT7 , st . meaning ) C_FLEX_OR_STATUS_2 , cr . cash_receipt_id C_CASH_RECEIPT_ID , rc . name C_RECEIPT_CLASS , rm . name C_PAYMENT_METHOD , cr . receipt_number C_RECEIPT_NUM , substrb ( party . party_name , 1 , 50 ) C_CUSTOMER_NAME , cust_

 

STEPS TO REPRODUCE:

  1. Navigate to Reports / Accounting
  2. Query Receipt Journal Report
  3. Submit

Changes

Applied <PATCH 13017245>

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