Customer Account Search By Contact Number Error When Partial Number Or Alpha Characters Used
(Doc ID 2345107.1)
Last updated on OCTOBER 13, 2022
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:
When attempting to search for Account Contacts in the Contact Number field. After entering a partial Contact Number with a wildcard:
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
My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.