Unexpected Error When Accessing Customer Account Details Page (Doc ID 2346093.1)

Last updated on NOVEMBER 02, 2022

Applies to:

Oracle Receivables - Version 12.2.5 and later
Information in this document applies to any platform.

Symptoms

On : 12.2.5 version, Customers Module

Unexpected Error When Accessing Customer "Account Details"Page

When attempting to access the customer account details page the following error message is displayed "You have encountered an unexpected error. Please contact the System Administrator for assistance." Use the following steps to reproduce

(R) Responsibility Receivables Manager
1. Customers -> Customers
2. Query any Customer
3. Click on the View Details button in the Account section

ERROR
-----------------------
Exception Details.
oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (select HZ_UTILITY_V2PUB.get_lookupmeaning('AR_LOOKUPS', 'RELATIONSHIP_TYPE', HzPuiCustActRelateEO.relationship_type) as relationship_type,
HzPuiCustActRelateEO.comments,
HZ_UTILITY_V2PUB.get_lookupmeaning('AR_LOOKUPS', 'CODE_STATUS', HzPuiCustActRelateEO.STATUS) as STATUS,
HzPuiCustActRelateEO.org_id,
HzPuiCustActRelateEO.rowid,
decode(HzPuiCustActRelateEO.customer_reciprocal_flag, 'Y', 'RECEP', 'NORECEP') as customer_reciprocal_flag,
decode(HzPuiCustActRelateEO.bill_to_flag, 'Y', 'BILL', 'NOBILL') as bill_to_flag,
decode(HzPuiCustActRelateEO.ship_to_flag, 'Y', 'SHIP', 'NOSHIP') as ship_to_flag,
pa.party_name as related_customer,
ra.account_number as related_account_number,
ra.account_name as related_description,
(select name from hr_operating_units where organization_id = HzPuiCustActRelateEO.org_id) as ou_name,
HzPuiCustActRelateEO.related_cust_account_id,
HzPuiCustActRelateEO.cust_account_id
from hz_cust_acct_relate HzPuiCustActRelateEO, hz_cust_accounts ra,
hz_parties pa
where HzPuiCustActRelateEO.cust_account_id = :1
and HzPuiCustActRelateEO.status= :2
and HzPuiCustActRelateEO.related_cust_account_id = ra.cust_account_id
and ra.party_id = pa.party_id) QRSLT ORDER BY related_account_number
at oracle.apps.fnd.framework.OAException.wrapperInvocationTargetException(OAException.java:996)
at oracle.apps.fnd.framework.server.OAUtility.invokeMethod(Unknown Source)
at oracle.apps.fnd.framework.server.OAApplicationModuleImpl.invokeMethod(OAApplicationModuleImpl.java:741)
at oracle.apps.ar.hz.components.base.webui.HzPuiTableBaseCO.initQuery(Unknown Source)
at oracle.apps.ar.hz.components.account.relationship.webui.HzPuiActRelViewTableCO.performQueriesPR(HzPuiActRelViewTableCO.java:82)
at oracle.apps.ar.hz.components.base.webui.HzPuiTableBaseCO.customProcessRequest(Unknown Source)
at oracle.apps.ar.hz.components.base.webui.HzPuiBaseCO.processRequest(Unknown Source)
at oracle.apps.fnd.framework.webui.OAWebBeanHelper.processRequest(OAWebBeanHelper.java:631)

BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, can not click details on any customer account.