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

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


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