How Is The WildCard (%) Used When Searching For A Customer In Oracle Customers Online And Receivables With DQM Enabled Screens
(Doc ID 358724.1)
Last updated on NOVEMBER 03, 2024
Applies to:
Oracle Trading Community - Version 11.5.10 to 12.2 [Release 11.5 to 12.2]Oracle Receivables - Version 12.1 to 12.2 [Release 12.1 to 12.2]
Oracle Receivables - Version 12.2.13 to 12.2.13 [Release 12.2]
Information in this document applies to any platform.
Symptoms
Q: How is the wildcard (%) used in the following searches:
1) Customer Name = Customer ABC%
Three records for "Customer ABC" returns:
-Customer ABC
-Customer ABC Inc
-Customer ABC Purchasing
Customer A B C is not returned.
2) Customer Name = Customer A%
This error is received:
"Unexpected SQL error encountered when performing search. Procedure HZ_MATCH_RULE_61.find_parties Error: ORA-20000: Oracle Text error: DRG-10800: query failed: DRG-51030: wildcard query expansion resulted in to many terms. Please contact the system administrator."
3) Customer Name = Customer%ABC
No records return
4) Customer Name = CustomerABC%
No records return
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 |
| Enhancement Requests (ERs) are now moved to Receivables My Oracle Support Community Ideas! Your Ideas Count! |
| References |