iReceivables Error When Searching Consolidated Billing Number (Doc ID 1316148.1)

Last updated on FEBRUARY 23, 2015

Applies to:

Oracle iReceivables - Version 12.1.2 and later
Information in this document applies to any platform.
*** Checked for relevance - 1-NOV-2012***

Symptoms

Attempting to search on the Consolidated Billing Number in iReceivables Account Details and receive the following error:

Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27120: SQL error during query execution. Statement: SELECT count(*) COUNT, nvl( SUM ( amount_due_original ), 0) SUM_AMOUNT_DUE_ORIGINAL, nvl(SUM (decode(class,'PMT', ar_irec_payments.get_pymt_amnt_due_remaining(cash_receipt_id),amount_due_remaining )), 0) SUM_AMOUNT_DUE_REMAINING FROM AR_PAYMENT_SCHEDULES ArPaymentSchedulesV, ra_customer_trx ct , AR_CONS_INV_ALL ArCnsinv WHERE ( trunc( ArPaymentSchedulesV.TRX_DATE ) >= nvl2( :1 , trunc ( add_months(SYSDATE, :2 ) ) , trunc ( ArPaymentSchedulesV.TRX_DATE ))) AND ArPaymentSchedulesV.customer_trx_id = ct.customer_trx_id(+) AND ArPaymentSchedulesV.cons_inv_id = ArCnsinv.cons_inv_id AND ArPaymentSchedulesV.customer_id = auasa.customer_id AND (ArPaymentSchedulesV.CUSTOMER_SITE_USE_ID = auasa.CUSTOMER_SITE_USE_ID OR (auasa.CUSTOMER_SITE_USE_ID = -1 AND ArPaymentSchedulesV.CUSTOMER_SITE_USE_ID IS NULL)) AND auasa.USER_ID = FND_GLOBAL.USER_ID AND auasa.session_id = :3 AND AMOUNT_DUE_ORIGINAL >= nvl ( :4 , AMOUNT_DUE_ORIGINAL ) AND AMOUNT_DUE_ORIGINAL <= nvl ( :5 , AMOUNT_DUE_ORIGINAL ) AND ( ArPaymentSchedulesV.ArPaymentSchedulesV.customer_id = :6 ) AND ( :7 IS NULL OR :8 = ArPaymentSchedulesV.customer_site_use_id ) AND ( ArPaymentSchedulesV.invoice_currency_code = :9 ) AND ( ArPaymentSchedulesV.status = nvl ( :10 , ArPaymentSchedulesV.status ))
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:912)

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