Re: Reg: Printers

The parameter is already there :

and upper(n.user_profile_option_name) like upper('%&profile_name%')

Enter 'PRINTER' for the parameter.


On Wed, Dec 10, 2008 at 9:05 AM, NEELI-SC, Mamta <Mamta.NEELI@xxxxxxxxxxxxxx
> wrote:

>  Anuar,
>
>
>
> Do I need to add any parameter to the below query?
>
>
>
> As I tried to run the exact copy of the below query in toad no rows were
> selected L
>
>
>
> Thanks for prompt support.
>
>
>
> Mamta
>
>
>  ------------------------------
>
> *From:* ora-apps-dba-bounce@xxxxxxxxxxxxx [mailto:
> ora-apps-dba-bounce@xxxxxxxxxxxxx] *On Behalf Of *nuwat79 sabtu
> *Sent:* Wednesday, 10 December 2008 08:55
>
> *To:* ora-apps-dba@xxxxxxxxxxxxx
> *Subject:* 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: