Using UnifiedSearch Global System Rule With TYPECODE = '17' Still Returns All Clients (Doc ID 2946525.1)

Last updated on MAY 05, 2023

Applies to:

Symptoms

On : 11.2.0.25 version, General

ACTUAL BEHAVIOR
---------------
Users would like to be able to filter the results of the UnifiedSearch (search box at the top right corner in OIPA).
The specific requirement is to exclude from the search results the Clients with TYPECODE = '17' for the Security Group "Prototype Super".

To do this, the users have configured a Filter with Exclusion in the UnifiedSearch Rule
However the output shows that all Clients are included in the Search results.


EXPECTED BEHAVIOR
-----------------------
The search results for users with the security group "Prototype Super" should not display any TYPECODE = '17' clients.


STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Use the following UnifiedSearch Global System Rule.

<UnifiedSearch>
<Entity ENTITYNAME="Client">
<Filter>
<Conditions SecurityGroup = "Prototype Super" type ="Exclusion">
<Condition Entity = "ASCLIENT">TYPECODE = '17' </Condition>
</Conditions>
</Filter>
<Criteria>
<Name>FirstName</Name>
<Display>First Name</Display>
</Criteria>
</Entity>
</UnifiedSearch>


-------------------------

2. Go to the OIPA application.
3. Login with a user assigned to "Prototype Super" Security Role.
4. Search for all Clients using '%' as value.
5. Clients with TYPECODE = '17' should not appear on the query results.

Cause

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