SUBMIT_REQUEST Unable to See in Requests Form
Date: Fri, 7 May 1999 12:08:24 -0700 (PDT)
From: Arif Hussain arifhus@yahoo.com
Subject: AOL: SUBMIT_REQUEST Unable to See in Requests Form
Hi Everybody,
I have written an interface program which works
fine and extracts data when I submit using SRS. I
tried to call the program from a custom form using
fnd_request.submit_request (Supplied all 100
Argments!), it submits the request (got the request
ID) but I am unable to view the request/status in the
View Request form. Also the FND_CONCURRENT_REQUESTS
table does not return any records corresponding to the
request_id returned by the submit. As a whole the
program does not execute at all. Am I missing
something, do I have to call any other procedure to be
able to view the request.
Any help is greatly appreciated.
Thanks,
Arif.
Date: Fri, 07 May 1999 16:54:26 -0400
From: "Jaswinder S. Saini" jaswinder.saini@yale.edu
Subject: Re: AOL: SUBMIT_REQUEST Unable to See in Requests Form
Make sure you "Commit" after firing the request.
Thanks for your reply, I was missing the commit
but this is not mentioned in any of the AOL manuals.
What should I do in order to be able to view my
reports in the view Requests form? The idea is as soon
as I fire my interface it does the following using
concurrent processing.
1) Gets the upload file from a remote machine using
the ftp (Concurrent Program).
2) Uploads the file using SQL Loader (Concurrent
Program).
3) Generates the reports(which I want the users to
view directly from their GUI interface).
THis is just the upload part of the whole process,
can I make these programs as the report set and call
the report set from my form ? THe Basic idea I want is
how will I give the users an ability to view the
reports from their GUI interface(Server is Solaris).
As you mentioned it is being executed under an
anonymous user ID how will I get it into the Users
View request form or any custom built form.
Thanks again for your response.
Arif.
Date: Mon, 10 May 1999 07:49:05 -0600
From: "Rahman, Milan" milan_rahman@nrel.gov
Cc: "'arifhus@yahoo.com'" arifhus@yahoo.com
Subject: RE: RE AOL: SUBMIT_REQUEST Unable to See in Requests Form
Look at the FND_REQUEST.SET_OPTIONS and ensure that the IMPLICIT is set to
'No' (default). IMPLICIT YES,ERROR or WARNING keeps requests to be viewed
and is described on pg. 9-39 of AOL Reference Manual Release 10 Vol 2.
HTH.
Milan Rahman
Apps DBA
Softec Solutions, Inc.
Client: NREL
Host Concurrent Program
From: "chandu k" chandu_r@hotmail.com
Subject: Host Concurrent Program
Date: Mon, 10 May 1999 13:21:36 -0400 (EDT)
Hi all
A shell script has to run as a concuurent program.How do
I capture the parameters in the shell script entered by the
user in SRS?
Thanks
Date: Wed, 12 May 1999 00:55:48 PDT
From: "Ringo Jouhal" rjouhal1@hotmail.com
Subject: Re: Host Concurrent Program
there are a number of standard parameters passed in, these are
1. Username and password (in the format apps/apps)
2. User ID (from fnd_user)
3. User name (from fnd_user)
4. Request ID
The rest are the parameters you've defined against your job in AOL.
These are all captured as follows:-
l_user_psswd${1}
l_user_id${2}
l_user_name${3}
l_request_id${4}
etc..
I have masses of scripts, mail me on Ringo.Jouhal@Toshiba-TUK.com if you
want examples.
Ringo
Date: Wed, 12 May 1999 16:25:19 +0400
From: PeriasamyR@mashreqbank.com
Cc: Ringo.Jouhal@toshiba-tuk.com
Subject: RE: Host Concurrent Program
Hello Ringo,
Thank you for the scripts. The samples you have sent were very useful. Their
documentation was also very informative. Currently, there are certain
functional issues relating to the mainframe downloads, that are fully
engaging our attention. We would be developing similar scripts shortly and
would share any new issues that may arise (wrt to Rel 11 !!!).
Thanks once again,
Peri
Archiving data
Date: Wed, 12 May 1999 18:31:42 -0700
From: "Binh Pham" Binh.Pham@jpl.nasa.gov
Subject: Archiving data in PA/GL/FA....
A few days ago I have posed a question about archiving data from Oracle
Applications such as PA, GL, FA, etc...since our database size has grown to
60 gigabytes and is increasing by 6-8 gigs a month, and I have not seen any
reply yet.
Does this mean that no one out there has done this before? What is the size
of your Oracle Applications databases?
Thanks ahead for the responses.
Date: Thu, 13 May 1999 08:21:34 -0700
From: "Donna M. Armstrong" donnabsc@gte.net
Subject: Re: Archiving data in PA/GL/FA....
Hi,
Oracle has Archive/Purge functionality available for PA in beta
for release 10.7 They spoke about it at the San Diego OAUG conference
this spring. . .so you might want to see if you can participate in the
beta testing program.
Most of the other Financial modules development teams have been
looking into Archive/Purge functionality as well, but I'm not sure what
progress has been made.
Best of luck,
Donna
Date: Thu, 13 May 1999 16:53:40 -0400
Date: Fri, 14 May 1999 17:02:17 +0100
Date: Thu, 13 May 1999 07:55:59 +0300
Date: Thu, 13 May 1999 18:32:56 EDT Differentiating Production vs. Test Applets
Also refer :Initial Signon Screen
From: Alan Hyland [mailto:alan_hyland@saan.ca]
From: Bharat Patel [mailto:bpatel@DOMINOAMJET.com]
Date: Thu, 13 May 1999 17:05:37 -0700 Return Code and Concurrent Manager
"Lewis, Keith" keith.lewis@us.landisstaefa.com
Date: Fri, 14 May 1999 13:56:46 -0500 Concurrent job visibility issue
From: Srini Chavali Srini_Chavali@notesbridge.cummins.com
From: Stephen J. Farley sfarley@us.redwoodsw.com Change database / application passwords
From: Gow, Tony [mailto:GOWA@tc.gc.ca]
--- "Lakdawala, M" M_Lakdawala@csx.com wrote:
Date: Thu, 20 May 1999 09:22:28 -0700 (PDT)
Date: Thu, 24 Jun 1999 15:50:13 -0700
Date: Fri, 25 Jun 1999 10:32:09 +0930 AOL: FND 10.7 Patchset C server-side(774541)
Date: Thu, 20 May 1999 15:54:47 -0400
Date: Thu, 20 May 1999 18:03:19 EDT
From: "Lakdawala, M" M_Lakdawala@csx.com
Subject: RE: Archiving data in PA/GL/FA....
There is UK based company in Archiving, I am providing their web address
check with them. hhttp://www.bitbybit.co.uk
Currently for my client I am talking to them, so please keep me posted about
the developments.
Thanks & Regards
MUZAFFER LAKDAWALA
E-mail M_lakdawala@csx.com
From: "Mark Smith" mark.smith@pdg-consulting.com
Subject: RE: Archiving data in PA/GL/FA....
Bit by Bit International have developed a tool that will archive from all
Oracle Applications tables. Their web site is at hhttp://www.bitbybit.co.uk
,
although I do not think they have any information on the site (but their
contact details are there !)
Hope this helps.
Mark Smith
PDG Consulting Ltd
5 St. Johns Lane
London
EC1M 4BH
Tel: 0171-250-4736
Fax: 0171-250-4737
http://www.pdg-consulting.com
From: FATIHB@turktraktor.com.tr
Subject: Archiving Data
As one of the biggest Tractor Manufacturers in Europe we have been live for
10 months. The main modules are INV, WIP, COST, MRP, PUR, BOM, ENG. The
database we use also has been growing extremely fast. It was 12GB at the
beginning but now its 20GB although I regularly delete as much transaction
data as I can. If there is some experience on this subject I would be
grateful to hear.
Thank you.
From: Jpkozicki@aol.com
Subject: Re: Archiving Data
I would be very careful about archiving Oracle applications data outside the
archive and purge capabilities delivered within each application. The major
risk of using outside archive and purge programs is the possibility of
invalidating your support aggreement with Oracle. In addition, the integrated
nature of the applications means that certain shared data between
applications must be maintained - you must archive/purge transactional data,
not setup data.
You should also be aware that the internal relational integrity of the
application data is not perfect and even with the technical reference manuals
in front of you, you may miss some key relationship that is not obvious or
even documented. You should expect to spend considerable time testing your
process in a Test or Development environment (not production).
You may be interested in contacting a company named "Kernel Tweaks",
headquartered in London, that markets a product that proports to handle
archive and purge of Oracle tables. You will need to write the SQL scripts,
but the product handles some of the administrative tasks required by backup
and purge.
Good Luck!
Julian Kozicki
Independent Consultant
Atlanta GA
Sent: Thursday, May 13, 1999 1:32 PM
Subject: Differentiating Production vs. Test Applets
Hi everybody,
Our company is running Payables and GL 11.0.1 on HP-UX 11.0. Some of
our users have access to both a test and a production environment from
their desktop, with the possibility of having both open at once. I'm
looking for a way to make it easy for the users to distinguish whether a
given applet window is production or test. Has anybody come across
something that could help me? Changing the background window colour
would be ideal, but I'd settle for a description or label somewhere on
the window. Right now, windows from both environments look exactly the
same.
Alan Hyland
Systems Programmer
SAAN Stores Ltd.
Sent: Thursday, May 13, 1999 12:27 PM
Subject: RE: Differentiating Production vs. Test Applets
Alan, go in the system profile(log in as sysadmin) and set the site value
TEST in test instance and set production in production instance.
I hope this helps.
if you have still questions let me know.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
From: skirby@bco.com
Subject: RE: Differentiating Production vs. Test Applets
Here is the pseudo code to set-up background colors...
You need to write a package to pull the instance name from the v$parameters
table. Have a When-New-Form-Instance trigger set in the CUSTOM.pll and set
the Form Background Color property to whatever you'd like.
Steve Kirby
skirby@bco.com
on 05/14/99 11:47:12 AM
cc: (bcc: Srini Chavali/Corp/Cummins)
Subject: Return Code and Concurrent Manager
Hello.
Our site is currently facing a difficult problem. Whenever a shell program
in Unix is launched through the Oracle Concurrent Manager, it stays in a
"Running" state, should an error occur (any return code other then 0), the
Concurrent manager never completes. It stays in a Running state until it's
killed, even though the request log shows that the process completed with
specificed error code.
thanks
Keith Lewis
SIEMENS BUILDING TECHNOLOGIES: Landis Division
1000 Deerfield Parkway
Buffalogrove Illinois 60089
(847) 215-1050 x5897 mailto:Keith.Lewis@us.landisstaefa.com
(847) 419-3494 Faxing
From: "Srini Chavali" Srini_Chavali@notesbridge.cummins.com
Subject: Re: Return Code and Concurrent Manager
Keith,
This is a known bug. Patch 442824 is available as a fix. Worked great for
us !
Srini Chavali
Oracle DBA
Cummins Engine Co
Sent: Tuesday, May 11, 1999 11:10 AM
Subject: Concurrent job visibility issue
Folks,
Apps - 10.7 Prod 16.1 SC
RDBMS - 7.3.4.3
Server - Digital Alpha, running Digital Unix 4.0e
Proposal -
For running production "batch" jobs, we are planning to create a "BATCH"
Apps GUI user with all the necessary responsibilities to run the
concurrent
jobs (both standard and customized). Ths jobs will be kicked off by
Platinum's Autosys job scheduler software utilizing the Oracle Adapter.
This software will initiate the batch jobs logged in as the "BATCH" GUI
user. The responsibilities assigned to this BATCH user will only be
given
to a few real live Apps users for troubleshooting purposes. This is
being
done to gain better control over job scheduling.
Issue -
Using this approach limits the visibility of the jobs run by the BATCH
user
to only those real live users who have the same responsibilities as the
BATCH user. How can we allow a normal John Doe user to be able to track
the
status of the jobs run by the BATCH user without giving the same
responsibilities to the John Doe user ??
I'd appreciate any thoughts on how other sites are scheduling and
controlling production jobs.
Thanks much !
Srini Chavali
Oracle DBA
Cummins Engine Co
Cc: oracledba@themailinglist.net
Sent: Tuesday, May 11, 1999 2:17 PM
Subject: Re: Concurrent job visibility issue
There is an Output Management solution for the Oracle environment. This
solution manages all phases of the Information Lifecycle (creation,
notification, distribution, use, retention and re-use) within one fully
integrated suite of software products. We believe that this approach fills
the gap that exists today in client-server enterprises in the area of
traditional Systems and Output management disciplines.
Redwood America offers the industry an Oracle-based solution for systems
management of the client server environment. Redwood4 provides Output
Management, Load Balancing and Job Scheduling. While our solution's
repository requires Oracle, we can manage any NT, UNIX or OpenVMS
environment. We are certified for BaaN4, SAP R/3 and Oracle Apps. We offer
Windows, Web or PL/SQL client interfaces.
Your user community can get the reports they desire through our
publish/subscribe capability. Please take a moment to visit our web site
small>www.redwoodsw.com to see our latest news and/or to download our product. In
summary, Redwood not only offers one of the best job-scheduling systems on
the market but also includes, at no additional cost, a robust output
management system. Together they form a winning combination in a
client-server-deployed enterprise.
Steve Farley, Redwood America Inc., 1400 Morris Drive, Suite 203, Wayne, PA
19087
610.722.5185 p 610.722.5186 f sfarley@us.redwoodsw.com
Sent: Wednesday, May 19, 1999 11:52 AM
Subject: Gen: Change passwords database/application
We have a new dba and he would like to change the
passwords for users gl/gl,
ap/ap, fa/fa, ar/ar, apps/apps etc.. In experiments
on our test database, he
had problems with the application not working
properly after he made the
changes and he was forced to change them back. These
passwords must be
changed at the application level as well as the
database level. What we are
not sure of is what the order of change should be or
if they both need to be
changed at the same time. If anyone would like to
enlighten us on this
process or tell me which manual to look in for the
information, I would
appreciate this. Thanks.
990-9177
br>
Look in the archives of this list, you will find
plenty of mails which list
each steps in details on how to go about it. You
can also find a white
paper at oracle meta link site.
Thanks & Regards
MUZAFFER LAKDAWALA
E-mail M_lakdawala@csx.com
mailto:M_lakdawala@csx.com
Web http://members.xoom.com/muzaffar/
Phone 904.366.4720
Date May 20, 1999 8:58 AM
From: Carlos Jimenez cjimenezinc@yahoo.com
Subject: RE: Change passwords database/application
Tony:
Here is the simple way to do it, I worked on this
changes for many years, it won't hurt to get the
white paper either.
1. Log in the applications under system admin
get to the \ Navigage Security Oracle Register.
2. query FND and APPS (other names use could be
APPLSYS, APPS_FND, etc) after the account what
owns all the FND tables and the applications
change both passwords to be exact the same
passwords for both of them at the same time.
Then requery the form. DO NOT LOG OFF.
3. In another connection get into sqlplus (same
database of course) and alter user FND identified
with new password; do the same for APPS_FND.
4. From the same session where you connected to
sqlplus exit and try to log on to foundation
(found) if your are able to connect and query
anything your passwords changes worked for
these two.
5. Now you can go and change all other
accounts and also change them on sqlplus too.
Note: the most difficult ones are the first two to
to change and these are the one could lock
you out of your applications.
Hope this help.
Regards, Carlos R. Jimenez. Sr. Oracle DBA.
From: Joe.Madden@sentrol.com (Joe Madden)
Subject: APPS/APPLSYS password - dont forget scripts
Folks,
I have come to appreciate this list in the short time that I have been an
Oracle Apps DBA -
We have finally gotten serious about security around here and decided it was
time to change the APPS/APPLSYS passwords. So between this list, 'dougs'
archive, and oracle application manual, I ALMOST got through it with no
pain.
The caveat was to edit my concurrent manager shutdown and startup scripts
with the NEW passwords - I found out very early this morning that needed to
be done ;-)
I assume all those who have contributed on this topic knew that without
stating - I thought I would add this for those like me who didn't.
The steps I took were:
1. Set database environment to point to production - open two screens, one
for oracle and one for applmgr:
2. Start character oracle application with sysadmin account and 'System
Adminsitration' responsibility:
found
sysadmin/password
System Adminstrator - Responsibilities
\nsor - Navigate Security ORACLE Register - returns no values in column
\qr - Query Run - returns all accounts
3. Change the passwords for APP and APPLSYS:
Hit 'down' arrow key to get to APPLSYS - tab over once (should be in
PASSWORD column)
enter password then tab
enter password then tab - this will present a pop-up error screen - hit
return for 'NO'
Repeat the same process for APPS
4. Start sqlplus session with DBA account and change the oracle level
passwords for APPS and APPLSYS so they are exactly the same as the Oracle
Application passwords:
sqlplus joem
joem_password
alter user apps identified by password;
alter user applsys identified by password;
commit;
5. Commit changes made in Oracle Application screen:
\ss - Screen Save to commit the changes - a message at the bottom of the
screen should appear stating 2 rows have been altered.
6. Open a third screen, leaving the first two completely intact
(IMPORTANT!!: Do NOT log out of the initial oracle application session until
this process is complete)
found
sysadmin/password
System Adminstrator - Responsibilities
If you get to the splash screen - then everything worked
\ncma - Navigate Concurrent Manager Administer
\qr - Query Run - returns all the concurrent managers - things should look
'normal'
\ed - Exit Discard - quits the application
7. Edit shutdown and startup scripts in cron - test that these work - done.
I did have one question, do you folks shutdown the concurrent managers while
doing this??
Regards
Joe Madden
DBA
SLC Technologies
PH: (503)691-7496
From: Hilary Soloff Hilary.Soloff@santos.com.au
Subject: Re: APPS/APPLSYS password - dont forget scripts
Joe,
We always shutdown the concurrent managers when changing the APPS/APPLSYS
password.
Also, we arrange for no-one to be using the system as well.
Regards,
Hilary Soloff
DBA
Santos Ltd
From: "Ballen, Henry I" Henry.I.Ballen@ceridian.com
Subject: AOL: FND 10.7 Patchset C server-side(774541)
After applying this patch, aiap and aiad executables create tma.log file in
the current directory which displays all key strokes including passwords.
Is it a bug or a new feature?
Regards,
Henry Ballen
From: RBoren7458@aol.com
Subject: Re: AOL: FND 10.7 Patchset C server-side(774541)
This is fixed with patch 879385