AUTHID CURRENT_USER In Standard APIs - Throwing Error When Called From External Application (Doc ID 1498029.1)

Last updated on AUGUST 11, 2022

Applies to:

Symptoms

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.

Reproduction Steps

• 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.

Cause

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