Click On Transaction List In IReceivables Errors with Oracle.jbo.SQLStmtException: JBO-27122 (Doc ID 1475609.1)

Last updated on AUGUST 18, 2016

Applies to:

Oracle iReceivables - Version 12.0.6 and later
Information in this document applies to any platform.

Symptoms

Attempting to open the Transaction List in iReceivables and receive the following error:

Error Page
You have encountered an unexpected error. Please contact the System Administrator for assistance
Click here for exception details.

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation.
Statement: SELECT * FROM
(SELECT customer_id,
:1 customer_site_use_id,
currency_code,
total_due_original,
total_due_remaining,
total_discount,
TO_CHAR(total_due_original, FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) as total_due_original_formatted,
TO_CHAR(total_due_remaining , FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) as total_due_remaining_formatted,
TO_CHAR( -total_discount, FND_CURRENCY_CACHE.GET_FORMAT_MASK( currency_code , 30 )) as total_discount_formatted
FROM(SELECT CUSTOMER_ID,
CUSTOMER_SITE_USE_ID,
currency_code,
sum(AMOUNT_DUE_ORIGINAL) total_due_original,
sum(AMOUNT_DUE_REMAINING) total_due_remaining,
sum(DISCOUNT_AMOUNT) total_discount
FROM AR_IREC_PAYMENT_LIST_GT
group by CUSTOMER_ID, currency_code)) QRSLT
WHERE (CUSTOMER_ID = 6756)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:870)
....
....
## Detail 0 ##
java.sql.SQLException: ORA-00979: not a GROUP BY expression

Responsibility:  Collections User
Navigation:  iReceivables > Enter Customer Number and click Go
Click Account Summary for the “All Locations” Bill To Site
Click Account Balance
Select some transactions and click Add to Transaction List
Click Transaction List in top right hand corner of screen

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