My Oracle Support Banner

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 and later
Information in this document applies to any platform.


On : version, General

When attempting to sort Requirements by Name from the Requirements Screen, the following error occurs:

 AsRequirementPolicy.PolicyGuid=? ORDER BY TranslatedRequirementName ASC OFFSET ? ROWS FETCH NEXT ? ROWS ONLY")
at org.eclipse.persistence.internal.jpa.QueryImpl.getDetailedException(
at org.eclipse.persistence.internal.jpa.QueryImpl.executeReadQuery(
at org.eclipse.persistence.internal.jpa.QueryImpl.getResultList(
at com.adminserver.dal.jpa.JpaDataAccessHelper.executeSqlQuery(
at com.adminserver.dal.BaseDal.executeSqlQuery(
at com.adminserver.dal.BaseDal.executeSqlQuery(
. ...........
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

The issue can be reproduced at will with the following steps:
1. Open Policy.
2. Navigate to Requirements Screen.
3. Sort Requirements by Name.


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.