EBS Customizations (MOSC)

MOSC Banner

Error when executing ad_zd.grant_privs

edited Jul 13, 2017 6:59PM in EBS Customizations (MOSC) 10 commentsAnswered

Hi,

When we try to execute the grant script on custom objects, the API gives the following error - 

ORA-01031: insufficient privileges

ORA-06512: at "APPS.AD_ZD", line 1156

For example, the following command gives error (Custom table)

EXEC ad_zd.grant_privs('SELECT','L3AR_ACCRUAL_DATA', 'L3DWSTAGE');

But the following command does not give error (Standard table).

EXEC ad_zd.grant_privs('SELECT','HZ_CUST_ACCOUNTS', 'L3DWSTAGE');

Note that the custom table was upgraded using the API ad_zd_table.upgrade

Howdy, Stranger!

Log In

To view full details, sign in to My Oracle Support Community.

Register

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

Category Leaderboard

Top contributors this month

New to My Oracle Support Community? Visit our Welcome Center

MOSC Help Center