Last updated on JULY 12, 2017
Applies to:Oracle Receivables - Version: 12.1.1
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
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
Million Knowledge Articles and hundreds of Community platforms