Cannot Query Customer With Several Accounts Using Partial Tax Registration Number and Wild Card % (Doc ID 1546968.1)

Last updated on JULY 12, 2017

Applies to:

Oracle Receivables - Version 12.1.3 and later
Information in this document applies to any platform.

Symptoms

In R12.1.3:

Customers search with Tax Registration Number using partial values and wild card % (RDI%) only work for some customers.
The issue only happens for customers that has several accounts, i.e.customer with about 150 accounts.

If DQM is not enabled:
-The query only returns records when users specify the full Tax Registration Number in the search criteria (for example: RDI841003QJ4).
-The query returns with "No results found" when using partial values and wild card % for the Tax Registration Number (for example: RDI%)

If DQM is enabled:
-There is not a way to query for this customer even if users specify the full Tax Registration Number or the full name or whichever criteria.

Steps to reproduce:

1) With DQM disabled:

-Receivables Manager, N: Customers : Customers
-In the Customers Simple Search page, enter RDI% in the Tax Registration Number field.
-Click Go. The search results returns with "No results found"
-If enter the entire value 'RDI841003QJ4' in the Tax Registration Number field and click Go, the search now returns the record.

2) With DQM enabled:

-Set the following profile options as follows:
  HZ: Match Rule for Organization Advanced Search = SAMPLE: ADVANCED SEARCH RULE
  HZ: Match Rule for Organization for Simple Search = SAMPLE: ADVANCED SEARCH RULE
-Receivables Manager, N: Customers : Customers
-In the Customers Advanced Search page, enter RDI% in the Tax Registration Number field.
-Click Go. The following error appears:
  Error
  The criteria you entered provide too many matching results. Enter additional criteria or modify the match rule to get fewer, appropriate results.
-If enter the entire value 'RDI841003QJ4' in the Tax Registration Number field and click Go, the same error is received.

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms