My Oracle Support Banner

11i: "ORA-00942: table or view does not exist" Error When Accessing Seeded APPS Objects Using Custom User (Doc ID 1386822.1)

Last updated on JUNE 18, 2018

Applies to:

Oracle Application Object Library - Version to [Release 11.5]
Information in this document applies to any platform.


The "ORA-00942: Table or view does not exist" error has been identified under the following situations. Causes and Solutions are provided for each situation.

1. When using a custom user to execute the package APPS.AP_INVOICES_PKG, the following error occurs:

ORA-00942: table or view does not exist
ORA-06512: at "APPS.AP_INVOICES_UTILITY_PKG", line 366
ORA-06512: at "APPS.AP_INVOICES_PKG", line 1584

Steps To Reproduce
1. Create a custom database user.
2. Grant the custom user Execute privilege on APPS.AP_INVOICES_PKG, and all the tables/views that are accessed by this package.

2. When attempting to connect to a forms based responsibility, the following error occurs.


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

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