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 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
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