Object Invalidation post Grant/Revoke on Objects

GRANT and REVOKE on objects for the user is very common requirement in any Database projects and is no special in Oracle as well.  Especially DBAs have provided GRANT to users  on various objects (based on requirements). This was working all the way without causing any issues to the application availability.

But in Oracle E-Business Suite R12.2.x, Whenever granting privileges on an object belongs to APPS Schema cause an invalidations in the current edition. Hence if you are GRANTing privileges in the RUN edition has the potention to cause an impact on the application availability. To avoid such invalidation, use the procedure AD_ZD.GRANT_PRIVS.  (For more information on AD_ZD.GRANT_PRIVS, see Oracle Doc ID 1577661.1)

But good news for those who still want to use native GRANT and REVOKE in R12.2.x application instead of the above API. Oracle has fixed this.

Follow the below action plan.

• set the parameter _disable_actualization_for_grant=TRUE (with scope=spfile)
• Bring down the database.
• Apply the one-off patch 26654363 to the database. (This patch is part of ETCC, and hence chances are that this patch might have been already applied). 
• Start the database.

Now you will be able to use Native GRANT and REVOKE in a way you have practised all these years.


References:

• Granting Privileges On An Object May Cause Invalidations (Doc ID 1987947.1)
• Developing and Deploying Customizations in Oracle E-Business Suite Release 12.2 (Doc ID 1577661.1)
• Objects Still Get Invalidated After Granting Privileges For Edition Object After Applying Patch 26654363 (Doc ID 2392091.1)