Unable to Revoke Privileges Using AD_ZD.revoke_privs Procedure (Doc ID 2273407.1)

Last updated on JUNE 07, 2017

Applies to:

Oracle E-Business Suite Technology Stack - Version 12.2 to 12.2.6 [Release 12.2]
Information in this document applies to any platform.

Symptoms

In EBS environments with AD/TXK Delta 7, unable to revoke privileges using AD_ZD.revoke_privs and facing following error:

SQL> exec AD_ZD.revoke_privs('SELECT','<OBJECT_NAME>','<SCHEMA>');
BEGIN AD_ZD.revoke_privs('SELECT','<OBJECT_NAME>','<SCHEMA>'); END;

*
ERROR at line 1:
ORA-06550: line 1, column 13:
PLS-00302: component 'REVOKE_PRIVS' must be declared
ORA-06550: line 1, column 7:
PL/SQL: Statement ignored

 

Changes

 N/A

Cause

Sign In with your My Oracle Support account

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

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms