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

Last updated on FEBRUARY 15, 2012

Applies to:

Oracle Trading Community - Version: 12.1.3 and later   [Release: 12.1 and later ]
Information in this document applies to any platform.

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 = 'Emcor'. 4 customers that included 'Emcor' in the name were returned.
- I searched by Customer = 'Emcor%' - Again, 4 customers that included 'Emcor' in the name were returned.
- I searched by Account Description = 'Emcor' - Returned 4 customers (but took 3 min)
- I searched by Account Description = 'Emcor%' - Returned 4 customers (took 1 min 30 sec).

AFTER the patch
- I searched by Customer = 'Emcor'. 0 customers found <<=== ISSUE
- I searched by Customer = 'Emcor%' - 0 customers found <<=== ISSUE
- I searched by Account Description = 'Emcor' - Returned 4 customers (only took 4 sec)
- I searched by Account Description = 'Emcor%' - 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

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