Last updated on NOVEMBER 10, 2015
Applies to:Oracle JDeveloper - Version 18.104.22.168.0 to 22.214.171.124.0 [Release 12c]
Information in this document applies to any platform.
Facing the below error, while using view criteria in the View Accessors of VO and running the application in Model tester or JSF page:
SQL error during statement preparation.
SELECT * FROM (select department_id, department_name, manager_id, location_id from departments) QRSLT WHERE ( ( (EXISTS(SELECT 1 FROM EMPLOYEES EmployeesNQ2 WHERE ( (UPPER(EmployeesNQ1.PHONE_NUMBER) IS NOT NULL ) ) AND (QRSLTSQ1.MANAGER_ID = EmployeesNQ1.EMPLOYEE_ID))) ) ): ORA-00904: "EMPLOYEESNQ1"."EMPLOYEE_ID": invalid identifier
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