Web application error - APP-09999
Date: Mon, 14 Jun 1999 14:57:34 -0700 (PDT)
From: Nirmal Kumar appsdev_99@yahoo.com
Subject: Hi Folks .Web application error
Hi Folks
we are working with apps 11.0.2 .When we bounce
the server,we struck with the error,App-09999.
When we signon to the apps,it is saying
It's saying that the applications server,doesn't authorize to access
database server.Could any one please help me in solving this error.
Nirmal Kumar.P
Problem creating conc. mgr
Date: Tue, 15 Jun 1999 10:13:51 +0500
From: Faisal Yasin fyasin@ora-tech.com
Subject: Concurrent Manager Problem rel.11.0.28
hi all ,
Im having problem when im creating conc. manager.
Product : Oracle Financials.
Product Version : 11.0.28
Database Server : 8.0.4
Operating System : Windows NT 4.0
Problem Description : When i try to create concurrent manager it returns
the following error.
Error Message : Service not started. Check the event log for more
information.
Exit Code: 0
Service Specific Exit Code: 0
Event Log : The description for Event ID ( 0 ) in Source
(OracleConcMgrorcl )
could not be found. It contains the following
insertion string(s):
Cannot connect to database. sid= orcl. ora
error: 3121..
Please help me as soon as possible.
Thanks.
FY
View Concurrent Request privileges
Date: Tue, 15 Jun 1999 14:25:11 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Sysadmin View Concurrent Request privileges
Hi,
I am in 11.02, under my own Id, with Sysadmin responsibility, and would like
to view all users' concurrent requests. I am unable to do so, unless I
specify the User or other criteria in the Find screen of "View My Requests".
The older versions allowed you to view requests under Sysadmin, which would
view all users' requests.
Can anyone tell me if this is still possible, and what I need to do to see
what users are running out there?
Thank you,
Bill
Date: Tue, 15 Jun 1999 14:43:08 -0400
From: tpapaleo@hearst.com (Tom Papaleo)
Subject: Re: Sysadmin View Concurrent Request privileges
go under sysadmin responsibility/concurrent/requests
query all requests
tom
Concurrent Managers stalling
Date: Wed, 16 Jun 1999 09:22:23 +1200
From: Mark Healey MHealey@swichtec.co.nz
Subject: Concurrent Managers
After a spate of patching in the last couple of weeks our concurrent
managers are 'Stalling' i.e. the managers are all active however no
transactions are being processed. This happens on an adhoc basis and the
following error is encountered
APP-01227 AFPCSQ encountered an ORACLE error.
Has anyone experienced the same.....
Our details are;
database 7.3.2.3.14
applications 10.7 on NT
client SmartClient 16.1 GUI
Mark (Austin) Healey
Date: Wed, 16 Jun 1999 11:37:27 +1200
From: Nicolas Woollaston NWoollaston@swichtec.co.nz
Subject: RE: Concurrent Managers
Mark
From what I can deduce, this routine maintains process ids, etc in
fnd_concurrent_processes. It grabs them from the server while things run
and then updates the table.
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
Date: Wed, 16 Jun 1999 11:00:00 +0100
From: "Singh, Gagandeep " Gagandeep.Singh@scottishpower.plc.uk
Subject: RE: Concurrent Managers
You could try doing the following.
Shutdown your conc. manager.
1) Update fnd_concurrent_queues
set running_processes0;
2) Delete from fnd-concurrent_processes;
Re-start the conc. managers again.
HTH
Gagan
Org_id for concurrent requests
Date: Wed, 16 Jun 1999 10:18:51 -0400
From: "Mike Brown" mbrown@glenraven.com
Subject: org_id for concurrent requests
Does anyone have a clue about how to find the org_id that a concurrent
request is being run for? I am trying to get an estimate of the load
that each of our orgs is putting on the server, so I need a generic way
of finding this information.
Thanks
Date: Thu, 17 Jun 1999 11:07:33 +0530
From: manoj_bhatnagar/Polaris@polaris.co.in
Subject: Re: org_id for concurrent requests
Hi Michael
Here is the Solution to your query.
After execution of the Concurrent request. Do the following :-
1. Go to Help-Tools-Examine.
2. It will show you a block. Click on the List button aside the Field
"Field".
3. It will show you all the fields in that block.
4. Find out the field name ORG_ID in that list and if it there, double
click on it.
5. It will show you the value of the ORG_ID used in that request.
6. If the ORG_ID field is not there, Search it in other blocks.
I will try to find out other solution also if I can and let you know.
Enjoy.
Manoj Bhatnagar.
Associate Consultant-Oracle Applications.
11.02 clients being kicked off Apps frequently
Date: Wed, 16 Jun 1999 15:04:23 -0700 (PDT)
From: Nirmal Kumar appsdev_99@yahoo.com
Subject: Problem in 11.0.2 clients
Hi Folks,
We have Oracle Applications 11.0.2 .Operating
system is solaris 2.6.Our system was smmothly till
last friday.When we bounced the system,we got problems.
We are using appletviewr in client side.
One major problem we have right now is that the clients
are being kick out frequently from the applications.
Could any one help us in solving this problem?
Thank You
Nirmal
Creating Dynamic Parameters for Concurrent Requests
Date: Wed, 16 Jun 1999 19:57:34 -0700
From: Michael Blunck michael.blunck@aris.com
Subject: Creating Dynamic Parameters for Concurrent Requests
Without using a product like AutoSys, has anyone ever created a parameter
for a concurrent request that was dynamic. To me dynamic would mean that if
you scheduled this concurrent request to be resubmitted everyday could a
parameter, with a value of 'SELECT sysdate from dual', be the current system
date that the concurrent request was run. Currently this parameter will
work for single submissions of the process, but when it is resubmitted the
parameter remains as it was at the time of the original submission.
Thanks in advance,
Michael F. Blunck
Managing Principle Consultant
ARIS Corporation - Denver
Setup New FND_USERS via back-end
Date: Thu, 17 Jun 1999 17:06:17 -0700
From: "James H. Lui" jlui@intelligencia.com
Subject: Setup New FND_USERS via back-end.
Are there any useful scripts anyone knows of to populate the
FND_USER table based upon an pre-existing employee table (which
is already feeding PER_PEOPLE_F, so each one already has a valid
PERSON_ID and a 8 character unique short-name).
Particularly noisome has been the encryption calls for the
ENCRYPTED_FOUNDATION_PASSWORD and ENCRYPTED_USER_PASSWORD
columns in FND_USER.
Anyone have an insight as to how the functions get called?
--
J-L
Conc. Mgr not running
Date: Fri, 18 Jun 1999 09:55:13 +0500
From: Faisal Yasin fyasin@ora-tech.com
Subject: [ Rel. 11 Concurrent Manager Problem ]
My concurrent manager is not working. i mean service is started
succesfully
but conc. manager is not working.
When i start conc. manager service it started but after few secconds.
Dr. watson appears and says
application error access violation cx000005 see application log.
and application log shows the following text.
The application, D:/appldev\fnd\11.0.28\BIN\DLL/rel\FNDLIBR.exe,
generated an application error The error occurred on 6/17/1999 @
17:38:33.989 The exception generated was c0000005 at address 017efe9b
(nosymbols)
I dont know why that path is appearing, because my APPL_TOP is
G:\applvd11 so the FNDLIBR is G:\applvd11\fnd\11.0.28\bin.
Please help me ....
Thanks.
Text for Toolbar Shortcut keys
Date: Fri, 18 Jun 1999 10:32:51 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Text for Toolbar Shortcut keys
Does anyone know how to get the text for the Toolbar shortcut keys (when you
sit on them with the mouse) in the apps version 11.02?
We have it in 10.7, is this an install issue in v. 11?
Thank you in advance for any help/comments.
Bill
Date: Fri, 18 Jun 1999 10:53 -0500
From: "Richard du Feu" Richardd@care.ca
To: "Bill Keenan" oraapps-l@cpa.qc.ca
Subject: Re: Text for Toolbar Shortcut keys
Is your 10.7 SC? According to Oracle Support, "tool tips" on the
toolbar are not possible in an NCA environment. This is due to the
Web technology. The entire toolbar would have to mapped to a grid.
This is what I was told by Oracle, as I had logged a TAR for this a
few months ago.
Date: Fri, 18 Jun 1999 11:19:41 -0400
From: "Bill Keenan" bkeenan@goodegg.com
Subject: Re: Text for Toolbar Shortcut keys
Thank you for your help on this!
Bill
Applying patches
Date: Sun, 20 Jun 1999 14:28:01 -0700
From: R Bhandarkar ak494@xoommail.com
Subject: applying patches
we're on oracle apps 10.7 sc. oracle 7.3.4, I have to a
apply patches p,q,r on oracle a/r. What would you'll
recommend ,apply them all at once and test or apply them one
at a time and test?
TIA
Raja
Date: Mon, 21 Jun 1999 05:07:27 -0500
From: Nanda Kishore nkishore@csac.com
Subject: Re: applying patches
The patch sets are cumulative. So, the patch set 'R' has all the fixes
included in 'P' and 'Q' and a little more. So, you just need to apply the
latest patch set only.
Good luc,
Nanda
Date: Sun, 20 Jun 1999 21:42:33 -0500
From: Mahesh_Sookram@gallup.com
Subject: RE: applying patches
My question as far as the patches go is why not directly test and apply
patchset R and forget about P and Q; I thought they were supposed to be
cumulative patchsets. We have recently upgraded from 7.3.3.5.1 to 7.3.4.4.0
on HP-UX 10.20, with core dumps associated with relinking Apps executables.
Seems to happen at the end when the adrelink program is line-wrapping the
log file for readability. We have also gotten ora-error 12547: TNS lost
contact which have caused server-side sql programs to fail. Oracle support
helped us create a sqlnet.ora file with the following contents and the TNS
problem seemed to go away. I think it is the AUTOMATIC_IPC = OFF in the
sqlnet.ora file that helped us. (You would definitely want to try this on
test before production.)
The $ORACLE_HOME/network/admin/sqlnet.ora file:
AUTOMATIC_IPC = OFF
TRACE_LEVEL_CLIENT = OFF
NAMES.DIR_PATH = (TNSNAMES)
SQLNET.EXPIRE_TIME=0
Thanks,
Mahesh
Date: Mon, 21 Jun 1999 08:10:08 -0400
From: "Gow, Tony" GOWA@tc.gc.ca
Subject: RE: applying patches
My understanding from Oracle was that Patchset P was cumulative but that
Patchset Q was NOT in that it only contained fixes and was not a complete
module replacement. I am not sure if they have reverted back to the
cumulative model for Patchset R but that should be verified before
determinig your strategy for applying patches.
In terms of applying the patch, this will amke a difference. If cumulative,
just apply 'R' and test. If non-cumulative, you could devise a patch
strategy where you apply, test, apply, test etc.. It is the only way you
will know for sure which Patch caused the problem. It all depends on the
level of risk you and your system owners are willing to assume.
990-9177
Conc Mgr going to sleep often
Date: Mon, 21 Jun 1999 16:27:06 +0530
From: Gopalakrishnan K gopalak@wiproge.med.ge.com
Subject: Concurrent Manager
Hi
What is the cause for inactivation of
concurrent managers. My concurrent managers
are going to sleep atleast thrice in a day.
I have to activate the managers frequrntly.
Is there any way where i can find the status of
the concurrent managers ( Other than Administer manager)
Through Alert or Mail
HTH
Regards !
Gopalakrishnan K
Database Administrator
GE Medical Systems Limited.
Pune 411014, INDIA
Date: Mon, 21 Jun 1999 21:25:48 -0400
From: "Chadda, Alok" achadda@kpmg.com
To: "'gopalak@wiproge.med.ge.com'" gopalak@wiproge.med.ge.com
Subject: RE:Concurrent Manager
Gopalakrishnan -
I have the following script to find out the status of Concurrent manager.
You can use this to create an alert.
Script to display status of all the Concurrent Managers
set head on
Column OsId Format A10
Column CpId Format 999999
Column Opid Format 999
Column Manager Format A30
Column Status Format A20
Column Started_At Format A30
Column Cpid Heading 'Concurrent|Process ID'
Column OsId Heading 'System|Process ID'
Column Opid Heading 'Oracle|Process ID'
Column Manager Heading 'Concurrent Manager Name'
Column Status Heading 'Status|of Concurrent|Manager'
Column Started_At Heading 'Concurrent Manager|Started at'
Column Opid Justify Left
Select distinct Concurrent_Process_Id CpId, PID Opid,
Os_Process_ID Osid,
Q.Concurrent_Queue_Name Manager,
P.process_status_code Status,
To_Char(P.Process_Start_Date, 'MM-DD-YYYY HH:MI:SSAM') Started_At
from Fnd_Concurrent_Processes P, Fnd_Concurrent_Queues Q,
FND_V$Process
where Q.Application_Id = Queue_Application_ID
And (Q.Concurrent_Queue_ID = P.Concurrent_Queue_ID)
And ( Spid = Os_Process_ID )
And Process_Status_Code not in ('K','S')
Order by Concurrent_Process_ID, Os_Process_Id, Q.Concurrent_Queue_Name
;
...
HTH
Alok
Date: Tue, 22 Jun 1999 08:44:40 -0400
From: Renny Polo renden@wmol.com
Subject: Re: Concurrent Manager
Hai Gopalakrishnan,
Thanks for your suggesttion. Now it is working fine
Rgds
Renny Polo
Running Package procedure thru conc. prog.
Date: Mon, 21 Jun 1999 18:05:12 -0400
From: Renny Polo renden@wmol.com
Subject: Concurrent Program Help Required ***URGENT***
Hi All,
I would like to run a Pckaged procedure through a concurrent program request
in SRS. How can i do this by registering this executable object type as a
Database Procedure (Not through any other means like registering an executable
of Sql object type which calls this procedure internally).
I am getting the error message when i am trying to do this: "ORA-06550: line
1, column 7: PLS-00306: wrong number or types of arguments"
The above procedure does not have any parameters and is running fine in
Sql*Plus prompt.
Timely help is appreciated!
Regards,
Renny Polo
Haworth Inc.
Holland, MI -49423
Date: 21 Jun 99 17:13:52 MDT
From: vv vv venvivek@usa.net
Subject: Re: [Concurrent Program Help Required ***URGENT***]
Hi Renny.
U have mentioned that ur procedure dosent have any parameters. It is must to
have to out parameters namely errbuf varchar2 and retcode number to run Ur
procedure as a concurrent request. Add these two out parameters and try to
run.
With regards.
Vivek.
TNS Lisener Problem on Host Machine
Date: Tue, 22 Jun 1999 12:32:52 PDT
From: stephen bryant sbryant@hotmail.com
Cc: sbryant@bostongas.com
Subject: TNS Lisener Problem on Host Machine
I hope you have an experience with the following error message:
An error occurred while attempting to establish an application
file server connection with the node host name. There may
be a network configuration problem, or the TNS listener on
node host name may not be running.
I was trying to view a report or log of the Concurrent Manager form and got
the error message above; however, I was able to print these reports.
I appreciate your responses.
Thanks,
Steve
Date: Tue, 22 Jun 1999 16:01 -0500
From: "Richard du Feu" Richardd@care.ca
To: "stephen bryant" oraapps-l@cpa.qc.ca
Subject: Re: TNS Lisener Problem on Host Machine
It sounds as if you do not have your Report Review agent configured in
your TNSnames.ora and listener.ora files. You need to set up a
"pseudo" instance in these files for the FNDFS executable. This is
the file that allows on line viewing. You actually have to set this
up like you would set up a DB instance.
If you look in the installation guide it sould help you out. I know
its in chapter 4 for R11 installations. Not sure of 10.7.
Hope this helps,
Richard
Date: Wed, 23 Jun 1999 04:13:01 -0700 (PDT)
From: Stephen Rice ricey_cbsi@yahoo.com
Subject: Re: TNS Lisener Problem on Host Machine
Add a database alias as follows
Database instance: FNDFS_servername
TCP/IP Hostname:Server name
Database instance:FNDFS
Ricey
Date: Thu, 24 Jun 1999 15:42:05 GMT
From: "Mehmood." smehmoodapps@hotmail.com
Subject: Re: TNS Lisener Problem on Host Machine
I also faced the same problem.
I created the database alias as per you suggestion but again
it gave the same error while trying to view reports on-line.
I'm on 10.7, 16.1 SC, 7.3.4, Win'NT.
Any other suggestion?
Respectfully,v
Mehmood
Date: Thu, 24 Jun 1999 11:49:03 -0400
From: Adriana_Sanson@ncci.com
Subject: Re: TNS Lisener Problem on Host Machine
We too have experienced the problem below and here's what we have found...
If you were able to view the reports at one time, and now you get this error
message, check the files (server) below for any recent changes:
listener.ora
tnsnames.ora
sqlnet.ora
hosts
If none of the above files have changed, and the FNDFS entry is correctly
entered, check the tnsnames and hosts file on the client.
The last time we had the problem (just this past week), we were unable to find
what was causing the problem so we called Oracle. They suggested rebooting the
box (UNIX AIX box) and it actually worked.
I'm not sure why it worked...but it must have flushed something out...
We are on 10.7SC Prod16.1 RDBMS 7.3.3.5 using Winframe to deploy the
application.
Good Luck!!
Adriana
Date: Thu, 24 Jun 1999 11:20:58 PDT
From: stephen bryant sbryant@hotmail.com
Subject: Re: TNS Lisener Problem on Host Machine
Hi,
We found out the problem with the client-side configuration (win.ini) NT
file. We changed back from ORA_CONFIG=T:\FINPROD\ORAWIN\oracle.ini to
ORA_CONFIG=T:\ORAWIN\oracle.ini. After that, we are able to review the
on-line reports. We spent two weeks of trying to solve the problem.
Thanks for your time to respond my request via email messages.
Steve