When Using View Criteria In View Accessor, SQL error during statement preparation Error With ORA-00904 Occurs (Doc ID 2028548.1)

Last updated on NOVEMBER 10, 2015

Applies to:

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

Symptoms

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.
Statement:
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

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