My Oracle Support Banner

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

Last updated on MARCH 08, 2019

Applies to:

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


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 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,
at oracle.apps.fnd.framework.OAException.wrapperException(

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


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

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