My Oracle Support Banner

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.


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:


  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,

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

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




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
 1. Bug Summary
 2. Fixed Files
 3. Recommended Patches
 4. Solution Steps
 Still Have Questions?

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