ADF Table Filter With EJB Doesn't Work With LOV
Last updated on MAY 24, 2017
Applies to:Oracle JDeveloper - Version 220.127.116.11.0 to 18.104.22.168.0 [Release 12c]
Information in this document applies to any platform.
In an ADF 22.214.171.124.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
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