My Oracle Support Banner

UIM: Error When Conducting Entity Search Based on a Numeric Characteristic in UI (Doc ID 1639935.1)

Last updated on SEPTEMBER 10, 2019

Applies to:

Oracle Communications Unified Inventory Management - Version 7.2.2 to 7.2.2 [Release 7.2]
Information in this document applies to any platform.


Following error is thrown when a search is conducted based on the numeric characteristic in UI

An exception occurred while creating a query in EntityManager: Exception Description: Syntax error parsing the query [SELECT o FROM CustomNetworkAddress o JOIN o.characteristics chars0var WHERE o.specification = :specParam AND ( = :pCharName0Param AND (chars0var.objectState = :pActiveStateParam0Param OR chars0var.objectState = :pQueuedStateParam0Param ) ANDFUNC('TO_NUMBER',FUNC('DECODE',FUNC('REGEXP_INSTR',chars0var.value,'^[-+]?[0-9]*[.]?[0-9]*$'),1,chars0var.value,NULL))= :pCharValue0Param) AND (o.objectState = oracle.communications.inventory.api.ObjectState.ACTIVE OR o.objectState = oracle.communications.inventory.api.ObjectState.INACTIVE)], line 1, column 252: syntax error at [ANDFUNC]. Internal Exception: MismatchedTokenException(80!=84)


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

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