RE: Reg: Printers

Thanks everyone:

 

I found where the printer was referenced in concurrent request.

 

select r.user_request_set_name, s.user_stage_name, 
c.user_concurrent_program_name 
from fnd_request_sets_tl r, fnd_request_set_stages_tl s, 
fnd_request_set_programs p, 
fnd_concurrent_programs_tl c 
where p.request_set_ID = r.request_set_ID 
and p.request_set_stage_id = s.request_set_stage_id 
and p.concurrent_program_id = c.concurrent_program_id 
and printer = 'TargetPrinter';

 

Regards

Mamta

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of Tipton, Josh
Sent: Wednesday, 10 December 2008 10:51
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Reg: Printers

 

The printer is more than likely setup in a concurrent job or is in
someone's profile as a default printer.

 

________________________________

From: ora-apps-dba-bounce@xxxxxxxxxxxxx
[mailto:ora-apps-dba-bounce@xxxxxxxxxxxxx] On Behalf Of NEELI-SC, Mamta
Sent: Tuesday, December 09, 2008 8:50 PM
To: ora-apps-dba@xxxxxxxxxxxxx
Subject: RE: Reg: Printers

 

DBA's

 

I'm receiving the below error. Any one ever faced each problem?

 

"This printer is referenced in a request set definition. You cannot
delete a Printer while it is referenced"

 

Please suggest how to remove the printer from request set definition..as
there are so many request sets.

 

Regards

Mamta

 

 

 

________________________________

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
>
>
>
>

 

 

************************************************************************
******
This email contains confidential and proprietary information and is not
to be used 
or disclosed to anyone other than the named recipient of this email, 
and is to be used only for the intended purpose of this communication.
************************************************************************
******

Other related posts: