Customer Account Search By Contact Number Error When Partial Number Or Alpha Characters Used

(Doc ID 2345107.1)

Last updated on JUNE 25, 2018

Applies to:

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

Symptoms

On : 12.2.6 version, (R) Receivables Manager

<> was applied that gives the functionality to search for Account
Contacts in Receivables.

After patch is applied, The search Account Contact screen displays with new search fields
such as Name, Contact Number, Job Title and email address.

In the Contact Number field enter a partial Contact Number with a wildcard:
Example 123%


When attempting to search for Account Contacts in the Contact Number field.  After  entering  a partial Contact Number with a wildcard:


ERROR
-----------------------

  Exception Details.
 oracle.apps.fnd.framework.OAException: oracle.jbo.SQLStmtException: JBO-27122: SQL error during statement preparation. Statement: SELECT * FROM (SELECT hcar.CUST_ACCOUNT_ROLE_ID as CARI,


STEPS
-----------------------
The issue can be reproduced at will with the following steps:

Receivables Manager > Customers > Customers

Customer search > Accounts > Communication > Contacts

Account Contacts displays.  Notice the Search fields above Account Contacts.

In the Contact Number field enter a partial Contact Number with a wildcard


BUSINESS IMPACT
-----------------------
The issue has the following business impact:
Due to this issue, users cannot search

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