Click On Transaction List In IReceivables Errors with Oracle.jbo.SQLStmtException: JBO-27122
(Doc ID 1475609.1)
Last updated on FEBRUARY 15, 2019
Oracle iReceivables - Version 12.0.6 and later Information in this document applies to any platform.
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
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!