My Oracle Support Banner

ADF Table Filter With EJB Doesn't Work With LOV (Doc ID 2269932.1)

Last updated on MAY 24, 2017

Applies to:

Oracle JDeveloper - Version to [Release 12c]
Information in this document applies to any platform.


In an ADF application using EJBs for the data model, an ADF table with filtering doesn't work for a column that is based on an accessor and is populated using a LOV.

When using the HR sample schema, creating EJB-based entities for Employee and Department such that Department Entity Object is accessed from Employee Entity Object through Employee.department1 Data Control.
Adding an ADF table from the aforementioned Data Control and enabling filtering on the table, when at runtime a value is chosen in the drop down, an error is thrown from EclipseLink, because the generated query is incorrect and the reported error would be like

Exception Description: Problem compiling [select count(o) from Employee o where (o.department1 = model.Department@7ca8629a)]. [55, 80] The state field path 'model.Department@7ca8629a' cannot be resolved to a valid type. [55, 60] The identification variable 'model' is not defined in the FROM clause.




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.