RE: Reg: Printers

Thanks!!

 

But no rows in output that means no printer is set at user level:-( can
you suggest what could be the other reason for the printer not being
able to remove.

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of nuwat79 sabtu
Sent: Wednesday, 10 December 2008 09:23
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: 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 :-(

 

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: