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:Oracle Applications DBA - Version 12.1.3 and later
Information in this document applies to any platform.
On : 12.1.3 E-Business Suite
When attempting to apply patch 23569686, adrevokegrants.sql fails with:
ERROR at line 1:
ORA-01031: insufficient privileges
ORA-06512: at line 5
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.
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