Re: Reg: Printers

Hi Mamta,

Use below query:

select p.profile_option_name SHORT_NAME, n.user_profile_option_name NAME,
decode(v.level_id,
10001, 'Site',
10002, 'Application',
10003, 'Responsibility',
10004, 'User',
10005, 'Server',
10007, 'SERVRESP',
 'UnDef') LEVEL_SET,
 decode(to_char(v.level_id),
'10001', '',
'10002', app.application_short_name,
'10003', rsp.responsibility_key,
'10005', svr.node_name,
'10006', org.name,
'10004', usr.user_name,
'10007', 'Serv/resp','UnDef') "CONTEXT", v.profile_option_value VALUE
  from fnd_profile_options p,   fnd_profile_option_values v,
fnd_profile_options_tl n, fnd_user usr,fnd_application app,
     fnd_responsibility rsp, fnd_nodes svr, hr_operating_units org
  where p.profile_option_id = v.profile_option_id (+)
  and p.profile_option_name = n.profile_option_name
  and upper(n.user_profile_option_name) like upper('%&profile_name%')
  and    usr.user_id (+) = v.level_value
  and    rsp.application_id (+) = v.level_value_application_id
  and    rsp.responsibility_id (+) = v.level_value
  and    app.application_id (+) = v.level_value
  and    svr.node_id (+) = v.level_value
  and    org.organization_id (+) = v.level_value
  order by short_name, level_set;


Regards,
Anuar

On Fri, Dec 5, 2008 at 8:21 AM, NEELI-SC, Mamta
<Mamta.NEELI@xxxxxxxxxxxxxx>wrote:

> Hi James,
>
> Thanks for your reply.
>
> Even I suspect that the printer is set in someone's profile. But how to
> check the printer set at user level?
>
> If you have any Idea please help me in that.
>
> Regards
> Mamta
>
>
>
> -----Original Message-----
> From: ora-apps-dba-bounce@xxxxxxxxxxxxx
> [mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of James Morrow
> Sent: Thursday, 4 December 2008 21:22
> To: ora-apps-dba@xxxxxxxxxxxxx
> Subject: Re: Reg: Printers
>
> I'd suspect that printer is set to the "default printer" either in a
> concurrent program definition or in someone's profile.
>
> -- James
> ----------------------------------------------------------------------
> James J. Morrow | Senior Oracle Applications DBA
> morrow.james <at> gmail <dot> com
>
>
>
>
> On Thu, Dec 4, 2008 at 2:08 AM, NEELI-SC, Mamta
> <Mamta.NEELI@xxxxxxxxxxxxxx> wrote:
> > Hello Everybody,
> >
> >
> >
> > We have migrated our Oracle Application to new box. I'm trying to
> remove
> > some printers but I'm receiving printer cannot be removed as it is
> > referenced by any other program.
> >
> >
> >
> > I have changed the status of all the pending concurrent requests which
> were
> > referring to this printer to complete. Some printer I could remove
> after
> > doing this. But there is one printer which I'm still not able to
> remove.
> >
> >
> >
> > This printer is not set as default printer to any of the concurrent
> program.
> >
> >
> >
> > Can anyone suggest on this please.
> >
> >
> >
> > Regards
> >
> > Mamta
> >
> >
> >
> >
>
>
>
>

Other related posts: