By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,197 Members | 974 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,197 IT Pros & Developers. It's quick & easy.

PLS-00201 and ORA-00942 when creating a package

P: n/a
Hi,
I am trying to create a package under the apps schema, and I keep
getting PLS-00201 and ORA-00942 when refering to types from other
apps-packages and other views / tables.

I even get this error when calling a quite simple:
MY_NUM := FND_PROFILE.VALUE('MY_PROFILE_NAME');

Any ideas what I can be doing wrong?
This same code was originally part of a trigger code, and worked just
fine.

-Per Magnus
Jul 19 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
From a DBA standpoint:

The descriptions of these errors in the manual will explain that the schema
in which you're attempting to create the package does not have appropriate
permissions on the objects that your referencing. Note that these
permissions must be granted directly to the schema (not via a role)

Verify the permissions by checking the USER_TAB_PRIVS_RECD data dictionary
view which, despite the name, lists the user's received privileges for all
types of database objects

Perhaps someone that has worked directly with Oracle Apps can give some
insight on what is and is not recommended when customizing the apps.
--
Mark C. Stock
mcstock -> enquery(dot)com
www.enquery.com training & consulting

"Per Magnus L?vold" <pm******@broadpark.no> wrote in message
news:a0*************************@posting.google.co m...
| Hi,
| I am trying to create a package under the apps schema, and I keep
| getting PLS-00201 and ORA-00942 when refering to types from other
| apps-packages and other views / tables.
|
| I even get this error when calling a quite simple:
| MY_NUM := FND_PROFILE.VALUE('MY_PROFILE_NAME');
|
| Any ideas what I can be doing wrong?
| This same code was originally part of a trigger code, and worked just
| fine.
|
| -Per Magnus
Jul 19 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.