My Oracle Support Banner

In UIM, JPQL on Custom Object Throws "Invalid Query" Error Message. (Doc ID 1990678.1)

Last updated on JANUARY 17, 2019

Applies to:

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

Goal

You have some similar scenario:

1. one specification Service Subtype having char: id, name, st_type where in st_type we load all types created with spec Service Type
2.another specification Service Type having chars: id, name
3. another specification of type service having as chars: type,subtype where I would like to load the subtype based on what i select in Type.

So you have written following JPQL:

select obj.name from CUSTOMOBJECT obj JOIN obj.characteristics var2 WHERE obj.specification.name = "Service Subtype" AND var2.name= "st_type" AND var2.VALUE=?

The JPQL query throws error - "Invalid Query"
 

Solution

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
Goal
Solution


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