AUTHID CURRENT_USER In Standard APIs - Throwing Error When Called From External Application
(Doc ID 1498029.1)
Last updated on FEBRUARY 13, 2019
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.
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