Try this... might be too old for the current version though...

Go to SQL*Plus and run the following SQL statement:

1. You need to get the profile_option_id for the profile Printer.
(The default is 109)

SQL> select profile_option_id,profile_option_name
from fnd_profile_options
where profile_option_name like '%PRINTER%';

2. You need to determine how many users have this profile option set to
this
printer.

SQL> select
level_id,profile_option_id,profile_option_value,level_value
from fnd_profile_option_values
where profile_option_id= <&&profile_option_id from #1>
and profile_option_value = <&&exact printer name>;

3. Get the username that has the profile option Printer set to the
printer you
want to delete.

SQL> select user_id,user_name
from fnd_user where user_id = <&&level_value from #2>;

4. Now that you have identified all users that have the profile option
Printer
set to the printer you want to delete, log on as System
Administrator
Responsibility.

5. Go to: Profile -> System.

6. Query by User and enter Printer for the profile value. Do that for
all
users that step #3 has returned.

7. You should be able now to delete the printer.



>>> "Ronnie Smith "
<oracledba-ezmlmshield-x15518002.[Email address protected] 2/29/2008
1:04:23 PM >>>
I am needing to disable/delete a printer in our apps that is no longer
available. It keeps telling me it is referenced. I can only think it is
still assigned to a couple users as a default printer. It may also be
tied to some end dated users.

Can anyone think of a script to show all the users and the default
printers that are assigned to each one? We are using apps 11.5.10.2 and
the database is 9.2 I believe.

Thanks!

Ronnie D Smith
Rose Acre Farms
IT Dept
Phone: 812-497-2559 ext 290
fax: 812-497-3311



---------------------------------------------------------------------
TO REPLY TO EVERYBODY , PLEASE CLICK REPLY-ALL, NOT JUST REPLY
To post a dba job: http://jobs.lazydba.com
To Subscribe : http://www.LazyDBA.com
To unsubscribe: http://www.lazydba.com/unsubscribe.html



Oracle LazyDBA home page