Unexpected Error When Accessing Customer Account Details Page

Last updated on JANUARY 09, 2018

Applies to:

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.

This is holding all the tests at customer's environment and it can affect their go live date, scheduled for Feb 1st.

Changes

Cause