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

Last updated on AUGUST 17, 2023

Applies to:

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

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