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 184.108.40.206 to 220.127.116.11 [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!