EBS Customizations (MOSC)

MOSC Banner

New database user o select form apps tables and views

edited Dec 2, 2015 1:48AM in EBS Customizations (MOSC) 20 commentsAnswered

Dear All,


For business purposes, we need to create new database user. This user needs to read some APPS  views, so we granted all on application context fnd_global.APPS_INITIALIZE to that user;


grant all on fnd_global to xxuser;


but when logging to the xxuse and run:


begin fnd_global.APPS_INITIALIZE(0,0,0); end;


it generate error:

ERROR at line 2:

ORA-06550: line 2, column 1:

PLS-00201: identifier 'FND_GLOBAL.APPS_INITIALIZE' must be declared

ORA-06550: line 2, column 1:

PL/SQL: Statement ignored



Thanks in advance;

Shareef


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