Error while viewing Reports
From: Mehmood. [SMTP:smehmoodapps@hotmail.com]
Sent: 09 June 1999 17:28
Subject: GL: Error while viewing Reports
Hi all,
I'd submitted the following query last week.
Didn't receive any feedback, maybe it was missed because of weekend.
Can annyone please help me in on this ...
*********
I'm receiving the following error when i view my report after successful
completion :
"An error occurred while attempting to establish an Application file
server
connection with the node ABC. there may be a net work configuration
problem
or the TNS listener on the node ABC may not be Running Please contact
your
system administrator".
I have checked the listener is running.v
Please note this error appears ONLY in the Demonstration Database
although
the Live application runs perfectly on the same machine.
We are on Apps 10.7 for Win'NT 4.0, SC16, Oracle RDBMS ver 7.3.4.
Also note we are running the database and client on the same machine
(ABC)
and to access the Live application we shutdown the Demo DB and vice
versa if
we want to access the Global Demo DB.
Thanks in advance.
Respectfully,
Mehmood
Date: Sat, 12 Jun 1999 12:38:07 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Error while viewing Reports
This error is indicating a problem with FNDFS. Remember that there are
two sides to a SQL*Net connection, client and server. I suspect based on
your description that there is no problem with the tnsnames.ora entry
for FNDFS_ABC so I would suggest you check the status of the listener.
The message is a fairly accurate description of your problem. Remember
that the FNDFS entry is not a normal database connection but a network
connection to run a server based executable to access the report.
So check:
Is it a different ORACLE_HOME or listener.ora for the test database
Is the entry for FNDFS_ABC correct and is the executable is the location
specified Is the listener (service?) running
Graham.
Date: Tue, 15 Jun 1999 19:34:57 GMT
From: "Mehmood." smehmoodapps@hotmail.com
Subject: RE: Error while viewing Reports
Thanks Graham.
Answers to your questions :
No, its not a different ORACLE_HOME or listener.ora for test database.
I have manually added the handle for demo db in the listener.ora file.
There is no FNDFS_ABC entry in listener.ora (neither for Live nor for Demo
db). When is this entry created ??
Yes, the listener service is running (with two handles one for Live & the
other for Demo).
Hope this will help in resolving this issue.
Respectfully,
Mehmood
Creating Bar Codes - Query 1
Date: Tue, 15 Jun 1999 11:52:48 -0500
From: Scott Close CloseS@crlcorp.com
Subject: Creating Bar Codes
Does anyone have information on how to create bar codes from Oracle
application output -- specifically, from Oracle Reports 2.5?? Any
information would be most helpful.
Thanks, much.
Scott Close
closes@crlcorp.com
Date: Tue, 15 Jun 1999 13:01:24 -0500
From: KNarayan@micro.honeywell.com (Narayanan, Krishna)
Subject: RE: Creating Bar Codes
I have created Barcode in Oracle reports 2.5 which is then attached to
Oracle Applications.
1.we should have barcode driver installed.
2. We should have prt definition file for the barcode output
3. after the report is created for the column which we require barcode
we have to set printer codes beofre and after.
i have set &001 in the before printer code and
&000 in the after printer code.
select statement for that particular column should be like the one
given below. This is also printer driver specific.
for example we want barcode for empno
then select '*'||empno||$I||$I||'*' empno from emp;
here '*' before and after marks the begining and ending of the column for =
which
we have to get the barcode. $I - is for tab
1001
empno tab tab
4.In the oracle applications in style we have to say that it has to include barcode.
Basically I have a driver which has got both barcode facility.
Date: Tue, 15 Jun 1999 11:13:41 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Creating Bar Codes
Depending on the report, it might be simpler to just write your own
report using a Windows reporting tool that has access to regular
Windows TrueType fonts. Then, you simply use the barcode
TrueType font in your report program. You need to remember the
asterisk before and after the text in order for the barcode to be
read by a scanner.
Tom Orth
torth@sequent.com
Date: Tue, 15 Jun 1999 21:57:19 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: Creating Bar Codes
Scott -
You will either need to buy a barcode font for each of the printers you
plan on printing or buy a program that you pipe your report output
through from the concurrent managers. I think its easier to do the
later.
Check out the Barcode 1 webpage at
http://www.adams1.com/pub/russadam/unix.html. From there you can
download demos of some barcode programs and give them a try.
If you dont find anything there, let me know. My partner has written a
barcode program for 3 of 9 that we are using on our current project in a
production environment and we plan on distributing it as GPL (free!).
Amber
----------------------------
Allen-Sauer Consulting, Inc.
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
Date: Tue, 15 Jun 1999 15:22:54 -0500
From: Scott Close CloseS@crlcorp.com
Subject: RE: Creating Bar Codes
Amber,
Thanks for your information. This helps a great deal.
Scott Close
Date: Fri, 18 Jun 1999 09:04:51 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: Reports 2.5 - Print Bar Codes
Scott -
Definitely Reports 2.5 can print barcodes, the question is really 'can your
printer?'. I am assuming you are attempting to print the barcode on a report
that runs through Oracle Applications concurrent manager. If so you need to
obtain either a barcode font for your printers or a barcode program to
interpret the barcode. Please see my posting (below) from a couple of days ago
on a similar question.
Once you have settled on a barcode program or font, you will need to add a line
of code to your report like this:
With a Program: [BARCODE=3of9;DATA='&f_barcode_text'] where barcode text is
the value you want to see as a barcode. The exact string depends on which
program you choose.
With a Font: input f_barcode_text PRINTER CODES PROPERTIES Before and
After strings that correspond with the .prt file escape sequences needed for
the font.
Good luck!
Amber
--------------------------------
Amber Allen-Sauer
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
Creating Bar Codes - Query 2
Date: Thu, 22 Jul 1999 07:50:54 MDT
From: "Sean Mayhew" smayhew35@hotmail.com
Subject: Adding bar codes to Oracle reports
We want to add bar codes to some Oracle shipping reports. Has anyone done
this, or know how?
Thanks in advance
Sean Mayhew
TruTek
SLC, UT
System:
HP/UX v11.0
Apps v11.02
Date: Thu, 22 Jul 1999 10:09:22 -0400 (EDT)
From: "I. Gary Landis" garylandis@yahoo.com
Subject: Re: Adding bar codes to Oracle reports
Working on this myself. Will use the following info
when I get back to my office (on the road right now).
..... info follows .....
Gary, we recently used some fonts from Azalea to do
barcodes in
Postscript mode in Reports2.5 running from unix.
We are in Apps 10.7 , Database 7.3.4, Sun Solaris 6000
check them at www.azalea.com
Also there are some documents from oracle/metalink
that you should lookover:
Note 16888.1 All you need to know about Printing on
Motif (this explanis
many things about the toolkit)and
Note 62038.1 Setting up Barcodes on Unix or Windows.
What worked for us was to install this barcode font,
then map it "helvectia"
in the uifont.ali
so then when the toolkit saw any text in "helvectia"
it used the new barcode
font.
Date: Fri, 23 Jul 1999 17:43:15 GMT
From: skondolf@frontiernet.net (Steven C. Kondolf)
Subject: Re: Adding bar codes to Oracle reports
Sean -
We're beginning to look into this also. I downloaded a sample
True-type font for Code39 from Elfring fonts
www.elfring.com which
also offers other formats as well. Once installed, they work just
like any other font thru Windows so you can use them in Oracle Reports
(we use 2.5) as well as any other application i.e. Access, Excel,
Word, etc.
For your info.
Can bitmap mode reports be registered ?
From: oraapps-l@cpa.qc.ca [mailto:oraapps-l@cpa.qc.ca]On Behalf Of
Gopalakrishnan K
Sent: Saturday, June 19, 1999 5:52 AM
Subject: Oracle Apps Report
Hi
can we register bitmap mode reports(version 2.5) in oracle
applications 11.0.2 , if yes how?
if not, is there any other way by which i can do it?
thanks in advance
Regards !
Gopalakrishnan K
Date: Sat, 19 Jun 1999 16:44:45 -0400
From: "Robert Deem" rdeem@digital.net
Cc: nburgess@us.oracle.com
Subject: RE: Oracle Apps Report
You can register it the same way you would any other report, under system
Admin, Concurrent/Program/Define. In the Executable options block, enter the
following:
Version2.0b
Also, make sure that you have a postscript capable printer and print style
selected.
Y2K Reports
Date: Fri, 18 Jun 1999 08:59:52 -0500
From: "madargi roopa" mroopa@mailcity.com
Subject: Y2K Reports!Urgent
Hi all,
I want to modify some of the reports for Y2K compilance and
i want to know steps required to solve the problem.
In parameter form editor,layout editor,pl/sql and sql coding.
If the column from the table is coming in the format dd-mon-yy
then how to do that in pl/sql and sql coding.
Thanks in advance!
roop
Date: Tue, 22 Jun 1999 01:18:38 -0700 (PDT)
From: david solomon david_solomon_uk@yahoo.com
Subject: Re: Y2K ReportS!Urgent
Roop,
You need to consider few things:
(1) What are the tools used to write the reports and are they compliant
or not.
(2) Your database and OS, are they compliant or not
You might need to upgrade some of the above. If you do not need to
upgrade then you have to start setting your Y2K strategy, inventories,
Testing, ...etc. The main thing you need to set your plan before it is
too late.
Cheers
David
Date: Tue, 22 Jun 1999 08:29:30 -0500
From: "madargi roopa" mroopa@mailcity.com
Subject: Re: Y2K ReportS!Urgent
Hi,
I want to convert the sysdate to 4 digit year format with datatype as date.
It is highly appreciable and very urgently looking for the solution.
Thanks in advance!
Thanks,
roop
Date: Tue, 22 Jun 1999 08:15:13 -0700
From: "Orth, Tom (torth)" torth@sequent.com
Subject: RE: Y2K ReportS!Urgent
A dangerous thing you can do is set the nls_date_format in your
init.ora file. You have to restart your database for this to take effect.
The default is dd-mon-yy. You can make it whatever you want.
However this can effect your applications! Perhaps a better choice
is to do an "alter session" to set you nls_date_format. Refer to
your documentation for the details.
Date: Tue, 22 Jun 1999 11:55:32 -0400
From: "Kurylo, Mary" Kuryma@consumer.org
Subject: RE: Y2K ReportS!Urgent
In 10.7 the default NLS_DATE_FORMAT should be set to DD-MON-RR. I would also
find it very unusual if it were set to DD-MON-YY in any versions after 10.7.
I would also not recommend changing the default NLS_DATE_FORMAT.
I believe that SYSDATE is stored with the correct 4-digit year and the
default display, when selected is a 2 digit year (I'm not sure about that
though, and please correct me if I'm wrong).
If you are writing a report, you can format the date as a 4-digit year in
the report. Just do
SELECT TO_CHAR(sysdate, 'DD-MON-YYYY') ....
this will display the SYSDATE as 22-JUN-1999.
Mary Kurylo
Applications Development Analyst
Consumers Union of US Inc.
Running Report from cron job
From: JANAKI ALLU janaki_oracle@hotmail.com
Subject: running report from cron job !
Date: Mon, 28 Jun 1999 12:55:55 PDT
Hey All,
as we have problem in running reports 2.5 from Unix ( needs x windows ?) i
need to find an alternate to run report.
do u have some ideas ?
my reqiurement is :
running report over night job which outputs results to a printer
& file !i think of submitting request to concurrent prg which runs this
report set at schedules ! could u tell how to pass a request to concurrent
prg ?
TNX
any help is highly appreciated !!
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
Subject: RE: running report from cron job !
Date: Mon, 28 Jun 1999 15:59:54 -0400
lookup the CONCSUB utility which lets you submit a concurrent program from
UNIX shell
From: Ramana Kondaveeti Ramana.Kondaveeti@hds.com Report run time error
Date: Sat, 04 Apr 1998 17:25:26 +0200
Date: Mon, 5 Jul 1999 07:55:33 -0700 (PDT)
Date: Mon, 5 Jul 1999 19:08:27 +0400
Date: Mon, 5 Jul 1999 20:53:10 +0530
Date: Tue, 6 Jul 1999 09:21:01 +0300 View Reports online - R11.02
Date: Wed, 7 Jul 1999 14:42:36 -0400
Date: Wed, 7 Jul 1999 14:12:24 -0600
Date: Wed, 7 Jul 1999 16:42:37 -0400
Date: Wed, 7 Jul 1999 16:45:47 -0400 (Eastern Daylight Time) Incrementing date parameters in Report sets
Date: Fri, 2 Jul 1999 07:06:32 -0400 (EDT)
Date: Wed, 7 Jul 1999 07:47:04 +0300
Date: Thu, 8 Jul 1999 18:16:03 +0300 Problem when run report in D2K
From: Dan Olson[SMTP:dolson@dacotah.com]
On Wed, 5 May 1999 12:24:22 Uptmore, Chris wrote:
sean smith wrote:
Date: Thu, 06 May 1999 08:57:38 -0500
Subject: RE: running report from cron job !
Date: Mon, 28 Jun 1999 13:10:10 -0700
Try this and you can schedule the jobs in Unix very easily using cron
$ CONCSUB
[WAIT=N|Y|
CONCURRENT \
[PROGRAM_NAME="
[REPEAT_TIME=
[REPEAT_INTERVAL=
[REPEAT_INTERVAL_UNIT=
[REPEAT_INTERVAL_TYPE=
[REPEAT_END=
[START=
[IMPLICIT=
[
From: aragab a_ragab@tccbce.com
Subject: report run time error ?????%%%urgent%%%%
Hi Oracle Experts
when i try to run a report run time from developer 2000 report run time
i got this messge after going to read the page 4, notes we have not any
problem in
this report before
03:57 ERR ORA-01652: unable to extend temp segment by 7383 in
tablespace TEMP
== SELECT distinct 'CAT' , CAT . DESCRIPTION CAT_DESC , SUM ( LINES .
QUANTITY ) QUANTITY , SUM ( EXTENDED_AMOUNT ) extended_amount FROM
MTL_CATEGORIES_V CAT , MTL_ITEM_CATEGORIES_VIEW ICA ,
ra_customer_trx_lines_v LINES , RA_CUSTOMER_TRX_PARTIAL_V TRX
Best regards / Ahmed ragab
From: =?iso-8859-1?q?david=20solomon?= david_solomon_uk@yahoo.com
Subject: Re: report run time error ?????%%%urgent%%%%
Ahmed,
Flattery does not take you anywhere!!!.
You need to extend your tablespace, ie. the space allocated for you to
run this report. You did not have this problem before simply because
now you space is less or your form requires more space.
Cheers
David
From: mzaveri@eppco.co.ae
Subject: Re: report run time error ?????%%%urgent%%%%
Increase the sort_area_size in init$ORACLE_SID.ora file
or increase the size of temp tablespace by adding/resizing the datafile
This can happen, once your data increases. (It needs to sort more data now)
Hope this helps.
Mehul Zaveri
Oracle DBA
EPPCO
From: "Orafin" orafin@sohm.soft.net
Subject: Re: report run time error ?????%%%urgent%%%%
Hi,
U can resize the tablespace .
To increase the extents of the tablespace specity the statement
ALTER TABLEPSACE TEMP DEFAULT STORGAGE( NEXT 100000K)
BYE
chand
From: Mohammad Fouwaaz Mfouwaaz@savola.com
Subject: RE: report run time error ?????%%%urgent%%%%
Looks as if you are generating a cartesian product. Since you have not
given 'WHERE' clause, it is difficult to say. If you are sure that your
query is behaving well, then you may get your Administrator to increase the
tablespace.
Regards
From: Kathryn VanScoy kvanscoy@prg.com
Subject: Report Viewer
Hello,
Currently we use Word Pad to view our reports on line. We are also
preparing to upgrade from 10.7 to Rel 11.02. We have been told that we can
no longer use Word Pad. Does anyone have a good substitution?
Thanks for your assistance!
Kathryn
From: kbrown@es.com
Subject: RE: Report Viewer
We've been using Internet Explorer and it seems to
work rather well. Do you have that option?
From: "Jethwa, Nilesh" Nilesh.Jethwa@mmt.bellhowell.com
Subject: RE: Report Viewer
what r the steps to setup the report viewer. for e.g what r the steps to
setup ghostview
as the report viewer for postscript files
Thanks
From: Mary Ann Carr macarr@cmu.edu
Subject: RE: Report Viewer
You can also apply patch 811267 and then have the additional options of
using MSWord or MSExcel.
From: stuartw@email.com
Subject: FND: incrementing date parameters in report sets
I think I've seen this problem mentioned before, but I'm not sure if there
was a solution. In R11, you can schedule requests which increment their
date parameters each time they run, but this functionality doesn't seem to
work for request sets.
Does anyone have a fix or a workaround?
Thanks, Stu
stuartw@email.com
From: "Lavy, Shay" Shay_lavy@icomverse.com
Subject: RE: incrementing date parameters in report sets
Hi Stu,
It depends on the Release you're working on.
We Encountered several scheduling problems in Rel. 11.0.1 (our current
Rel.):
1. When scheduling "Periodic" the "Completion Option" is multiplied each
time the report reschedule itself.
2. When Scheduling "On Specific Days" the report runs once and does not
Re-Schedule itself.
We are now in the process of testing Rel. 11.0.3.
The first problem is solved in 11.0.3.
The second one (I believe this is your problem) is not resolved yet.
However, Support assures us that it is resolved in 11.0.4 and gave us a
patch to test (Hopefully next week) on 11.0.3.
Regards,
Shay Lavy
ITA Department
Comverse Network Systems
Phone no. : 972-(0)3-765-5794
Cell Phone: 972-(0)51-325794
E-mail : shay_lavy@icomverse.com
From: "Lavy, Shay" Shay_lavy@icomverse.com
Subject: RE: incrementing date parameters in report sets - Solutions
I'm Happy to announce that we have finished testing patch no. 801184
that was supposed to solve issue no. 2 (see below).
The Patch is working on Rel. 11.0.1 and Rel. 11.0.3, It solves the problem.
Regards,
Shay Lavy
ITA Department
Comverse Network Systems
Phone no. : 972-(0)3-765-5794
Cell Phone: 972-(0)51-325794
E-mail : shay_lavy@icomverse.com
Sent: Wednesday, May 05, 1999 7:46 AM
Subject: Reports modification
We are using 16.1 on Win 95 and 10.7 SC on Digital Unix. When we
ftp a
report off the server and attempt to run it in Developer 2000
reports
designer (version 1.3.2) it fails. Errors vary from: REP 1419:
'before
report' PL/SQL Error ; to Data table undefined errors.
We have successfully run simple reports that we have created from
the
templates. Is there some trick that we are missing in running an
existing report from Developer?
Thanks
Dan Olson
Dan,
It's not finding the Apps User Exits that are "linked in" to the
server-based runtime executables ar25run (and ar25runb for bitmap
reports).
You would have to comment out the calls to the User Exits starting
with the
SRW_INIT in the Before Reports trigger (and you don't want to do
that).
You should open the server-based D2K 1.3.2 Reports 2.5.5.8 Designer
ar25desb
(as opposed to the "standard" Designer r25desm) through an X/Motif
Window
and then run the Apps reports from this "Apps Reports Designer" since
it
finds all the Apps User Exits. Then you don't have to "FTP"
anything...
FYI,
Chris
Sounds like when you connect using Dev2000, perhaps you don't have
sufficient priveleges. I know we run all our process' and reports as
a generic "apps" users and if we try to connect to our database
directly to run developer reports we end up having to add "apps." in
front of all table names.
From: Dan Olson dolson@dacotah.com
Subject: Re: Reports modification
Sean and Chris:
Thanks, it looks like your suggestions will get us going again. At
one time I had deleted the User Exits - and that is where we were
running into the table not found problems. It sounds like Sean's
suggestion will take care of that problem.
But I like Chis' suggestion that I make modifications in the X version
of Developer. I had originally removed all but the report runtime from
the server in a effort to save hard drive space. Additional hard drives
have been added but I never got around to putting the tools back on the
server.
Dan Olson