EBS Customizations (MOSC)

MOSC Banner

The Oracle API package definition is changed with "AUTHID CURRENT_USER" in EBS 12.2 than before

The Oracle API package definition is changed in EBS 12.2 than before like below:

create or replace package FND_REQUEST AUTHID CURRENT_USER as .... (on EBS 12.2)

Because the new definition increased the key words "AUTHID CURRENT_USER", so we can't invoke the Oracle API normally.

Application Scenarios:

Our product invoke the Oracle API under the schema "APPS" with new user of "plugin" which is created by ourself.

we grant the execute privilege of the Oracle API under "APPS" to "plugin".

And create the SYNONYM about the above Oracle API package with "plugin" account.

Now we can't invoke the Orale API normally in EBS 12.2 but it's ok in EBS 12.1.

Tagged:

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

Don't have a My Oracle Support Community account? Click here to get started.

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center