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 12.2.1.2.0 to 12.2.1.2.0 [Release 12c]
Information in this document applies to any platform.

Symptoms

In an ADF 12.2.1.2.0 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.

Changes

 

Cause

Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms