Running EBS Patch 23569686 On An 11g Database Throws An ORA-01031: Insufficient Privileges Error (Doc ID 2479694.1)

Last updated on DECEMBER 24, 2022

Applies to:

Symptoms

On : 12.1.3 E-Business Suite 

When attempting to apply patch 23569686, adrevokegrants.sql fails with:


ERROR
-----------------------
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at line 5

Changes

Root cause is that the validation in adgrants.sql needs access (as sys) to apps.fnd_oracle_userid (via system.fnd_oracle_userid synonym) in order to check for any objects with dependencies on grants which are about to be removed: 

This is blocked by the realm. The grant above will workaround the issue. We have agreed upon the following option. We can expose out the fnd_oracle_userid EV to SYS (as per the workaround). However, if we do this, we should provide a view layer which just exposes only the schemas. this would require an additional view, as well as a change to the SYSTEM synonym.

As a workaround, customer can try the following: 

SQL*PLUS as APPS: 

SQL> grant select on fnd_oracle_userid to SYS;

To undo the workaround:

SQL> revoke select on fnd_oracle_userid from SYS;

As we are working on providing a long term fix,customer can proceed with the workaround suggested above.

Cause

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