My Oracle Support Banner

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

Last updated on MARCH 07, 2022

Applies to:

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


NOTE: In the examples below, data represent a fictitious sample (based upon made up data).  Any similarity to actual persons, living or dead, or situations is purely coincidental and not intended in any manner.

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.