Navigation Across Customer Standard Form Leads To Unexpected Error Page (Doc ID 1205505.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version: 12.1.1 and later   [Release: 12.0 and later ]
Information in this document applies to any platform.

Symptoms


On : 12.1.1 version, Customers Module

When navigating in Customers page > Accounts > Sites > Business Purposes, for the customers having more than one business purposes for a site, the following error occurs:

ERROR
-----------------------
Error Page You have encountered an unexpected error. Please contact the System Administrator for assistance.

oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT HzCustAccountSitesEOEx.CUST_ACCT_SITE_ID,
HzCustAccountSitesEOEx.CUST_ACCOUNT_ID,
...........
at oracle.apps.fnd.framework.OAException.wrapperException(OAException.java:896)
.............


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. (R) Receivables
2. (N) Customers, Simple Search for a Customer which has multiple business purposes for a site.
-Select Go
-Select Account Details
-Select 1st site Details
-Select business purpose tab
-Do not update anything.
-Select 2nd Site Details




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