My Oracle Support Banner

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:

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

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


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