JBO-27122 CUR.CURRENCY_CODE Error When Clicking on Account Balance (Doc ID 2168652.1)

Last updated on AUGUST 03, 2016

Applies to:

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

Symptoms

When trying to view customer details in iReceivables, the following error occurs:

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException:
JBO-27122: SQL error during statement preparation. Statement: SELECT
/*+ leading(auas) use_nl(auas cpf) no_expand*/ distinct ( CUR.CURRENCY_CODE
) AS CURRENCY_CODE,
CUR.CURRENCY_CODE AS CURRENCY_CODE_MEANING,
CUR.NAME
FROM
HZ_CUST_PROFILE_AMTS CPA,
FND_CURRENCIES_VL CUR,
HZ_CUSTOMER_PROFILES CPF,
ar_irec_user_acct_sites_all AUAS
WHERE
CPA.CURRENCY_CODE = CUR.CURRENCY_CODE AND
CPF.CUST_ACCOUNT_PROFILE_ID = CPA.CUST_ACCOUNT_PROFILE_ID AND
CPF.CUST_ACCOUNT_ID = AUAS.CUSTOMER_ID AND
AUAS.CUSTOMER_ID = NVL(:1, AUAS.CUSTOMER_ID) AND
CPF.CUST_ACCOUNT_ID = NVL(:2, CPF.CUST_ACCOUNT_ID)
AND
(
CPF.SITE_USE_ID = AUAS.CUSTOMER_SITE_USE_ID
OR
CPF.SITE_USE_ID IS NULL


Steps to Reproduce:

Responsibility: iReceivables 2.0 Internal
Navigation
: Customer Search > Account Summary

  1. From Account Summary, click on any balance.

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