Customer Account Search By Contact Number Error When Partial Number Or Alpha Characters Used (Doc ID 2345107.1)

Last updated on OCTOBER 13, 2022

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

<Patch 12568526> 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