My Oracle Support Banner

Search Operator "Does Not Contain" And "Contains" Returns Incorrect Results (Doc ID 2782307.1)

Last updated on JUNE 04, 2021

Applies to:

Oracle Agile Product Collaboration - Version 9.3.6.0 and later
Information in this document applies to any platform.

Symptoms

On : 9.3.6.0 version, Searches

ACTUAL BEHAVIOR
---------------
Search operator "Does not contain" and "Contains" Returns incorrect results.

EXPECTED BEHAVIOR
-----------------------
It should return correct result.

STEPS
-----------------------

1. In Web Client, Create New Part, P00001.
2. Create many Assemblies with the following details:
NUMBER DESCRIPTION BOM
P00002 FAC3200 GENERATOR CONNECT W P00001 P00001
P00003 FAC3200 GENERATOR CONNECT W P00001 P00001, add other Part
P00004 FAC3200 GENERATOR CONNECT WO P00001 add one Part except P00001
P00005 FAC3200 GENERATOR CONNECT WO P00001 add many Parts except P00001
P00006 GENERATOR CONNECT W P00001 P00001
P00007 GENERATOR CONNECT WO P00001 add many Parts except P00001
P00008 FAC3200 W P00001 P00001, add other Part
P00009 FAC3200 WO P00001 add one Part except P00001
P00010 FAC3200 GENERATOR CONNECT do not add any Part
3. Go to Custom Search > Advanced Search.
4. Input Search Criteria:
Items;Parts
Attribute: BOM.Item Number
Operator: Does Not Contain
Value: P00001
5. Click Search and it shows incorrect result

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
References


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