Patch 12993004 Broke Functionality To Search By Customer (Doc ID 1414823.1)

Last updated on JULY 13, 2020

Applies to:

Symptoms

On : 12.1.3, Data Quality Management

When attempting to review query functionality after patch 12993004, the following problem occurs.

ERROR
-----------------------
Before the patch:
- I searched by Customer = 'xxxxx'. 4 customers that included 'xxxxx' in the name were returned.
- I searched by Customer = 'xxxxx%' - Again, 4 customers that included 'xxxxx' in the name were returned.
- I searched by Account Description = 'xxxxx' - Returned 4 customers (but took 3 min)
- I searched by Account Description = 'xxxxx%' - Returned 4 customers (took 1 min 30 sec).

AFTER the patch
- I searched by Customer = 'xxxxx'. 0 customers found <<=== ISSUE
- I searched by Customer = 'xxxxx%' - 0 customers found <<=== ISSUE
- I searched by Account Description = 'xxxxx' - Returned 4 customers (only took 4 sec)
- I searched by Account Description = 'xxxxx%' - Returned 4 customers (only took 1 sec)


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Apply patch 12993004
2. Search on the customer UI

Changes

Cause

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