My Oracle Support Banner

Error on WebLogic Application ORA-00942 Table or View does not Exist (Doc ID 2544087.1)

Last updated on NOVEMBER 10, 2023

Applies to:

Oracle WebLogic Server - Version 12.1.3.0.0 and later
Information in this document applies to any platform.

Symptoms

Application running on WebLogic Server throws below errors:

Also it could be found that the "table"(or "view") would be access by application shown in above stack " xxxxxxxxxx.xxxxxxx.xxxxxx(xxxxxxxx.java:19)"  was invisible to account that was set in "Pool Connection" to connect DB.  This inclusion can be proved by connecting DB via SQLPlus or other client with specified account, and then querying "table" (or "view"). 

The account that can see that "table"(or "view") was not recommended by DB administrator.

Changes

 

Cause

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
Symptoms
Changes
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.