Skip to Main Content

APEX

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Error suddenly appearing in app - ORA-00942: table or view does not exist but it does exist

User_427NNJun 23 2022

I am getting 'ORA-00942: table or view does not exist but it does exist' error suddenly in my application after working on it for weeks without issue. The error appears when I open the Form page that creates/edits a record, and whenever I click on any of the 3 dropdowns that use a SQL Query to create the Select List (and these 3 lists are querying a view, not the same table). Any idea what might've happened?

Comments
Post Details
Added on Jun 23 2022
2 comments
317 views