Can Reports 2.5 and 6.0 coexist ?
Date: Wed, 4 Aug 1999 14:29:52 +1200
From: Nicolas Woollaston NWoollaston@swichtec.co.nz
Subject: Reports 2.5 vs 3 vs 6 on NT server
We are running 10.7SC on NT. We are interested in whether we can develop
customisations in Reports version 6 and get them to run alongside the
standard Apps version 2.5 reports under the concurrent managers.
Is anyone out there running two versions of the Reports runtime on the same
NT box?
Did you have any hassles getting the concurrent managers to distinguish
between the two?
Do they conflict in any way in terms of files, executables, DLLs, registry
entries, etc?
Nicolas Woollaston
Analyst Programmer
Swichtec Power Systems
New Zealand
How to get Reports output through email
From: Rahul Gandhi [mailto:rggroups@hotmail.com]
Sent: Wednesday, August 04, 1999 3:26 PM
Subject: Sending Report Output thr' email?
Hi
We have Ora Apps 11.0.3 installed. We want to send the output of a
report (
concurrent request ) to certain users through e-mail.
Any clues..how it can be done?
Thanks
Rahul
Date: Thu, 5 Aug 1999 13:16:20 -0400
From: Larry Kautz LKautz@civacon.com
Subject: RE: Sending Report Output thr' email?
Oracle can do this by taking advantage of workflow. In your completion
options, Just put the Oracle user name in the notify box. Set up the
workflow mailer so it will mail notifications. The only downside is that
this actually passes a hyper-link back to the Web apps. You need to be
able to connect to the server to read the report.
Hope this helps,
Larry
Date: Thu, 5 Aug 1999 14:55:29 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
Subject: RE: Sending Report Output thr' email?
Something in the order of this should work. You get the idea.
1. Define printer styles
2. Define a printer driver to call script in the
arguments field:
$ZZ_TOP/bin/email.sh $PROFILES$.FILENAME
$PROFILES$.USERNAME $PROFILES$.TITLE
3. Assign printer to the print styles and the driver
4. Register the e-mail printer
5. Default your report use the e-mail printer
# Example script email.sh
#!/bin/ksh
email_addr=$2@myworldmail.com
mailx -s "$3" $email_addr $1
exit 0
$1 is $PROFILE$.FILENAME
$2 is $PROFILES$.USERNAME
$3 is $PROFILES$.TITLE
Date: Tue, 10 Aug 1999 10:17:01 PDT
From: "Rahul Gandhi" rggroups@hotmail.com
Subject: RE: Sending Report Output thr' email?
Hi, thanks for your suggestion.
I tried the stuff. BUt my report is erroring out with the error
REP-1804 - Unable to open printer definition file '$FND_TOP/reports/EM'
I have actually created the email.sh file in our application $XXX_TOP/bin
directory.
Any suggestion..? Why it must be looking at $FND_TOP/reports/.. instead of
looking at $XXX_TOP/bin ?
Rahul
Date: Tue, 10 Aug 1999 14:24:35 -0700
From: sagarwal@guthy-renker.com
Subject: Re[2]: Sending Report Output thr' email?
Hi ALL
I tried the same thing and created the test.sh for email.sh but having
following problem :
---------------------------------------------
Printing output file.
Request ID : 922666
Number of copies : 1
Printer : test
/p08/applr11/fnd/11.0.28/bin/test.sh[2]: SAGARWAL: Cannot find or open
the file.
APP-00500: AFPPRN received a return code of failure from routine
FDUPRN. Cannot
write to the communication channel
Cause: AFPPRN received a return code of failure from the OSD routine
FDUPRN. Ca
nnot write to the communication channel.
Action: Review your concurrent request log file for more detailed
information.
Finished executing request completion options.
----------------------------------------------------------
I checked everything and ran the file test.sh from command prompt and
it wroks. Only if I submit from apps I get this error in log. I am
using a printer which does not exist but defined in apps.
Any help would be greatly appreciated.
Sanjay
Date: Tue, 10 Aug 1999 22:54:25 -0400
From: "Chadda, Alok" achadda@kpmg.com
To: "'rggroups@hotmail.com'" rggroups@hotmail.com
Subject: RE:Sending Report Output thr' email?
Rahul -
Go to my Oracle Application site at following address,
http://www.geocities.com/SiliconValley/Network/9828/index.html
I have explained two methods to send the output of a report through email.
You can modify the C program to forward the output to a particular user
based on your logic.
HTH
Alok
View Reports on Web
Date: Thu, 5 Aug 1999 11:03:13 -0700 (PDT)
From: Vidhu vidhug@yahoo.com
Subject: Reports on web
hi
We are on Apps 11.0.200. I want to open the
customized reports in netscape. That is when we view
the output in the special tool bar we have an option
called copy file, which will enable you to view in net
when you set the path.
Anyone has any clue how to implement this in
customized reports.
ur help is very much appreciated.
Thank you in advance
Date: Fri, 6 Aug 1999 05:45:44 -0700 (PDT)
From: Vidhu vidhug@yahoo.com
Subject: RE: Reports on web
hi
Bharat i called oracle corp and found out that the it
has been fixed in version 11.0.5. They have a patch
for this. I am going to get that patch applied to day.
If it works will let you know
bye
Date: Fri, 6 Aug 1999 10:32:32 -0700 (PDT)
From: Vidhu vidhug@yahoo.com
Subject: RE: Reports on web
hi bharat
we are on NT. The patch number is 770147.
Date: Sat, 7 Aug 1999 00:04:57 -0700
From: atuls@sysao.com (Atul Shah)
Subject: Re: Reports on web
Guys,
I am not sure whether this helps, but there are a couple of profile options
which allow all standard reports to be viewed via a browser (specifically :
Viewer: TEXT). If you enter a value of browser, reports will be visible
using your default browser.
You will also have to ensure your web listener is working correctly, as
there is another profile option which needs to be set : Application Web
Agent (value for this should be your web listener).
I suspect if you have copy file working your application web agent profile
is correctly set, change the other profile option and you should be okay for
viewing standard reports.
I am not sure about customised reports, but I would guess that when
registering them in Concurrent Manager Program there is an option called
format, which I guess refers to report output format. Options are :
Postscript, PDF, HTML and TEXT. I would try setting this to text, as this
works and will be supported by most printer drivers.
Atul
Date: Sat, 7 Aug 1999 10:31:34 -0700 (PDT)
From: Vidhu vidhug@yahoo.com
Subject: Re: Reports on web
hi atul
in concurrent program define i got only the
following options for the output type
PDF,HTML,Text,Postscript.
If i have it checked as html i can see it in browser
but while printing it gives me an document which has
html tage in it.
Oracle support services said the ouput file type
should be TEXT. I dont have this option while defining
my concurrent program.I am not sure if i can go and
update the fnd_concurrent_programs table using SQL.
Thanks
Report Templates
Date: Thu, 5 Aug 1999 16:34:59 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: GEN: Report template or standards
We are planning to develop some custom reports using Reports 2.5. Is
there a template one should use when adding custom reports to Oracle
Applications? Failing that, is there a set of standards or
recommendations for custom reports? Finally, is there a set of
instructions for installing custom reports?
Thanks in advance.
Viewing a Report Online very slow
Date: Mon, 9 Aug 1999 05:44:29 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: 10.7SC REQUEST LOG
We are on 10.7SC 16.1 on a Unix platform and are
experiencing extremely slow response time when trying
to view a report online. Ie: HELPVIEW MY REQUEST
REPORT.
It takes a mininum of 25 seconds to open the report
sometimes as much as 45. IS THIS NORMAL?? We use
233MHZ Pentinum II for desktop machine with 80 megs
RAM.
All other functions of the application seem to operate
at an acceptable speed.
If this is not normal, can some recommend some
parameters for tweaking??
Thanks
Date: Mon, 9 Aug 1999 19:30:29 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
Subject: Re: 10.7SC REQUEST LOG
How many records in your
FND_CONCURRENT_REQUESTS table.
Regards,
K Gopalakrishnan
Database Administrator
GE Medical Systems Limited,
X Ray (South Asia) Pune-INDIA
Pin:411014 Ph # +91 20 6688693 /4
Date: Mon, 09 Aug 1999 17:23:11 +0300
From: "Nasir Valiya Veetil" vnasir@england.com
Subject: Re: 10.7SC REQUEST LOG
Opening a report from the client is slow if you are using MS Word or any
Memory hungry word processor as your default editor. If speed performance is
your priority you may change your default editor to Notepad or any other
light editor.
You can change your editor from profile option. Check for editor in the
profile setup.
Nasir V
Date: Mon, 9 Aug 1999 08:43:10 -0700 (PDT)
From: fierosrcul@yahoo.com
Subject: Re: 10.7SC REQUEST LOG
On the production server there are 35000 records but
on the TEST server there are only 157. Both servers
are equally slow.
Date: Mon, 9 Aug 1999 21:29:05 +0530
From: "GopalaKrishnan K" gopalak@wiproge.med.ge.com
Subject: Re: 10.7SC REQUEST LOG
Hi !
This may be a problem !
You have to clear records in your FND_CONCURRENT_REQUESTS
table. I normally won't keep records which are more than one week old.
run a concurrent request to clean up the concurrent records in the
table.( This will also add one record)
You have to run purge concrrent request concurrent program
Regards,
K Gopalakrishnan
Database Administrator
GE Medical Systems Limited,
X Ray (South Asia) Pune-INDIA
Pin:411014 Ph # +91 20 6688693 /4
Template for creating custom reports
Date: Mon, 9 Aug 1999 22:36:39 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: GEN: Report template or standards
We are planning to develop some custom reports using Reports 2.5. Is
there a template one should use when adding custom reports to Oracle
Applications? Failing that, is there a set of standards or
recommendations for custom reports? Finally, is there a set of
instructions for installing custom reports?
Thanks in advance.
Postscript - reports
Date: Tue, 10 Aug 1999 12:46:18 -0500
From: Dan Olson dolson@dacotah.com
Subject: Reports - Postscript
Help,
Is anyone on this listserver using postscript on a Digital Unix
server? I am unable to find an enscript executable. I didn't have any
luck talking to Compaq support, they seem to think I don't need it, but
I can't see any way around using it.
I am not having any problem printing postscript files, I just can't
print any reports from Oracle Applications to the postscript printer.
Thanks
Dan Olson
Date: Tue, 10 Aug 1999 19:14:38 -0400
From: Sudershan virdi virdi@interlog.com
Subject: Re: Reports - Postscript
Have you created a postscript unix queue for the printer and included the
printer in $ORACLE_HOME/guicommon/tk21/admin/uiprint.txt.
We have postscript purchase orders being printed from application withot
enscript on HPUX10.20.
Sudershan
Date: Wed, 11 Aug 1999 20:50:01 MYT-8
From: philip@aleytys.pc.my
To: Dan Olson dolson@dacotah.com, oraapps-l@cpa.qc.ca
Subject: Re: Reports - Postscript
You could try searching the net for a GNU utility called a2ps (ascii to
postscript). Compile/install and subsitute for enscript. Parameters and
option switches are different of course.
Here is what I did for character mode reports on a Solaris platform (this
comes with the postprint utility similar to enscript and a2ps)
I wrote a shell wrapper script called fndpsprint and used that as the
command to use in the define printer driver form. e.g.
------------------------------------------------------------------------
Printer Driver
Name LANDSCAPE_PS
User Name Landscape for Postscript
Description Landscape for Postscript Printers
Platform
SRW Driver PSL
Driver Method Command
Spool File No
Standard Input No
Program Name
Arguments fndpsprint -d$PROFILES$.PRINTER -n$PROFILES$.CONC_COPIES
-t"$PROFILES$.TITLE" -sLANDSCAPE $PROFILES$.FILENAME
Initialization
Reset
------------------------------------------------------------------------
Here is the fndpsprint wrapper script. I stole it from the 9.4 shell
script used to control printing.
Date: Wed, 11 Aug 1999 10:42:23 -0500
From: Dan Olson dolson@dacotah.com
Subject: Re: Reports - Postscript
Yes -I have modified the uiprint.txt to include a postscript unix
queue. However I am using the default.ppd since this is a Lexmark
printer and I do not have a Lexmark specific ppd. I have tried the a
couple of other ppd files and have not had any different results.
On your postscript purchase orders - are you running them to a print
driver that just includes the lpr or lp command?
Date: Wed, 11 Aug 1999 20:16:25 -0400
From: Sudershan virdi virdi@interlog.com
Subject: Re: Reports - Postscript
we are using lp.
there is a bitmap report in the
$ORACLE_HOME/reports25/demo/bitmap/graphics.rdf
which you can compile using r25runb not r25run.
send the output to the postscript printer to verify that everything is okay
at this layer and then start working on these steps( you must have already
played with half of them, setting up bitmap reports is always tricky)
1) Verify that the following environment variables are correctly defined:
$APPLORB (this should be set to ar20runb or ar25runb depending on the
version of Oracle*Reports that you have installed)
$APPLORC (this should be set to ar20run or ar25run depending on the
version of Oracle*Reports that you have installed)
$LPDEST=valid printer name
$PRINTER=valid printer name
(where valid printer name should be replaced by the name of a
postscript
printer that you have on this machine).
2) Create a printer driver within Oracle Applications and ensure that the
'Initialization' and 'Reset' fields are blank (you do not need to send
printer escape codes if you are using postscript).
3) Ensure that the bitmap report that you wish to run has the following in
the 'Execution Options' field:
VERSION=2.0b (this should be set to 2.0b if you using Reports 2 or
Reports 2.5).
4) You also need to create a new 'print style' to enable you to attach
your
new printer driver to a 'printer type'.
5) You need to specify your printer name and printer resource file in the
uiprint.txt file (used by Oracle*Reports for Postscript printing):
cd $ORACLE_HOME/guicommon2/tk23/admin
(you may need to navigate to the tk21 directory, but this will depend
on
the toolkit version that you are using in Oracle*Reports:
to find out which toolkit version Oracle*Reports is using:
Enter: r20run or r25run (if you get the message 'r20run: not found'
after
entering r20run then use r25run instead)
Choose: 'Help, About Oracle Reports' the toolkit version for Oracle
Toolkit 2 should then appear near the bottom of the screen, if it is
2.1...
then you need to navigate to the $ORACLE_HOME/guicommon2/tk21/admin
directory, otherwise you should navigate to the
$ORACLE_HOME/guicommon2/tk23/admin directory.
Add a row to the uiprint.txt file to specify your postscript printer
name
and the name of the printer resource file to use (the resource files
are
located in the directory below named PPD). e.g. If you are using an
HP Laserjet 4 printer then you may choose to use the hpljet41.ppd
resource
file.
6) You need to shutdown and restart the concurrent manager after having
made
the necessary changes, as the printer information is cached.
Sudershan
Assign Sequence Nos. in a report - restarting when a new group starts
Date: Wed, 11 Aug 1999 16:51:01 -0400 (EDT)
From: Siva Shanmugham CMCISRS@NJTRANSIT.STATE.NJ.US
Subject: Reports Question
Hi Reports Gurus,
I have a requirement to assign sequence numbers while generating a report
output.
I have a master detail report where I need serial number for the detail
records. 1, 2,....
The serial number should restart when a new group starts.
Has any one done this before ? Is there any standard feature available?
If not, any ideas on how to go about it?
Thanks in advance
siva
Date: Wed, 11 Aug 1999 16:25:32 -0500
From: Dewoolkar Mandar-G1606C G1606C@email.mot.com
Subject: RE: Reports Question
Try selecting rownum in the same query...
-- Mandar
Date: Wed, 11 Aug 1999 17:35:49 -0400
From: Ramesh Gade ramesh.gade@Yale.Edu
Subject: Re: Reports Question
Siva,
1) In your datamodel, create a summary column in your detail group
with function: count
source : one of the columns in your detail group
reset at: the master group
2) In your layout, create a field(for the sequence no.) in your detail
repeating frame and
source this field to your summary column.
HTH,
Thanks,
Ramesh Gade.
Tables referred in the Invoice Print Report
Date: Wed, 11 Aug 1999 15:32:05 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: Invoice Print report query questions ( RAXINV.rdf)
I am looking for the value of a.invoice_currence_code coming from which
table in Q_invoice query.
As it didn't mentioned the A table in from clause.j
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Wed, 11 Aug 1999 17:19:58 -0500
From: "Vikram Reddy" Vikram_Reddy@intervoice.com
Subject: Re: Invoice Print report query questions ( RAXINV.rdf)
'A' is an alias for ra_customer_trx table.
Look in Initial Value field of
p_table1(User Parameter ) property sheet.
Cheers
Vikram.