UIM: Drop Down SQL Based Is Empty (Doc ID 2033344.1)

Last updated on JANUARY 26, 2016

Applies to:

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

Symptoms

On : 7.2.5.0.0 version, Characteristics

The issue is related to Dropdown characteristic functionality.
It has been observed that the Dropdown characteristic is not displaying the values that are presented in the Database.

ERROR
-----------------------
No error code. Just empty values are returned.

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

To reproduce the issue:
1. Create a custom dropdown characteristic
2. Add the SQL to the characteristic

Expected result: as there is records in Database that corresponds to the above's query filter, it is expected that the dropdown shows these data.


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