My Oracle Support Banner

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

Last updated on JUNE 27, 2018

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
 1. Bug Summary
 2. Fixed File(s)
 3. Recommended Patch(es)
 4. Solution Steps
References

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.