My Oracle Support Banner

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

Last updated on FEBRUARY 18, 2019

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.


Changes

 

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
Changes
Cause
Solution
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
References


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