My Oracle Support Banner

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

Last updated on FEBRUARY 19, 2024

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.


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


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