ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
SYSTEM ADMINISTRATION

Queue information for concurrent programme

Date: Tue, 3 Aug 1999 11:59:27 -0600
From: "Snyder, Stephanie" Snyder.Stephanie@tci.com
Subject: AOL: Finding queue information for a concurrent program

I need to find out if a specific concurrent program has been assigned to run only in certain concurrent queues. I need to be able to get the information from the database tables using a sql statement as I do not have access to foundations.

Thanks

Date: Tue, 3 Aug 1999 15:48:11 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Finding queue information for a concurrent program

select concurrent_queue_id, description from fnd_concurrent_queues
where concurrent_queue_id in ( select concurrent_queue_id from
fnd_concurrent_processes
where concurrent_process_id = ( select controlling_manager
from fnd_concurrent_requests where request_id = &req_id ))

Check the column names.

Otherwise check $FND_TOP/sql/afmcstat.sql and this will give you info about all links. Not only that, you go through all the scirpts under $FND_TOP/sql. These scripts are very useful.

-chakrapani
ORacle Apps DBA & Sysadmin
BTG Inc.

Activate/Deactivate HELP-TOOLS-EXAMINE function

Phil Riker pmr2073@ritvax.isc.rit.edu 08/04 5:49 AM
Subject: Re: HELP-TOOLS-EXAMINE function

My memory snapped! Could one of you supply me with the correct "profile" category to activate/deactivate non-password access to the above function? Thank you in advance.

Date: Wed, 04 Aug 1999 08:52:53 -0500
From: "Vikram Reddy" Vikram_Reddy@intervoice.com
To: oraapps-l@cpa.qc.ca, pmr2073@ritvax.isc.rit.edu
Subject: Re: HELP-TOOLS-EXAMINE function

Utilities Diagnostics is the profile option.

Cheers Vikram.

How to get OS process id using request_id

Date: Thu, 5 Aug 1999 11:05:09 -0700
From: "AmyTse" amy@idec.com
Subject: AOL: How can find OS process id using request_id

Hi all:

We are using HP-UX 10.20 and Oracle Application 10.7 (GUI). How can I use the request_id from FND_CONCURRENT_REQUEST table to get the process id on Unix level.

Please advise.
Thanks, Amy

Date: Thu, 5 Aug 1999 13:42:57 -0400
From: "Gow, Tony" GOWA@tc.gc.ca
Subject: RE: How can find OS process id using request_id

Try this.

Here is a script to find the UNIX PID number for Oracle request ID.

1 select os_process_id from fnd_concurrent_processes
2 where concurrent_process_id = (select controlling_manager
3 from fnd_concurrent_requests
4 where request_id = &req_id)

990-9177

Date: Fri, 06 Aug 1999 14:10:15 -0700
From: Andy Rivenes arivenes@llnl.gov
Subject: Re: AOL: How can find OS process id using request_id

Here's something that's a little fancier: Please click here

Configuring Concurrent Manager

Date: Thu, 05 Aug 1999 14:16:48 PDT
From: "Francisco Martínez Oviedo" fmartinez65@hotmail.com
Subject: Configuring the concurrents managers.

Hi list:

We have two database on a same server PRUEBA and TEST, with Oracle Financials 10.7.

And we start up two differents concurrents managers for every database.

My question is the next:

How I can configure the process for the concurrents managers for start up at least five process?

EXAMPLE:

A user execute a report.
Other user execute another report.
A third user execute another report.
Other user execute other process.

The status for the concurrent is the next, for example:

1 User Executing.
2 User Executing.
3 User Executing.
4 User Pending.
5 User Pending.
I want that the five users are on status executing and not only three users.

Any suggestions.
Thanks... REGARDS.........

Restrict Database connections from Oracle SQL product

Date: Thu, 05 Aug 1999 07:37:49 -0700
From: ira aseira@pacbell.net
Subject: Ristrict SQL connections

Does anyone know how to dis-allow connections to an Oracle database from the Oracle SQL product?

Thanks

Date: Thu, 05 Aug 1999 19:01:26 -0400
From: Sudershan virdi virdi@interlog.com
Subject: Re: Ristrict SQL connections

you can setup security using the product_profile table under system to disallow connections from oracle sql products.

Sudershan

How to get Request_id using FND_REQUEST.SUBMIT_REQUEST

Date: Mon, 9 Aug 1999 14:21:21 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: How to get request_id when running 'FND_REQUEST.SUBMIT_REQUEST'

All,

I have a small issue here in finding out the request_id when using 'FND_REQUEST.SUBMIT_REQUEST'. I am writing a custom Conc. program in 'Confirm Payments' screen for ACH wire transfer. Instead of Report, I would like to use Report Set here to perform couple of tasks.

As this request is submitted through 'FND_REQUEST.SUBMIT_REQUEST' in confirm payments screen, I would like to refer to the paramaters and the application_id, responsibility_id and REQUEST_ID for that request.

Please let me know

1) How to refer to the conc. req.id, application_id or resp.id etc within the same conc. req.id.

2) If I want to use Report set to, say FTP the file genrated in the previous request, please let me know how to refer to the output of previous request in present request.

3) If I am using FND_REQUEST.SUBMIT_REQUEST, how can I refer to the parameters that have been passed to the request.

Thanks,
-chakrapani

Scheduling processes

Date: Tue, 10 Aug 1999 08:22:10 +0400
From: IjlalR@mashreqbank.com
Subject: GEN: Concurrent Manager

Hi,

My question is: How can I schedule some processes to run automatically (e.g. every day, weekly)? I am new to this so details would be appreciated. Are there any processes that must be run monthly or yearly for an HR and Payroll implementation?

Thanks in advance, Ijlal

Date: Tue, 10 Aug 1999 08:32:05 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Concurrent Manager

Which version you are using ?

-chakrapani

Date: Tue, 10 Aug 1999 10:51:49 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: GEN: Concurrent Manager

Hi,

If you ar using 11.x or any SmartClient version When you run a request, click on "Schedule Options" and you can enter any scheduling options there.

If you are using Character mode, select "Report Options" in the last field in "Run reports" screen and enter different schedules. Please let me know if you have any doubts.

-chakrapani

Date: Tue, 10 Aug 1999 11:23:48 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
Subject: RE: GEN: Concurrent Manager

HI

Can U tell in which screen can I find this 'Schedule Options' I checked both Run Request ' and Register Conc prog Screen' we are on 10.7 SC

thanks kumar

Script to count Concurrent Users

Date: Wed, 11 Aug 1999 08:56:49 -0700
From: "McClung, Ed D." EDMCCLUNG@ESCOCORP.com
Subject: Script to count #Concurrent Users

Hi there,
As you know Oracle sells their "stuff" depending on the number of concurrent users that are using the software at one time instead of number of sessions, my questions is does any one have a script or know where that I could get a script, or how do I monitor and count the number of Concurrent Users on a daily basis???

thanks for any help in advance,,,
Ed McClung
Database Administrator
ESCO Corporation
(503) 778-6275
(503) 778-6754 (Fax)
(503) 599-4813(pager)
edmcclung@escocorp.com
http://www.escocorp.com

Date: Wed, 11 Aug 1999 12:41:47 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Script to count #Concurrent Users

Can't help with the script but just wanted to clarify something. Oracle does do different type of pricing. Or at least they used to. I have seen Named Users as opposed to Concurrent Users.

Regards,
Joe Maliszewski
Consultant

Date: Wed, 11 Aug 1999 12:40:42 -0400
From: John Raams jraams@mvest.com
Subject: RE: Script to count #Concurrent Users

Just for interest oracle has stopped selling there "stuff" on a concurrent user basis. It is all now Named and Casual users. I believe that if you are a current Oracle client that this change will not effect you unless you buy new modules. The change came into effect somewhere around Dec last year.

John Raams
Executive Vice President & General Manager,
Enterprise Applications Solutions

Date: Wed, 11 Aug 1999 13:10:47 -0400
From: John Raams jraams@mvest.com
Subject: RE: Script to count #Concurrent Users

correct they used to being the optimum word they do not do it now. 90% of the apps are now sold by named user

John Raams
Executive Vice President & General Manager,
Enterprise Applications Solutions

Date: Wed, 11 Aug 1999 10:45:49 -0700
From: Barbara Douglass BDouglass@FairIsaac.com
Subject: RE: Script to count #Concurrent Users

The number of concurrent users is simply: select count(*) from fnd_user under the apps account for each set of books.

I recently went through the same exercise. Oracle does seem to be using the term, "Named Users" now.

Barbara

Date: Wed, 11 Aug 1999 13:26:45 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Script to count #Concurrent Users

Sorry, but this will not get concurrent users. It won't even give you an accurate named users count, since it fails to take into account start and end dates on the fnd_user rows. See my other post for concurrent users active at any given time.

Date: Wed, 11 Aug 1999 13:30:26 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Script to count Concurrent Users

Barbara,I think it gives idea about the how many users are on ur system but it doesn't mean that all users are logged on at the same time. When nos. of users are using system concurrently at that moments we can consider about the licensee limits. Correct me if I am wrong.

Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249

Date: Wed, 11 Aug 1999 13:00:58 -0700
From: Barbara Douglass BDouglass@FairIsaac.com
Subject: RE: Script to count Concurrent Users

Yes, your right. I know you need to take into consideration the end_dates to make sure that the user is still valid - but as far as named user goes - how many users are setup in the Oracle Apps environment to make sure that you don't have more users setup than you have licenses for - can't you get this information from fnd_user?

Thanks, Barbara

Date: Wed, 11 Aug 1999 13:41:31 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Script to count #Concurrent Users

I think you can get the max. concurrent users is obtained by looking at the view v$license in any database. Please update me if I am wrong.

Thanks, -chakrapani

SQL desc v$license

NameNull?  Type
------------------------------- -------- ----
SESSIONS_MAX NUMBER
SESSIONS_WARNINGNUMBER
SESSIONS_CURRENTNUMBER
SESSIONS_HIGHWATER NUMBER
USERS_MAX NUMBER

SQL select * from v$license;

SESSIONS_MAX   SESSIONS_WARNING   SESSIONS_CURRENT   SESSIONS_HIGHWATER   USERS_MAX
------------ ---------------- ---------------- ------------------ ----------
0022 240

Date: Wed, 11 Aug 1999 13:33:19 -0500 From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Script to count Concurrent Users

This will include sessions which are not Apps users, such as concurrent manager sessions, SQL*Plus, db link sessions, etc.

Date: Wed, 11 Aug 1999 13:14:11 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Script to count #Concurrent Users

Apps seats are indeed almost exclusively named. However, licensing for the Oracle Web server (Oracle Applications Server) can be concurrent. So if you happen to use that only for an NCA Apps install, know the count of concurrent users can be important.

set pages 0
set lines 30
set head off
set feedback off
spool d:\temp\temp.log
select to_char(count(*)) ||chr(09)|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') from
(select distinct
vs.process OSPid
from v$session vs,
v$process vp,
fnd_login_responsibilities flr,
fnd_application fa,
fnd_logins fl,
fnd_user fu,
(select pid, max(login_id) login_id from fnd_logins where end_time is null group by pid) flid
where vp.pid = fl.pid
and fl.pid = flid.pid
and fl.login_id = flid.login_id
and vp.background is nullv and vp.addr = vs.paddr
and vs.osuser = fl.login_name
and flr.login_id = fl.login_id
and flr.resp_appl_id = fa.application_id
and flr.end_time is null
and fl.user_id = fu.user_id
and fl.end_time is null
and fl.spid = vs.process);
spool off
exit

Date: Wed, 11 Aug 1999 15:08:19 -0400
From: "Stephen J. Farley" sfarley@us.redwoodsw.com
Subject: Re: Script to count Concurrent Users

As an ISV, we use the "rule-of-thumb" of one Concurrent User for each three Named Users to size our Information Delivery feature.

Steve Farley 610.722.5185

Date: Wed, 11 Aug 1999 17:17:37 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: GEN: Script to count Concurrent Users

It was brought to my attention that my script had an unnecessary reference to fnd_login_responsibilities. As a result of that, it only works if you audit logins at, at least, the responsibility level.

Here is a simplified version that does not require that.

select to_char(count(*)) ||chr(09)|| to_char(sysdate, 'DD-MON-YYYY HH24:MI:SS') from
(select distinct
vs.process OSPid
from v$session vs,
v$process vp,
fnd_logins fl,
fnd_user fu,
(select pid, max(login_id) login_id from fnd_logins where end_time is
null group by pid) flid
where vp.pid = fl.pid
and fl.pid = flid.pid
and fl.login_id = flid.login_id
and vp.background is null
and vp.addr = vs.paddr
and vs.osuser = fl.login_name
and fl.user_id = fu.user_idv and fl.end_time is null
and fl.spid = vs.process);

Date: Wed, 11 Aug 1999 19:30:08 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Script to count Concurrent Users

Ernie,

As you suggested it may give all the details.
But if you set the Audit Profile Options ON, you can easily find out all these details with the help of fnd_signon_audit_view view. You can also get the text in creating this view from user_views.

Thanks.
-chakrapani