AUTHID CURRENT_USER In Standard APIs - Throwing Error When Called From External Application
Last updated on JUNE 15, 2017
Applies to:Oracle Project Foundation - Version 12.1.3 and later
Information in this document applies to any platform.
Some of the packages for standard product APIs are created with the clause "AUTHID CURRENT_USER".
When those API's are called from external applications using a user other than APPS the API's are throwing errors.
- Create a package in our custom schema
- Call and API from APPS.PA_PROJECT_ASSETS_PUB in that package.
- Call the custom package from a workflow to update asset information.
- The user is a custom user (Not APPS).
The call fails with error message:
ORA-00942: table or view does not exist in Package PA_PROJECT_ASSETS_PUB Procedure update_project_asset.
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