Patch 12993004 Broke Functionality To Search By Customer
(Doc ID 1414823.1)
Last updated on JULY 13, 2020
Applies to:
Oracle Trading Community - Version 12.1.0 and laterInformation 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 = '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
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 |
Changes |
Cause |
Solution |
References |