My Oracle Support Banner

Entity Link Char As Drop Down Throwing Error (Doc ID 2781140.1)

Last updated on JUNE 02, 2021

Applies to:

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

Symptoms

On : 7.4.0.0.0 version, Custom Object

Entity link char as drop down throwing error.

ERROR
-----------------------
Messages for this page are listed below.
Error
System Error (javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: select o.* from GeographicLocation o, Specification s where o.specification = s.entityId AND o.name like ? AND s.name like ? bind => [2 parameters bound] Query: ReadAllQuery(referenceClass=GeographicLocationDAO sql="select o.* from GeographicLocation o, Specification s where o.specification = s.entityId AND o.name like ? AND s.name like ?") ).Please contact System Administrator.
Error
System Error (javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00942: table or view does not exist Error Code: 942 Call: select o.* from GeographicLocation o, Specification s where o.specification = s.entityId AND o.name like ? AND s.name like ? bind => [2 parameters bound] Query: ReadAllQuery(referenceClass=GeographicLocationDAO sql="select o.* from GeographicLocation o, Specification s where o.specification = s.entityId AND o.name like ? AND s.name like ?") ).Please contact System Administrator.
Error
System Error (javax.persistence.PersistenceException: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.6.5.v20170607-b3d05bd): org.eclipse.persistence.exceptions.DatabaseException Internal Exceptio


STEPS
-----------------------
1.) Place Spec with name AreaCode is there
2.) We have one CustomObject spec with name : AreaCodeUtilizationNotification and it has one char Area_Code which is entitylink char of AreaCode. So all the values of Place Spec AreaCode will appear in this drop down.
3.) While selecting any value from this drop down char getting error on screen.


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
Cause
Solution
References


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