11i: "ORA-00942: table or view does not exist" Error When Accessing Seeded APPS Objects Using Custom User
Last updated on JUNE 18, 2018
Applies to:Oracle Application Object Library - Version 220.127.116.11 to 18.104.22.168 [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.
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