Unexpected Error When Accessing Customer Account Details Page
Last updated on JANUARY 09, 2018
Applies to:
Oracle Receivables - Version 12.2.5 and laterInformation 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.
This is holding all the tests at customer's environment and it can affect their go live date, scheduled for Feb 1st.
Changes
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