My Oracle Support Banner

iReceivables Error When Trying to View Receipts After Selecting a Paying Account - Oracle.jbo.SQLStmtException: JBO-27122: SQL Error During Statement Preparation (Doc ID 2999450.1)

Last updated on MAY 20, 2024

Applies to:

Oracle iReceivables - Version 12.2.1 to 12.2.13 [Release 12.2]
Information in this document applies to any platform.

Symptoms

Users are getting the following error in the iReceivables application after selecting a Paying Account and searching on Payments:

 

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT NVL(SUM (amount_due_remaining), 0) AS SUM_AMOUNT
FROM AR_PAYMENT_SCHEDULES ArPaymentSchedules,ar_irec_user_acct_sites_all ar

## Detail 0 ##
java.sql.SQLException: ORA-01427: single-row subquery returns more than one row

at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:462)
at oracle.jdbc.driver.T4CTTIoer.processError(T4CTTIoer.java:405)


Steps to Reproduce:

Responsibility: iReceivables Account Management
Navigation: Customer Search

  1. In the Accounts tab, select the Paying Account subtab.
  2. Manually enter the customer number in the 'Related Customer' field.
  3. Change 'Transaction Type' = Payments, and click on Go and get the error.

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
References


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