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,
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 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