Post AD-TXK Delta 16 AD_ZD.GRANT_PRIVS On Custom Objects Throws Error 'Grant Error: 100: ORA-01403: no data found'
(Doc ID 3052228.1)
Last updated on OCTOBER 16, 2024
Applies to:
Oracle Applications DBA - Version 12.2.9 and laterInformation in this document applies to any platform.
Symptoms
After upgrading the AD-TXK version to Delta 16, AD_ZD.GRANT_PRIVS used to grant access to custom object fails with below error.
The same has worked previously on AD-TXK Delta 14 version.
ERROR
--------
The below error can be noticed when ran in sqlplus (no log file):
SQL> exec AD_ZD.GRANT_PRIVS('SELECT','XXX_CUSTOM_MV','<GRANTEE>',X_GRANT_TO_TABLE=>TRUE)
BEGIN AD_ZD.GRANT_PRIVS('SELECT','XXX_CUSTOM_MV','<GRANTEE>',X_GRANT_TO_TABLE=>TRUE); END;
*
ERROR at line 1:
ORA-01403: no data found
ORA-06512: at "APPS.AD_ZD", line 1399
ORA-06512: at "APPS.AD_ZD", line 1305
ORA-06512: at "APPS.AD_ZD", line 1295
ORA-06512: at line 1
STEPS
--------
1. Connect to sqlplus.
2. Execute as below:
SQL>exec AD_ZD.GRANT_PRIVS('SELECT','XXX_CUSTOM_MV','<GRANTEE>',X_GRANT_TO_TABLE=>TRUE)
NOTE: Command to run the GRANT_PRIVS API is below:
The GRANT_PRIVS API is specialized to the task of granting permissions on EBS objects (exposed in APPS) to other users. For grants on editioned custom objects, you could make synonym to the custom object in APPS, and then run GRANT_PRIVS on that synonym name.
ad_zd.grant_privs(
X_PERMISSIONS in varchar2, /* comma-seperated permission list */
X_OBJECT_NAME in varchar2, /* name of APPS object or APPS synonym */
X_GRANTEE in varchar2, /* grantee schema or role */
X_OPTIONS in varchar2 default NULL); /* grant options, example: 'WITH
GRANT OPTION' */
Changes
Upgrading the AD-TXK version to Delta 16.
Noticed the change in below file versions:
$ strings -a $AD_TOP/patch/115/sql/ADZDXS.pls | grep Header
/* $Header: ADZDXS.pls 120.25.12020000.24 2024/02/14 17:10:51 $ */
$ strings -a $AD_TOP/patch/115/sql/ADZDXB.pls | grep Header
/* $Header: ADZDXB.pls 120.52.12020000.100 2024/03/01 17:39:23 $ */
Cause
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
| Symptoms |
| Changes |
| Cause |
| Solution |
| References |