Concurrent Progrem is getting resubmitted after every 2 minutes
Date: Wed, 11 Aug 1999 15:54:36 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
Subject: RESUBMIT PROBLEM
hI
ONE OF OUR USER HAS REQUESTED A CONCURRENT PROGRAMME WHICH IS GETTING
RESUBMITTED FOR
EVERY 2 MINUTES.
ITS BEEN CREATING LOT OF PROBLEMS TO US , IS THERE ANYWAY TO KILL THIS
PROGRAMME FROM RE EXECUTION.
ANY ADVICES HIGHLY APPRECIATED
THANKS IN ADVANCE
KUMAR
Date: Wed, 11 Aug 1999 16:03:33 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: Re: RESUBMIT PROBLEM
Log in as Sys.Admin
select the particular job
Click on ---cancel request .
Date: Wed, 11 Aug 1999 13:01:34 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: RESUBMIT PROBLEM
Cancel the request(s). Once you have gotten all "pending" and "scheduled"
submissions of the request terminated, it will not resubmit, until someone
tells it to.
Karen Blackwell
DBA/System Administrator
RockShox, Inc.
408.570-4912 phone
408.435.7468 fax
Date: Wed, 11 Aug 1999 15:13:09 -0500
From: "Vikram Reddy" Vikram_Reddy@intervoice.com
Subject: Re: RESUBMIT PROBLEM
In View Concurrent Requests screen go to the details zone of the
scheduled request and enter end date,time and save it .
Cheers
Vikram.
Date: Wed, 11 Aug 1999 16:08:43 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: RESUBMIT PROBLEM
You will find a 'Pending','Scheduled' request for that particular request
and cancel that request.
-chakrapani
Date: Wed, 11 Aug 1999 13:25:41 -0700
From: CFowler@littonapd.com
Subject: RE: RESUBMIT PROBLEM
Hi,
Yes. Using the System Administration responsibility go to
Concurrent:Requests and query up all Phase=Pending, Status=Scheduled
concurrent requests. You then can cancel the one concurrent request that
keeps getting re-submitted every two minutes. If you know that userid that
submitted the request, you can add that to the query for all pending
scheduled concurrent requests.
I hope this helps.
We are 10.7 16.1SC.
Candace
Date: Wed, 11 Aug 1999 16:28:14 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
Subject: RE: RESUBMIT PROBLEM
hi guys
i just cancelled the request
Thanks to all the programme got cancelled
thanks for who responded
kumar
Error on compiling Views
Date: Wed, 11 Aug 1999 17:39:01 -0700
From: "AmyTse" amy@idec.com
Subject: AOL: ERROR WHEN COMPILING VIEW
Hi all:
I get the following error when compiling the views:
SQLalter view apps.RA_CUSTOMER_TRX_LINES_FRT_V compile;
alter view apps.RA_CUSTOMER_TRX_LINES_FRT_V compile
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17005], [3], [3413919968],
[3387487632], [3413644376], [], [], []
SQLalter view apps.ra_customer_trx_lines_v compile;
alter view apps.ra_customer_trx_lines_v compile
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17005], [3], [3414307232],
[3387487632], [3413644760], [], [], []
SQL alter view apps.ra_cust_trx_line_salesreps_v compile;
alter view apps.ra_cust_trx_line_salesreps_v compile
*
ERROR at line 1:
ORA-00600: internal error code, arguments: [17005], [3], [3414120656],
[3387487632], [3413644760], [], [], []
Does anyone has any workaround? I am using HP-UX 11, RDBMS 7.3.4.4,
and APPS 10.7 (smart client)
Thanks,
Amy
Date: Wed, 11 Aug 1999 20:08:38 -0400
From: Sudershan virdi virdi@interlog.com
Subject: Re: AOL: ERROR WHEN COMPILING VIEW
better contact support.
Sudershan
Date: Wed, 11 Aug 1999 18:46:22 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: AOL: ERROR WHEN COMPILING VIEW
I experienced this not long ago. When I called Oracle they wanted me
to upgrade. I resisted because the problem was in test and not
production which both were exactly the same. I pushed hard but they
had no answer. Being determined I wanted to solve this because
production would compile where test would not. I do not recall the
exact views and packages involved.
Here is what I had to do.
Some of the views will refer to packages or other views in the system.
One by one try to recompile these referenced views and packages. Even
if they are already valid perform a recompile. Once this is done then
try the original view / package giving you the ora-600. I am not sure
this will work for you but it did work for me.
I then proceeded to call oracle back and request that they document
this process for future refernce. Not sure if this happened.
Kevin
Good luck.
Date: Wed, 11 Aug 1999 19:50:55 -0700
From: "AmyTse" amy@idec.com
Subject: RE: AOL: ERROR WHEN COMPILING VIEW
Thanks! Kevin. I got the same message (to do an upgrade)
from Oracle. I finally solved the problems by recompiling
the objects several times. It works fine!
Amy
Request Submisssion error
Date: Thu, 12 Aug 1999 08:44:19 EDT
From: "Apps User" apps_user@hotmail.com
Subject: REQUEST
SUBMITIONS***************URGENT*****************************
Hi Everybody,
We are having a problem submitting requests. We get the following
error message.
----------------------------
APP-01564:ORACLE error-20160 in SUBMIT: others
Cause: SUBMIT: others failed due to ORA-20160: ORACLE error-4091 in SUBMIT:
others.
Cause: SUBMIT: others failed due to ORA-04091:table
APPLSYS.FND_CONCURRENT_REQUESTS is mutating,
trigger/function may not see it.
The SQL statement being executed at the time of the erroe was: &SQLSTMT and
was executed from the file &ERRFILE.
ORA-06512 at “APPS.ALR_FND_CONCURRENT_REQUEST_IAR’, line
ORA-04088: error during execution if trigger
‘APPS.ALR_FND_CONCURRENT_REQUEST_IAR’.
The SQL statenebt being executed at the time of the error was: &SQLSTMT and
was executed from the file &ERRFILE.
----------------------------
All the users are getting the same error when submitting the requests.
Looks familier ?? Please suggest a solution.
Thanks.
Date: Thu, 12 Aug 1999 09:10:49 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: REQUEST SUBMITIONS***************URGENT**********************
Hi,
I cannot exactly imagine what is the error.
But I would recompile INVALID objects
and release any locks on fnd_concurrent_requests table or any
other FND table.
Please also try bouncing the Conc. Mgr.
Thanks,
-chakrapani
Date: Thu, 12 Aug 1999 08:46:17 -0500
From: "Landa, Mark (c)" U25MIBG@Carlson.com
Subject: RE: REQUEST SUBMITIONS***************URGENT**********************
It appears a trigger was created on fnd_concurrent_requests when someone
defined an alert. To get around the problem for now disable trigger
"APPS.ALR_FND_CONCURRENT_REQUEST_IAR" then go back and take a look at the
alert that may have created this trigger.
Date: Thu, 12 Aug 1999 07:55:47 -0700 (PDT)
From: Andy Schindler aschindl@yahoo.com
Subject: Re: REQUEST
SUBMITIONS***************URGENT*****************************
Someone has defined a bad alert on the table
FND_CONCURRENT_REQUESTS.
Review all of your event alerts on this table starting
with the newest one added.
Andy Schindler
NRC, Inc
From: John Sweeney jsweeney@goaa.org
Reply-To: oraapps-l@cpa.qc.ca
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: REQUEST SUBMITIONS***************URGENT**************************
Date: Mon, 16 Aug 1999 08:52:42 -0400 (EDT)
When I've seen this message below, someone had set-up a "bad" Alert to run
against the FND_CONCURRENT_REQUESTS table.
APPLSYS.FND_CONCURRENT_REQUESTS is mutating
John Sweeney
GOAA, IT Department
407-825-3280
Date: Tue, 17 Aug 1999 15:48:04 EDT
From: "Apps User" apps_user@hotmail.com
Cc: jsweeney@goaa.org
Subject: Re: REQUEST
SUBMITIONS***************URGENT**************************
John Sweeney,
What did you do to get the system back. We tried to disable the
alert, but it is not working. We purged all the information
in Fnd_concurrent_requests, it is not working. The only way,
was disable the trigger. We did that -- it may not be advisable
to do so as we dont know the effects of diabling this
(ALR_FND_CONCURRENT_REQUEST_IAR) trigger.
One good this about the whole issue is that, this is happening
in one of our test instances.
Please advice.
Thanks,
AR_CASH_RECEIPTS_V database view missing
Date: Thu, 12 Aug 1999 12:58:34 PDT
From: "Sapan Rawal" sapanr@hotmail.com
10.7 SC, Financials - AR
Responsibility - Receivables Mgr GUI
Navigate - Receipts/Receipts
Query - Find All
Database Error. (FRM-40505: Oracle error - unable to perform query)
We don't have AR_CASH_RECEIPTS_V database view.
Does anyone know the fix?
Thanks,
Sapan
Date: Fri, 13 Aug 1999 19:15:35 +1000
From: "Mckenzie, Rosemary" ROSEMARY.MCKENZIE@cai.com
In $AR_TOP/admin or $AR_TOP/install there's a directory odf with a lot of
.odf files in there. If you grep the directory to find the file with the
AR_CASH_RECEIPTS_V view in it you can then run the command and file name. I
think the syntax for the command is in one of the upgrade or install manuals
(it was a while ago since I did it). Hope this helps.
How to setup system to ensure that users change their passwords after defined period
Date: Fri, 13 Aug 1999 09:19:47 -0400
From: "Epp, Charles A" cepp@kpmg.com
Subject: PASSWORDS
Good morning, fellow seekers of knowledge. We're currently using Oracle
10.7 (Govt) Version 7. Is there a parameter or setting that can be enabled
at a site and/or application level to prompt all users to reset their
passwords at a defined period (ie. 60 days). All I can find is a form that
can be set user by user (which can be time-consuming if you're already up
and running and have many users). If not, is there any Oracle version that
has this capability. Thanks for any help.
Date: Fri, 13 Aug 1999 06:52:51 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: PASSWORDS
Actually the funcionality does not exist to my knowledge. However, if
you were to set the PASSWORD_DATE column in the FND_USER table to NULL
this will cause the password to expire. You need to be sure not to
expire every row in FND_USER. This table also contains system accounts
like SYSADMIN, and AUTOINSTALL and others.
Kevin
Kevin Gillins
Oracle Applications Consulting
WEB PAGE
Date: Fri, 13 Aug 1999 07:24:06 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: PASSWORDS
Or, rather than expiring all passwords "now", set the PASSWORD_LIFESPAN_DAYS
to 60. Then, ever 60 days (or whatever value) the password will expire and
users will be forced to change them.
It is our policy when setting up users that the expiration is set to 90
days.
HTH
Date: Fri, 13 Aug 1999 09:23:13 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: PASSWORDS
you can set it through the sql*plus with a script.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Fri, 13 Aug 1999 10:57:12 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: Forcing SQL Users to change their SQL*PLUS PASSWORDS
Bharat,
You are saying about the script to be used in Oracle 8.0 for SQL*PLUS only (
but not
for ORacle Apps ).
You can write a procedure on dba_users to force the users to change their
passwords after 60 days or whatever in ORacle 8.
Oracle 8 has introduced, some profile options ( not listed anywhere ....)
like PASSWORD_VERIFY_FUNCTION, PASSWORD_REUSE_MAX, PASSWORD_LOCK_TIME
and PASSWORD_GRACE_TIME etc.
You can write a function to verify the passwords and see that they will not
exist in a
commonly used passwords like WELCOME,hello, john, williams,tom etc. that are
stored in a separate table. You can bind this function to the
PASSWORD_VERIFY_FUNCTION
of the user.
You can also set the other Profile options for the user to force him change
in SQL*Plus.
Date: Fri, 13 Aug 1999 11:12:02 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Forcing SQL Users to change their SQL*PLUS PASSWORDS
No, I am talking about creating a script by leaving the
apps,applsys,applsyspub etc users. and set the password expiration time to
nos of day. using FND tables.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Fri, 13 Aug 1999 10:47:58 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: PASSWORDS
Karen,
Setting the Expiry Date to 60 will cause the Apps SYSADMIN face nightmares
on 60th day as every user will call SYSADMIN as they cannot login to Apps.
There is no other way for this. I worked in implementing Security for the
users
but there was no other way.
But there is a way of storing their old passwords.
Whenever a row inserted on the password column is updated, you can write a
trigger
to store the user_id,user_name and password1,encoded_password1,
password2,encoded_password etc in another table.
After Sixty days you can insert the old password and encoded password into
fnd_user
table for all the users.
But you have to mail them that they will have to login with their old
password
after 60 days. This is a tedious way.
It is a little confusing....Isn't it ?
-chakrapani
Date: Fri, 13 Aug 1999 10:49:00 -0500
From: "Haseman, Neil" nhaseman@BCSINS.COM
Subject: RE: PASSWORDS
The user will receive a prompt that their password has expired and that they
should enter a new password. The only time my users call me when they can't
get in, is if they forget their password which does happen occasionally. By
the way we are 10.7 char.
Neil Haseman
BCS Financial Corp
Date: Fri, 13 Aug 1999 10:50:56 -0500
From: "Krzes, Joe" JKrzes@smith.com
Subject: RE: PASSWORDS
FYI,
Oracle apps supports "pass phrases" so if you have a user that
consistantly forgets their password, suggest that they use "I hate work" or
something like that. They won't forget it and it's hard to hack.
Joe
Date: Fri, 13 Aug 1999 09:10:47 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: PASSWORDS
The same holds true for 10.7NCA (and I would also assume so for 11.x). The
user is prompted that their password has expired and they need to enter a
new one before they can access the apps. I have only had to "hand-hold" for
about 4 users (out of 200, not bad).
Much more common is the "I forgot what I changed it to" syndrome.
cheers
Date: Fri, 13 Aug 1999 09:14:22 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: PASSWORDS
what a good idea. I will make that suggest to my user community.
Identify all Users logged in at a particular time
Date: Fri, 13 Aug 1999 07:21:34 -0700 (PDT)
From: Praveen shirump@yahoo.com
Subject: Users
Hello Everybody,
Is there any way to find all the application users
logged in at any point of time.
We are in 11.0 App & 8.3 database.
Appreciate for any help.
Thanks.
Date: Fri, 13 Aug 1999 10:36:45 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Users
Praveen,
Set the following options at site level
AuditTrail:Activate Yes
AuditTrail:Activate Form
Now you can monitor all users from Security/User/Monitor screen and
with active users with forms and their resp.s
-chakrapani
Date: Fri, 13 Aug 1999 07:43:29 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: Users
I am not familiar with 11, but is there a "Monitor Users" option under
Security?
This is in 10.7NCA and shows all users logged in and what responsibility.
(Keep in mind that there are "usually" at least two entries per user. One
for "login" screen and one or more or open responsibilities.)
HTH
Date: Fri, 13 Aug 1999 09:57:45 -0500
From: Al Nass alnass@DOMINOAMJET.com
Subject: RE: Users
Under Security, Users, Monitor, Query, Find all
Date: 13 Aug 99 10:45:22 MDT
From: K Acharya acharyak@usa.net
To: oraapps-l@cpa.qc.ca, Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: [Users]
In system administration - profile system- choose the level as user and pick
the user name. In the system options pick Audit enabled and for this choose
the respective option ex. form level etc.
Once you enable this you can navigate to the monitor screen in system
adminisration and query you can see all the users logged in and if you have
enabled audit at form level you can also see what forms they are currently
using. This is to monitor Oracle Application users only.
Hope this helps
Acharya K V L N
Date: Sun, 15 Aug 1999 11:32:01 PDT
From: "prasad surisetty" surisettyp@hotmail.com
Subject: RE: Users
This one is not working on my screen. Is there any setup is required before.
Date: Sun, 15 Aug 1999 14:30:36 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Users
Prasad,
Just add these TWO profile option
Query for System profile options at Site level as "%audit%
and set Yes for Audit and level as "Forms".
v
After setting this , Signon again and you can see in
Security/User/monitor. This gives you all present users and their
applications
and resp.s and the FORM on which they are working right now.
Let me know if this works out or not.
-chakrapani
Date: Mon, 16 Aug 1999 10:19:55 -0500 From: Al Nass alnass@DOMINOAMJET.com To: oraapps-l@cpa.qc.ca Subject: RE: Users Message-ID: F2489DD7C4DED21184FD00105AA33D8E412290@CLAVIN I forgot to mention that you have to have System Administration responsibility. Beyond that, I don't know of any special set-up.
Date: Mon, 16 Aug 1999 09:27:19 -0700
From: Karen Blackwell KBlackwell@rockshox.com
Subject: RE: Users
It is my assumption that if you can get to this Navigation, you have the
appropriate responsibilities. Perhaps - and I am not certain on this - you
need to turn on Audit Trail. Go to System Profiles and set
AuditTrail:Activate=YES. In version 11/8 I believe there is a need to also
set a Form Audit value to YES also.
(I am on 10.7NCA/7 and so I am not sure on this one.)
HTH
Date: 16 Aug 99 12:51:15 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: RE: Users
The profile option "AuditTrail:Activate" has to be set to "Yes". Also, the
Profile Option "Sign on: Audit Level" has to be set to something other than
"None" for the form to return any rows when you query in the form. This is on
11.0.2.
HTH, Craig
Craig Yedinak
Independent Consultant
Date: Mon, 16 Aug 1999 16:04:12 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: Script to view Existing ONLINE users WITHOUT setting any PROFILE
All,
If you are that LAZY to set the PROFILE options, try creating a view
exactly as follows and create a public synonym.
+++++++++++++++++++++++++++++++++++
SELECT L.USER_ID , L.TERMINAL_ID , L.LOGIN_NAME , R.RESP_APPL_ID ,
R.RESPONSIBILITY_ID , F.FORM_ID , F.FORM_APPL_ID , L.PID ,
FLOOR((SYSDATE - L.START_TIME)*24) || ':' ||
LTRIM(TO_CHAR(ROUND(((SYSDATE - L.START_TIME)*24 - FLOOR((SYSDATE -
L.START_TIME)*24))*60), '09')) TIME ,
USR.USER_NAME , RSP.RESPONSIBILITY_NAME , FRM.USER_FORM_NAME
FROM FND_LOGINS L, FND_LOGIN_RESPONSIBILITIES R, FND_LOGIN_RESP_FORMS F,
FND_USER USR, FND_RESPONSIBILITY_TL RSP, FND_FORM_TL FRM
WHERE R.LOGIN_ID = F.LOGIN_ID (+)
AND L.LOGIN_ID = R.LOGIN_ID (+)
AND L.END_TIME IS NULL
AND R.END_TIME IS NULL
AND F.END_TIME IS NULL
AND L.USER_ID = USR.USER_ID
AND R.RESPONSIBILITY_ID = RSP.RESPONSIBILITY_ID (+)
AND R.RESP_APPL_ID = RSP.APPLICATION_ID (+)
AND RSP.LANGUAGE (+) = USERENV('LANG')
AND F.FORM_ID = FRM.FORM_ID (+)
AND F.FORM_APPL_ID = FRM.APPLICATION_ID (+)
AND FRM.LANGUAGE (+) = USERENV('LANG')
AND (L.SPID, L.LOGIN_NAME) IN (SELECT SPID, USERNAME FROM FND_V$PROCESS)
Other sites hosting similar scripts :
http://www.geocities.com/SiliconValley/Network/9828/index.html
fndusrmap.sql at www.appsdba.com/apps_sql.htm
How to link FND_CONCURRENT_PROCESS table to the FND_CONCURRENT_REQUEST table
Date: Mon, 16 Aug 1999 11:17:59 -0400
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
Subject: Find concurrent process
How can I relate the FND_CONCURRENT_PROCESS table to the
FND_CONCURRENT_REQUEST table. I'm trying to identify the UNIX process
associated with a concurrent request. Any help greatly appreciated -
thanks!
Date: Mon, 16 Aug 1999 11:20:31 -0400
From: "Innamuri, Chakrapani" cinnamuri@btg.com
Subject: RE: Find concurrent process
controlling_manager of FND_CONCURRENT_REQUEST is the process_id of
fnd_concurrent_processes.
-chakrapani
Date: Mon, 16 Aug 1999 12:24:25 -0400
From: "Gow, Tony" GOWA@tc.gc.ca
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Find concurrent process
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