OIPA Error 'ORA-00904:"TRANSLATEDREQUIREMENTNAME": Invalid Identifier' During Requirement Name Sort
(Doc ID 2857687.1)
Last updated on MARCH 23, 2022
Applies to:
Oracle Insurance Policy Administration J2EE - Version 11.3.0.11 and laterInformation in this document applies to any platform.
Symptoms
On : 11.3.0.11 version, General
When attempting to sort Requirements by Name from the Requirements Screen, the following error occurs:
ERROR
-----------------------
AsRequirementPolicy.PolicyGuid=? ORDER BY TranslatedRequirementName ASC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY")
at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(QueryImpl.java:391)
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(QueryImpl.java:264)
at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(QueryImpl.java:482)
at com.adminserver.dal.jpa.JpaDataAccessHelper.executeSqlQuery(JpaDataAccessHelper.java:88)
at com.adminserver.dal.BaseDal.executeSqlQuery(BaseDal.java:222)
at com.adminserver.dal.BaseDal.executeSqlQuery(BaseDal.java:171)
. ...........
............
..............
Caused by: Exception [EclipseLink-4002] (Eclipse Persistence Services - 2.7.4.v20190115-ad5b7c6b2a): org.eclipse.persistence.exceptions.DatabaseException
Internal Exception: java.sql.SQLSyntaxErrorException: ORA-00904: "TRANSLATEDREQUIREMENTNAME": invalid identifier
STEPS
-----------------------
The issue can be reproduced at will with the following steps:
1. Open Policy.
2. Navigate to Requirements Screen.
3. Sort Requirements by Name.
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 |