TN Search not Working Using Chars Having Party Entity Link

(Doc ID 2351317.1)

Last updated on JANUARY 23, 2018

Applies to:

Oracle Communications Unified Inventory Management - Version 7.3.4.0.0 and later
Information in this document applies to any platform.

Symptoms

In a specific condition TN Search not returning any results if minimum 2 EL Chars (pointing to different entities)are included in the search criteria.

This issue is specific to both the EL chars having few values in common.
Consider scenario:

"Owner" EL char for TN deriving its value from Party spec "Owner".
"ServiceProvider" EL char for TN deriving its value from Party spec "Service Provider".

Create instances of Party with spec "Owner" & names:
001,002
Create instances of Party with spec "Service Provider" & names:
001,003

So EL Char Owner & ServiceProvider have 001 value in common.
Create TN instances & select 001 as value for EL Char Owner & ServiceProvider.
Create few more TN instances, select 002 for Owner & 003 for ServiceProvider.

Do a TN search with Owner & ServiceProvider =001, no rows returned.
Do a TN search with Owner 002 & ServiceProvider 003 , rows will be returned.

Changes

 

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