Initial Signon screen
Also refer : Differentiating Production vs. Test Applets
Date: Sat, 12 Jun 1999 16:54:22 +0530
From: GopalaKrishnan K gopalak@wiproge.med.ge.com
Subject: Initial Signon screen
Hi Apps DBAs
I would like to diffrenciate the screens in TEST
and PROD instances. The initial sign on screen also
should be differenttt.
Is there any way i can do it in site level
Cheers!
Gopalakrishnan K
Date: Sun, 13 Jun 1999 09:11:31 +0200
From: "Sjoquist, Randy (AFIS)" Randy.Sjoquist@fao.org
Subject: RE: Initial Signon screen
Are you operating SC or NCA?
SC: Search the server for logo.gif. You will likely find it in a few
places, including patches etc. Note: The replacement must be the same
dimensions.
NCA: The file you need to locate is applscore. Unzip the file. The
logo.gif file is located within this file. This file is either found on the
server or locally on each PC. At the PC level, you need to change it on all
PC's. Likely your signon updates can perform this. If on the server,
search, ftp down, change and ftp back. Note: If on the local PC, you will
need to add some code to the logo.gif file so that it displays the instance
name, otherwise all instances will look the same. If on server, likely PROD
server is distinct from other servers. There you can simply change the PROD
server and then change the others to either show the same screen or add some
code to the gif as previously mentioned.
The file is found on the local PC for performance reasons. There is a DBA
setting that determines. While the JDK is supposed to refresh itself on the
PC, I have not figured out how to do this.
Good luck.
Randy
Date: Sun, 13 Jun 1999 08:33:27 -0400
From: "Scott Frost" sfrost@noblestar.com
Subject: Re: Initial Signon screen
I believe it is LOGO.TIF not LOGO.GIF
To save on bandwidth speed, also be sure to perorm LZW compression in your
image processing package on your new TIF file. For a cool way to glitz up
the applications at the end of an implementation, create a new logo that
will represent the name of the new system for an enterprise, this splash
screen will help give it more buy in from users.
Also if you are accessing the same forms directory for SC and two separate
database instances, because the forms are only copied once, you will not be
able to discern between the two instances (because there is only one copy of
the forms and you have only replaced 1 LOGO.TIF file, not two)
If you have two copies of the forms loaded, then this should not be a
problem.
Hope this helps...
Scott
Scott Frost
Noblestar Systems Corporation
703.464.400 x2549
JDK Error
"Raman, Binoy" braman@usa.capgemini.com 06/11/99 03:31PM
Hi,
We are running Rel 11.0.2, using Netscape 4.5
I installed the Oracle ODBC driver 73 available on the web page. After
this,
when I try to
run the application, I get an error :
Oracle JInitaitor 1.1.5.21 Fatal Error
The JDK virtual machine was never installed and is not defined in the PATH
...
Could not load the plug-in....for the MIME type
application/x-jinit;version=1.1.5.21.1
Make sure enough memory is available and that the plug-in is installed
correctly.
This was working properly before I installed the ODBC, I uninstalled the
ODBC driver, still no change.
I tried it with IE 4.0, somehow it cannot load the ActiveX with the
security
set the way it is.
Does anyone have a work around to this ?????
Thanks,
Binoy.
Date: Mon, 14 Jun 1999 10:07:18 -0400
From: "Mujahid Siddeeque" MSiddeeq@smtp-gw.lsuc2.lsuc.on.ca
To: oraapps-l@cpa.qc.ca, braman@usa.capgemini.com
Subject: Re: GEN:JDK Error
Hi Raman,
We also got same error, but now it resolved by installing
Netscape 4.06. As rel 11.0.2 is compitable with 4.06 and run it, hope it
works for you.
Thanks
Mujahid Siddeeque
System Analyst
Law Society Of Upper Canada
MSiddeeq@lsuc.on.ca
Running a package from Apps
Date: Mon, 14 Jun 1999 07:47:35 -0500
From: KNarayan@micro.honeywell.com (Narayanan, Krishna)
Subject: help in running a package as a report se
hai everybody,
Iam pretty new to Oracle Applications. I have a requirement in which i have
written a backend package. I have to execute this package from the Oracle
Applications. For this purpose i have created a report set in the
Applications. Since i have to run other procedures and also a report after
completing this i have created a report set. Now the problem Iam facing is
when i cancel this report set from the application its showing canceled and
terminated, but in the backend my package is executing continously without
terminating. How would i solve this problem. How would i link the Oracle
Applications and my package execution such that whenever i cancel from
Oracle Application it should aoutomatically terminate the execution of my
package in the backend also.
I also have a doubt whenever we are calling a package or procedure from the
Oracle Application as a report then we have to use two OUT parameters by
default
1. ERRBUF OUT Varchar2
2.RETCODE OUT Number
How this parameters can be used and exactly where it can be used.
Any suggetions/solutions appreciated
Thanks in Advance
Krishna Narayanan
Date: Mon, 14 Jun 1999 08:57:53 PDT
From: Thaddeus Inekuku tinekuku@hotmail.com
Subject: Re:help in running a package as a report set
Hi Krishna,
1. ERRBUF OUT Varchar2
2.RETCODE OUT Number
are used to monitor the status of a procedure/function, etc within the
Oracle application. When you create your own process, you need to include
these as part of the parameters in your process declaration.
If your routine encounters an error that forces it to terminate
abnormally, then you may return '2' for RETCODE at that (exception
handling) point, else if it completes normally, set RETCODE to '0' as the
last line within the routine.
This will ensure that other routines in the report set are not executed
with the previous routine resulting in an error.
Contact me if you require further info.
Thaddeus Inekuku
AnswerThink Consulting Group
Tel:770.690.9700 ext. 3168
Client Off:203.373.3439
Pgr:888.895.9584 (National)
Date: Mon, 14 Jun 1999 13:34:47 -0500
From: KNarayan@micro.honeywell.com (Narayanan, Krishna)
Subject: help in running a package as a repor
hi Thaddeus,
Thanks for your explanation of the use of ERRBUF & RETCODE parameters and
how exactly to use it.
I have one more doubt. You have said about the error handling in the packag
e
level in the backend. My current requirement is when i go to concurrent
request summary and cancel that job/request in the Oracle Application its
saying Phase 'Completed' and status as 'Terminated' but my package is
running in the backend. How can i solve this problem. I appreciate if you
can throw me some light in solving the above problem.
Thanks in advance
Krishna Narayanan
Setting up concurrent manager for a 5 day schedule
Date: Mon, 14 Jun 1999 13:01:47 -0400
From: david.callaghan@stoneweb.com
Subject: Setting up concurrent manager for a 5 day schedule
Hi everyone,
We are using 10.7 NCA and I am trying run a job M-F every week
automatically. Currently, I have set up a concurrent manager to run M-F for
this specific job. I submitted the request to resubmit every 24 hours. I am
afraid that there will be 3 jobs sitting in the queue Monday when the Manager is
active. Any suggestions would be greatly appreciated.
Regards,
David
Date: Mon, 14 Jun 1999 12:10:51 -0500
From: "Logan, Ernie" Ernie_Logan@bmc.com
Subject: RE: Setting up concurrent manager for a 5 day schedule
David:
Schedule the job to run 24 hours from start and it won't schedule the next
until the current one starts. That should prevent your problem.
Date: Mon, 14 Jun 1999 10:17:41 -0700 (PDT)
From: Chris Taylor cwt_cfa@yahoo.com
Subject: Re: FND: Setting up concurrent manager for a 5 day schedule
No, you should be OK. Resubmission occurs only when the concurrent
request completes. If you are targeting a specific time of day, you
may want to align your concurrent manager work shift start time with
the start time of the request, because Friday's request will be set
to start Saturday and will run immediately when the manager wakes up
on Monday, regardless of what time of day on Saturday you asked for.
Note that resubmission from "start of request" refers to actual
start, not requested start.
An alternative method: Submit 5 requests, one for each day of the
week, each resubmitting 1 week from start. Do this by altering the
requested start time fields before saving the request. No concurrent
manager trickery is required for this method.
--Chris Taylor
Date: Mon, 14 Jun 1999 16:29:43 -0500
From: Greg.Hoover@IFLYATA.COM
Subject: RE: FND: Setting up concurrent manager for a 5 day schedule
Dave,
I ran into a similar situation with one of our concurrent processes, and
here is what I came up with.
I created my process as a Host based shell program on a HPUX server.
I created a second shell script (function) that determined what day of the
week it was (e.g. Monday, Tuesday, etc).
I called the second script from the first script to get the week day, and
then tested the weekday for "Saturday" or "Sunday".
If it is Saturday or Sunday, I had the process exit with a status of 0.
If it was a weekday, it executed normally.
That's it.
Greg Hoover
Systems Engineer
American Trans Air
Date: Mon, 14 Jun 1999 21:45:13 -0700 (PDT)
From: bill billvenella@yahoo.com
Subject: RE: FND: Setting up concurrent manager for a 5 day schedule
I do not know if you have put any thought into 3rd
party tools. There is one that would resolve this
quickly and also help to automate / manage the
processing environment. Take a look :
http://www.appworx.com/
regards,
bv
Oracle Appl logo not appearing
Date: Tue, 15 Jun 1999 15:06:44 +0100
From: Nukul Dinkar nsd18102@trishul.icil.co.in
Subject: Unable to get the Oracle Applications logo on rel 11 Win NT 4.0
Hi,
I have completed the installation of Rel 11 Vision Database on Win NT
4.0 with service pack 4.
I am getting the Sign on screen without the Oracle Apps logo. I could
login as Sysadm and do various tasks . The Apps is functional . I am
using Appletviewer(jdk 115) available with the Interoperatibilty CD to
connect to APPS.The html file used is copied from afsamples.html
available with Rel 11.
Can somebody help to solve this problem.
Thanks in anticipation,
Nukul
Date: Tue, 15 Jun 1999 14:44:31 +0530
From: manoj_bhatnagar/Polaris@polaris.co.in
Subject: Re: Unable to get the Oracle Applications logo on rel 11 Win NT 4
Hi
According to my experience there can be two reasons to this problem :-
1. The LOGO.TIF file is not available in \APPSxx\fnd75\res directory in
SERVER. where
xx is the version number.
2. You don't have Windows Explorer mapping on the drive where this file
exists. Try to map
that drive where the file exists.
Manoj
Company Logo on Sign-on Screen
Date: Tue, 15 Jun 1999 09:01:38 -0700
From: Kumar Subramaniam kumar.subramaniam@sanmina.com
Subject: Company Logo on Sign-on Screen
Hi,
Can anyone help me on how to display the company name & logo instead of
Oracle Applications.
Thanks,
Kumar
Date: Tue, 15 Jun 1999 12:12:25 -0400
From: "Scott L. Frost" sfrost@noblestar.com
Subject: Re: Company Logo on Sign-on Screen
You need to locate the LOGO.TIF file in the directories where your forms are
located. You can modify this using Photoshop, but you must save it as a
.TIF file and you can also perform LZW Compression on it to save space and
time.
Good luck!
Scott
Date: Wed, 16 Jun 1999 06:46:37 +0200
From: "Sjoquist, Randy (AFIS)" Randy.Sjoquist@fao.org
Subject: RE: Company Logo on Sign-on Screen
Logo.TIF. I suspect that this applies to SC only, yes?
If your on NCA, I think that the file you want is Logo.gif which is found
within applscore.jar which contains logo.gif (unzip it). Applscore.jar is
found both at the local (PC) or on the server. Depending on the system
settings, better performance if local, will determine which place to make
the change.
Randy
I.E browser windows blinking
Date: Tue, 8 Jun 1999 10:03:26 -0400
From: VadrevSu@MS.NDCORP.COM
Subject: I.E browser windows blinking
We implemented 11.0.2 Development database on sun solaris.
There are 50% netscape browser users and 50% I.E browser users.
Everything is working fine with netscape.But, when somebody
access the apps through I.E 4 or I.E 5, the application windows are
blinking and doing disco on monitor. I saw that afsampled.htm
where the browser value is hard coded with 'Netscape'.
How can I configure the I.E client properly ?
Thanks
vas
From: Wan, Kevin [mailto:Kevin.Wan@bactc.com]
Sent: Tuesday, June 15, 1999 12:36 PM
To: Vadrevu, Subba # NDCHQ
Subject: FW: I.E Browser windows blinking
We have the same problem with IE (regardless IE4 or IE5), some forms do not
display properly with missing action buttons, and doing the disco thing too.
Have you gotten better luck?
Date: Tue, 15 Jun 1999 12:47:42 -0400
From: VadrevSu@MS.NDCORP.COM
To: Kevin.Wan@bactc.com
Subject: RE: I.E Browser windows blinking
Hi wan,
1) Download and Install jinitiator from
www.oracle.com/tools/dev_server/dn.html
(jinit115211.exe) on the client side.
2) download patch no.790123 from the oracle ftp site (contains two html
sample
files with two sections both for I.E and netscape)
3) Ftp the jinit115211.exe as well as the html files to $OAH_TOP/html/US
directory.
4) Edit the dynamic/static html files as per your system configuration and
ensure
to keep your hostname:web port/OA_HTML/US/html file name in the
jinitlocation place
5) Run the html code in the I.E browser.
Subba
Application Security
Al Nass alnass@DOMINOAMJET.com Wednesday, June 09, 1999 8:31:04 AM
I have a request to give a group of users access to "View Sales Orders"
without being able to enter them, change them, etc.
In application security, this would fall under the function Orders
Workbench, in Oracle Order Entry. I know how to pick-and-choose from a
submenu, but not from a function.
Can anyone tell me how I can give users access to sales orders, but only
to
view them? We're on 11NCA.
Thanks.
alnass@dominoamjet.com
"David Keeney" keeneyd@wilsonart.com on 06/10/99 10:31:12 AM
cc: (bcc: Dominick A DiSalvo/Service Center/Hearst)
Subject: Re: Application Security
Try this:
To make a view only copy of any form, attach the same form (without any
extra programming) in the menu definition form of AOL for the INQUIRY
responsibility's sub menu with the action type "Query Form" This
definition will make the same form only viewable and prevent updation of
any database fields in the form from that responsibility. The form will
behave normally from other responsibilities.
//David Keeney
Date: Wed, 16 Jun 1999 09:07:23 -0400
From: ddisalvo@hearstsc.com
Subject: Re: Application Security
Hi David (and everyone else out there), Is this feature for 'Query Form' action
type only in release 11? In the release 10 AOL tech ref manual I see the
quickcode MENU_ACTION_TYPE defined in FND_LOOKUPS with a code 'Q' for Query
Form, but I'm not sure where you can attach it to the forms/menu. I'm wondering
if it's used in rel 10 character based version, we are on the 10.7 GUI version.
I have been using the parameter 'Query Only yes' to accomplish this on most
forms, however it doesn't seem to work on Items Setup as when the parameter is
activated, the form locks up after choosing the organization. Any help or
direction is greatly appreciated.
Thanks,
Dom
Date: Wed, 16 Jun 1999 08:19:19 -0500
From: "David Keeney" keeneyd@wilsonart.com
Subject: Re: Application Security
Hi Dom,
I can't speak for rel 11 or 10.7 GUI. We are at 10.7 char.
David Keeney
Date: Wed, 16 Jun 1999 16:18:18 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: Re: Application Security - View Sales Orders Screen
There already exists a View Sales Orders Screen. Give your menu access to the
Orders Workbench, and the subfunctions Sales Orders: View (there is also a
Returns: View) and be sure to leave out the subfunction Sales Orders: Enter.
Then they will have the Orders Workbench and the OPEN button will not even
exist only the VIEW button. It is very similar to the character \Nav, View,
Orders screen.
Try looking at Oracle's superuser menu setup with the menu OE_SALES_ORDERS_10SC
to get the idea of what to leave in and out.
To clarify the other issue, (but for View Sales Orders you dont need to do
this)
QUERY FORM is a an action type that works with any character screen. You set it
on the Menu Definition screen.
QUERY ONLY= Yes is a function parameter and works with the some *but not all *
GUI screens (SC and NCA).
If you still have trouble, send me a note and Ill email you a screen shot how
Ive set it up on this project. With Subfunctions you can get as messy or clean
as you want, as long as the function is somewhere in the menu path.
Good luck!
Amber
--------------------------------
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
Using SQL in Timed Recurring Request Sets
Date: Wed, 16 Jun 1999 11:04:05 -0600
From: Alex Waddell alex.waddell@shaw.ca
Subject: Using SQL in Timed Recurring Request Sets
I have run into a strange problem here. We are using Request Sets to run
series of nightly jobs (example: Payables Transfer to GL). Within the
Request Set we have set parameters. For some of these parameters we will use
a SQL statement to pull a date from dual and then append that to text in
order to create batch names.
We then set this request Set to run every night. The problem is that the
recurring jobs are not using the SQL from the Request Set, instead it uses
the same date (as the first day the job was set to be recurring) each time
it runs the job (consequently the jobs fails, since batch names must be
unique). Is it not possible to force resubmitted jobs to re-read the
original sql from the Request Set parameters so that it can create a new
batch name based on the new date dynamically each day?
We are on 10.7 NCA. Unix database, Solaris - middle tier.
Any suggestions?
Alex
Date: Wed, 16 Jun 1999 21:20:55 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: Using SQL in Timed Recurring Request Sets
Alex -
You have found (what I consider) one of the most annoying BUGS in the
apps. You get the same results when you use the CONSTANT TYPE=CURRENT
DATE. It will always use the date you first submitted it with.
Myself and colleagues have explored different ways around this in the
last few years, and have found you can achieve similar results with a
few other options: a shell script with concsub, a package with fnd
submit and an alert.
I prefer the alert option, it requires the least amount of setup and
code. For example, create a periodic alert that has 'select sysdate into
&rpt_date from dual' with a summary action of Concurrent Request. Choose
the report you want to run and on the parameters line list the inputs
with output &rpt_date where you would want the date to be. The input
parameters are a little tricky to get right, but list them separated
with a single space and "" representing null values (I think!).
Also, if I remember right, you cant submit a report set this way. You
will have to call each process separately in the Alert Action.
Last time I called the BUG into support was 1997, and then they said it
would be fixed in Rel 11. Id be curious to hear if it has been, but it
does not work in character, SC or NCA.
Amber
Date: Wed, 16 Jun 1999 15:07:57 -0500
From: "Uptmore, Chris" uptmorec@kci1.com
Subject: RE: Using SQL in Timed Recurring Request Sets
Amber,
Annoying? Definitely!
We wanted to run our custom Close Orders program nightly with a dynamic
END_DATE = "current date". I was sure this would work...
Before getting to [wasting more time] experimenting with different "dynamic
date submission" solutions, a colleague found that simply removing the "date
range" from the code dramatically improved the performance (down to a few
minutes).
So that annoyance was put on the "back-burner" - hopefully for good!!
ErnieL will probably tell us if "dynamic date submission" IS supported in
11, if he hasn't told us before. Anyone else?
Thanks,
Chris
Responsibilities across modules
Date: Thu, 17 Jun 1999 13:16:37 -0700
From: "Catherine Gauchat" catherine_gauchat@tcibr.com
Subject: responsibilities across modules
Hi,
I would like to create an inquiry responsibility across several
modules. Is there a way to do this or can I only access one module from
a responsibility/
Thanks,
Catherine
Date: Thu, 17 Jun 1999 16:12:57 -0400
From: Leigh-Anne McDonald Watson lwatson@timebridgetech.com
Subject: Re: responsibilities across modules
This is very "do-able". Set up a menu with multiple module inquiry's and
then assign this menu to the responsibility. Your users who login as that
responsibility will then have inquiry access to all the modules you
specified in the menu.
Good luck
L.Watson
Date: Fri, 18 Jun 1999 10:40:44 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: Re: responsibilities across modules
Catherine -
As others have pointed out this is pretty simple to accomplish, but you need to
be aware of a couple of common problems in both the character and GUI apps:
* Any responsibility and application level profile options that the original
responsibility was tied to need to be setup for the custom
application/responsibility. Without this user will receive messages like
'Cannot read value for XXXX profile option' periodically in some forms.
* Each application has its own message file that interprets form level
messages. Your custom responsibility may not be able to read messages from
other applications, and instead of displaying the actual message on the screen.
It will say 'Cannot find message 'AR_ALL_DUP_NAME' instead of displaying 'Name
already exists. Please enter unique name.' etc. There is a profile option
called Message: Shared Application you can set to solve this problem.
Hope this helps!
Amber
--------------------------------
Amber Allen-Sauer
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com