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 laterInformation 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
- 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
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 |