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 27, 2016

Applies to:

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

Symptoms

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.

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