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

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.

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

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

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