Copy file... in concurrent requests screen
Bracken Jeff-CJB086 cjb086@lmpsil02.comm.mot.com on 04/26/99 10:31:04 AM
cc: (bcc: Mark Conger/US/IVCR)
Subject: Copy file... in concurrent requests screen - Version 11
Hi...
I'm trying to use the "Copy file..." from a concurrent request report in
Version 11. My profile is set to copy to my C: drive, but when I do the
"Copy file..." it tries to go to a nonexistent URL. Does anyone know what
I
should expect to see? Should it go to a windows "save as" object or is it
really supposed to bring up another web page?
Thanks for your help,
Jeff
Date: Mon, 26 Apr 1999 11:59:40 -0400
From: "Mark Conger" mconger@invacare.com
Subject: Re: Copy file... in concurrent requests screen - Version 11
Welcome to the wonderful world of the Report REVIEW agent. Typically, when
you select the "Copy File..." entry from the Special menu, it will open a
copy of the Web Browser you have configured with a URL to pull the report
from the middle tier. The text of the report is displayed in your browser
at this point.
Most common problem in getting this to work is not having the PLSQL Agent
setup correctly or not haveing the Applications Web Agent profile option
set. There is a good document in Metalink on how to setup this
functionality.
Let me give ya a warning though. The output that is displayed in the
browser is sent with a PRE tag in front of it causing it to be displayed
as is with no modifications. That's great except with normal font pitch
sizes you can't see a full report page typically on your screen, much less
any of the wide carriage reports. A little creative Cut/Paste can let you
take the output to other applications and then reformat it if need be (lot
of extra work). I spent a little time with a 3rd party VB developer and had
him write a application that lets you take reports from NCA-based apps to a
specified text editor (like Word) without disrupting other browser
functions (like Export or Help) and without modifying Forms/Libraries code.
Reformatting is then done via a Word macro. Turned out to work much better
than cut/paste and keeps the accounting types happy! Most of this is based
on 10.7, but it should work the same in R11:)
Mark Conger
Norstan Consulting
Page No. of a Report
From: Jangada, Harish[SMTP:Harish_Jangada@csx.com]
Sent: Tuesday, April 27, 1999 12:13 PM
Subject: Report
Hi all
I need to develop logic based on the total no. pages of report . I have to
access total page no. value in program unit.
So I would be doing it in reports? . Is there any system variable which I
can use to get total no. of pages ?.
Thanks in advance.
harish
Date: Tue, 27 Apr 1999 13:38:43 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: Report
Yes they are &Total Physical page and &Total logical. Open a fields property
sheet in the Object tab you will see source from expand the list box and
scroll to the top of the list you will see them. You should be able to use
the value of this in your program unit.
Beth Carver
Date: Tue, 27 Apr 1999 13:14:14 -0600
From: Mary Anderson MaryA@sodak-gaming.com
To: "'Jangada, Harish'" Harish_Jangada@csx.com
Subject: RE: Report
Page 8-57 of Oracle Developer/2000 Reports 2.5 Reference Manual lists the
system parameters of "&Current Date", "&Logical Page Number", "&Panel
Number", "&Physical Page Number", "&Total Logical Pages", "&Total Panels",
"&Total Physical Pages". I am assuming you want "&Total Physical Pages" in
the program unit of your report.
Good Luck,
Mary
From: Jangada, Harish [SMTP:Harish_Jangada@csx.com]
Sent: Tuesday, April 27, 1999 1:01 PM
Subject: RE: Report
I can capture &Total Physical page and &Total logical in Layout .
But I am unable to use same in Program units.
Appreciate the help .
Thanks
Harish
Date: Tue, 27 Apr 1999 14:29:44 -0500
From: "Sharma, Rajiv" rsharma@ameritrade.com
Subject: RE: Report
I think you can make a formula column based on the two predefined values and
use them in your program unit
HTH
Rajiv
Date: Tue, 27 Apr 1999 14:58:09 -0500
From: "Kanakam, Venkat (c)" vkanakam@Carlson.com
Subject: RE: Report
Hi ,
I think you can not get total pages in a variable in a direct way. A
page number can be obtained from SRW.GET_PAGE_NUMBER built-in procedure.
That also you can get correct value in a format trigger only, which can be
used to change the value of that particular field and can not be assigned to
a variable.
try indirect methods, if any.
HTH
Venkat Kanakam
Consultant
CIBER, Inc.
Generate and send sql report as attatchment to a mail
Date: Fri, 7 May 1999 08:21:49 -0700
From: "Malineni,Janaki" janaki.malineni@caltech.edu
Subject: GEN
Hi All,
we have registered a shell script as a concurrent program which in turn
calls sqlplus and generates a sqlplus report .The output of the file is
being spooled into a text file for ex. e.txt. We need to send this file as
an attachment through e-mail to a particular receipent. We were using mailx
and were able to send only the body of the file but not as an attachment
which we really care for. If anyone had achieved this please let us know
how. We cannot use elm as it is not set up .Any help is greatly appreciated.
Thanks,
Janaki.
p.s. we are on SMTP server
Date: Fri, 7 May 1999 08:45:40 -0700 (PDT)
From: Srinath Anand srinath_anand@yahoo.com
Subject: Re: GEN
Hi,
We have done a similar thing and this is what we have done.
"mailx -ms Report Name Parameter"
There are also some "host" commands and the use of "awk" which we used
for this report.The parameters passed were the email address(es).
This sent the file as an attachment to the specified persons.
Let me know if this helps.
Srinath Anand
PL/SQL report - Query 1
From: Martin Peck [mailto:martin.peck@connectware.ca]
Sent: Friday, May 07, 1999 11:15 AM
Subject: PL/SQL report under Ora Apps
I would like to add a PL/SQL package as a report under Oracle Apps. It will
need to be called via the standard report requests with only one parameter.
The problem I am having is with the report output. I am currently using
DBS_OUTPUT.PUT_LINE to display report information. The line SET
SERVEROUTPUT ON 10000 gives the following error when the report is added to
Oracle.
PLS-00103: Encountered the symbol "SET" when expecting one of the
following:
begin function package pragma procedure subtype type use
an identifier a double-quoted delimited-identifier cursor
form
I am new to this, and so I am not sure if the SET SERVEROUTPUT is
unnecessary, or if I should be using some other method than DBMS_OUTPUT to
display report text.
Any help would be greatly appreciated.
Thanks in advance,
Martin.
Date: Fri, 7 May 1999 12:39:31 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: PL/SQL report under Ora Apps
you need to add dbms_ouput enable(100000); immediate after begin statement
under your package body.
hope this help.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Fri, 07 May 1999 14:16:27 -0400
From: Ramesh Gade ramesh.gade@Yale.Edu
Subject: RE: PL/SQL report under Ora Apps
Hi Martin,
I am not sure if you can use SET SERVEROUTPUT ON with a PL/SQL
package(I assume you have defined
your concurrent executable type as a 'report' or a 'PL/SQL stored procedure').
Define your executable type as a 'SQLPLUS program', call your
PL/SQL package in a '.sql' file with your parameter defined, here you can
use SET SERVEROUTPUT ON.
HTH,
Ramesh.
Date: Tue, 5 Jan 1999 10:15:24 +0530
From: "Raghunathan Sunil" sunilr@wipsys.ge.com
Subject: Re: PL/SQL report under Ora Apps
Martin:
Our sincere efforts while coding in apps is to avoid UTL_FILE, if you don't
want it as a separate text file. Incase, your are using/planning to use it
consult your DBA and/or your Project Manager before taking this step. Those
little changes in init.ora can be at times painful to maintain for a DBA.
Now, for your specific problem of DBMS_OUTPUT for reporting, if you're on
release 11 prefer using FND_FILE.PUT_LINE(FND_FILE.OUT, Character String or
variable). this is very much like your DBMS_OUTPUT in function but much
more flexible and better way of displaying the output on your output screen.
You could use the same FND_FILE.PUT_LINE(FND_FILE.LOG....) for writing to
your log.
If you're not on release 11 then prefer DBMS_OUTPUT.PUT_LINE over UTL_FILE.
To resolve the problem you're facing use DBMS_OUTPUT.ENABLE. instead of SET
SERVEROUTPUT ON. You can use the latter only if it is a raw PL/SQL code (I
mean not stored procedure or something like that).
Regards
Sunil.
Date: Tue, 11 May 1999 12:29:06 -0400
From: "McQuown, Timothy" Timothy.McQuown@fmr.com
Subject: Re: PL/SQL report under Ora Apps
If you are using a stored program, you have no alternative but UTL_FILE.
Release 11 does provide support for writing to the log and out files from a
stored program concurrent request, but unfortunately they don't provide
general file I/O capabilities in FND_FILE.
A good discussion of the use of UTL_FILE is in the Steve Fuerstein book
'Oracle PL/SQL Programming'. Martin, I'll send you an example directly.
Tim McQuown
timothy.mcquown@fmr.com
PL/SQL report Query 2
From: Bharat Patel[SMTP:bpatel@DOMINOAMJET.com]
Sent: Wednesday, June 02, 1999 3:36 PM
Subject: running sqlplus report from applications
Hi, guys I registered a sqlplus scripts as report in ORDER ENTRY and I am
trying to run this report as concurrent program then it completed with
error. I looked at the log file and it says that error occurred while
concurrent manager trying to run sqlplus. Is there any thing I am missing.
things I did :
1. put the sql scripts in appropriate directory oe_top/reports
2. register as executable as well as define a new concurrent program.
3. register in appropriate request group.
4. set the permission 744 on file at OS level.
any kind of suggestions are welcome.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
From: Uptmore, Chris [mailto:uptmorec@kci1.com]
Sent: Wednesday, June 02, 1999 3:57 PM
Subject: RE: running sqlplus report from applications
Use the directory $OE_TOP/srw for Reports 2.5 reports or
$OE_TOP/sql for SQL*Plus reports.
FYI,
Chris
Date: Wed, 2 Jun 1999 18:44:32 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: running sqlplus report from applications
Thanks Uptmore it works.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Thu, 3 Jun 1999 08:33:29 -0500
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: running sqlplus report from applications
Putting custom work in the application directory tree is generally not a
good idea. Your work can be trashed by a subsequent patch/upgrade and
could get lost in amongst all of the application files. We put all
custom work in a custom directory. In our case it is $EXT_TOP (EXT =
custom extensions).
Date: Thu, 3 Jun 1999 09:13:54 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: running sqlplus report from applications
Thanks those who responded my question. I am able to see the output of the
report on the screen. But the problem is now it is printing blank pages. we
have default printer setup for each request which is HPLJ4. I registered
this report with landscape style.
Any body has and idea why I am getting blank pages.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
From: Kurylo, Mary [mailto:Kuryma@consumer.org]
Sent: Friday, June 04, 1999 7:33 AM
Subject: RE: running sqlplus report from applications
the blank first page may be because of your NEWPAGE setting. I think that if
it's set to 0 you get a blank first page.
Try coding the set commands in your SQL script. The SQL default settings
used when running through applications may be different than your own. I set
everything in my SQL scripts including: linesize, pagesize, headings,
feedback, newpage, space, recsep, tab and trimout.
Mary Kurylo
Applications Development Analyst
Consumers Union of US Inc.
Date: Fri, 4 Jun 1999 09:28:21 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: running sqlplus report from applications
Thanks Mary, I am also using all the setting in my sql script. I took out
the newpage setting and now there is no blank page at screen. Also it gives
me and FRM- NO DATA FOUND error when I tried to do special - copy to bring
this report in navigator.
Any idea why?
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
BMP Reports on Apps
Date: Fri, 14 May 1999 08:18:44 -0700
From: "Saranath P" saran_p@mailcity.com
Subject: Reports :BMP Reports on Apps
U R G E N T
Hi All,
We need to design some reports on Bitmap format (Report with all squares and
boxes) and print it from Applications. Can the Technical Gurus help me on
how should we go about doing this.
We are on Rel.10.7 V16.1, HPUX.
Thanks in Advance
Prabu B
Date: Mon, 17 May 1999 08:54:40 -0400
From: NSmith@micros.com
Subject: Re: Reports :BMP Reports on Apps
We used a third party product called "Optio Forms". Went live on the
same platform as you and are now at Release 11.
Neil Smith
Date: Tue, 18 May 1999 21:47:03 -0700
From: "Saranath P" saran_p@mailcity.com
Subject: Re: Reports :BMP Reports on Apps
Hi Smith,
Thanks for your response. Here we will be using D2k tools and infact the report is to be delivered maximum by this week end.
Looking forward to some urgent help
TIA
---
Prabu B
Date: Wed, 19 May 1999 12:24:02 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: RE: Reports :BMP Reports on Apps
My experience is that using Optio you are paying extra for something D2K and
Oracle Apps handles just fine on its own. Its adds an extra layer and costs to
a process where it is absolutely not needed. No offense to Optio users
intended!
But there are a few tricks to get bitmapped/barcodes to print correctly. Im not
familiar with Rel.11 yet, but here's our specific setup for a postscript report
that prints logos, lines and boxes:
1. Develop the report in D2K, leave the box in the report property sheet
'Convert Bitmapped objects to boxes' unchecked.
2. In SysAdmin define your report as normal, with the OPTIONS field
modebitmap. Oracle Support recommends using VERSION2.0b as the value here.
And that is what we used prior to 10.7NCA, but a simple modebitmap works for
us now.
3. Create the this fle in $FND_TOP/srw/POSTSCRIPT.prt with the following text
only:
printer "POSTSCRIPT"
postscript
4. Setup a printer driver called 'POSTSCRIPT' with the following settings,
other than the name/description leave everything else blank:
SRW POSTSCRIPT -- see step 3
Spool No
Input No
Driver Method Command
Arguments lp -s -onb -ops -d$PROFILES$.PRINTER -n$PROFILES$.CONC_COPIES -t
"$PROFILES$.TITLE" $PROFILES$.FILENAME
5. We tied this driver to new style called POSTSCRIPT (the style didnt require
any special setup) and our printer type. Restart (Deactivate/Activate) your
concurrent managers EVERY time you modifiy drivers!
6. Create 'dummy' printer that points to /dev/null. This will be used to create
the postscript file. Define this printer in APPLMGR's login script as the value
for the environment variable PRINTER. So echo $PRINTER should reutrn the
printer name.
7. Add this 'dummy' printer to the
$ORACLE_HOME/guicommon2/tk23/admin/uiprint.txt file that we woudl be printing
postscript to like this (at the bottom of the file):
dummy_ps_printer:Postscript:1:dummy ps printer:default.ppd:
8. Restart your managers to pick up the new settings (especially the new
environment variable)
If you havent already, read the MetalLink papers on these details! Its under
Applications: Core Technologies: Oracle Reports: White Papers. There are
several variations you can do to get the same results, but the subtle
differences in you os/printer setup really determine the solution. Its worth it
though, and your company will save thousands of $ using this method over using
a 3rd party product.
Good Luck!
Amber
* I have a setup document that has all these details with screen shots and some
further detail, but its about 6 pages long. If you need it, I can make it
available on our website tonight. Just let me know!
--------------------------------
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
11.0.3 - Sun Solaris - Reports Submission Form FNDRSRUN Hangs!!
From: Cochran, John [mailto:John.Cochran@photomask.com]
Sent: Tuesday, May 18, 1999 12:52 PM
Subject: 11.0.3 - Sun Solaris - Reports Submission Form FNDRSRUN Hangs!!
Hi Everyone,
In testing an upgrade from 11.0.2 to 11.0.3, and forms 4.5.10.9.1 to
4.5.10.11.3 (patchset 5), we are running into a problem.
When submitting a standard request, from any module, the request submits
and
the 'view my requests' form automatically appears. The reports run fine,
allow you to view output/etc, however, when you close this form, you
*should* be dumped back into the Navigator window.
However, after 11.0.3, we find that when you navigate and select Requests
Run, two request submission forms appear, one that is active and resized
a
bit larger, and one inactive window opened behind the active window. The
active window allows you to complete the submission process, however, when
closing the view my requests form, it can not hand off back to the main
Navigator window since this other inactive form is there. At this point,
your entire appletviewer session is locked.
The inactive window above is totally gray, and can not be closed. This is
not the old 'white screen of death' issue. Only way to continue work is to
CTRL-ALT-DEL and stop the appletviewer session.
Any ideas?
John Cochran
Solutions Architect - Information Technology
DuPont Photomasks, Inc.
(512) 310-6384
From: Cochran, John John.Cochran@photomask.com
Date: Wednesday, May 26, 1999 12:30 PM
Subject: Another 11.0.3 problem - Sun Solaris - Reports Submission Form F
FYI:
Just wanted to let the group know that bug# 895623 has been filed for this
problem, and several other Gold support customers are experiencing the same
problem after the 11.0.3 upgrade.
Please let me know if you are having this problem or not on 11.0.3. I am
trying to track down exactly what caused this to break.
Thanks
-John
Single Org report to MultiOrg report
Moses Pandiarajan wrote:
Hello,
We are moving from single org to Multiorg very soon.
Any tips on How to make single org reports to Multiorg reports...
Thanks
Moses Pandiarajan
Date: 5 Jun 99 20:17:26 CDT
From: CRAIG YEDINAK craig.yedinak@usa.net
Subject: Re: Need Help in converting single org report to multiorg report
I didn't see a reply on this, so I thought I'd give it a shot. The org ID is
defaulted to your environment variables from the system profile option MO:
Operating Unit variable attached to your responsibility when you log in. The
system uses this for any reports. You shouldn't have to do anything if you
only want to report on one org at a time (which is generally the case).
If you need to set this from SQL*Plus, use this package:
execute package FND_CLIENT_INFO.SET_ORG_CONTEXT('your operating
unit id');
Best of luck. Craig
Craig Yedinak
Independent Consultant
Report run thru Concurrent Mgr
Date: Sat, 5 Jun 1999 16:56:04 -0500
From: "Kevin McCabe" kmccabe@world-net.net
Subject: Making profile options available to reports run under concurrent manager
Has anyone had any success in:
1. Defining a new profile option
2. Populating it with values at the responsibility level
3. Using those values from within a report submitted through the concurrent
manager.
We have a location code stored in this profile (call the profile LOCATION)
at the responsibility level. I want to use the location code to filter the
report.
What I thought I could do was something like this in the query
select ... from ... where location = FND_PROFILE.VALUE('LOCATION')
It doesn't work. The VALUE function is returning a NULL, when I know it is
good, because I do something just like this in a form on the client side and
it works, but it doesn't work in a concurrent request report.
I even tried creating a report parameter defined for the report: P_LOCATION,
and using the VALUE function to populate it in the after_pform trigger, but
still comes up NULL.
I tried using the #FND profile user exits, but get errors saying can't read
the profile.
Bottom line: The profile we created is populated properly and works with
forms, but is not working with a server report submitted through concurrent
manager.
What am I missing? We are using apps 10.7.
Thanks.
Kevin McCabe
kmccabe@world-net.net
Randolph AFB, TX
(San Antonio)
Date: Sat, 5 Jun 1999 18:54:10 -0700 (PDT)
From: Kevin Gillins kgillins@yahoo.com
Subject: Re: Making profile options available to reports run under concurrent manager
Kevin,
First, you need to make sure you are trying to use it in a custom
report. Then, I would make it a hidden parameter that is passed from
the SRS (standard report submission) screen into the report at run
time. This is the simplest method. There is a default at the program
define screen for parameters that you can used to access the profile.
All you need to do is mark that parameter required and not displayed.
It will then be passed to the report. The profiles generally work in a
default fashion depending on how they were registered. From Site to
Applications. From application to responsibility. From responsibility
to user.
Kevin Gillins
Date: Sun, 6 Jun 1999 12:03:43 +0200
From: Amber Allen-Sauer amber@allen-sauer.com
Subject: Re: Making profile options available to reports run under concurrent manager
Hi Kevin -
The exact setup is this:
From the Define Concurrent Programs screen, parameters block for you custom
program, create an input parameter that has DEFAULT TYPE=PROFILE and DEFAULT
VALUE=LOCATION (or whatever you profile option name is). You dont need to user
$PROFILE$ in 10.7, just the profiles name.
At first make sure the display is on, so you can test the submission. When you
run the report and the parameters form pops up you should see the value
correctly there. Once its working, turn the display off. If you are still
having trouble use srw.message in reports to print the value back to the log
file to make sure it is populating and use EXAMINE in the apps to check the
value of the profile option just before you submit the report.
I use this alot with custom reports, and it works great! Just make sure your
profile option is defined at the correct level for the responsibility the user
is submitting the report from.
Amber
--------------------------------
Allen-Sauer Consulting, INC
email: amber@allen-sauer.com
web: http://www.allen-sauer.com
Apps 10.7 NCA and MS Wordpad for Report viewing
Date: Tue, 08 Jun 1999 09:50:43 PDT
From: Michael Cheng myc70@hotmail.com
Subject: Apps 10.7 NCA and MS Wordpad for report viewing
All,
I was wondering if anyone had success in making either MS Wordpad or MS
Notepad the default editor for applications in either the 10.7 NCA or R11
enviornments. The old method used for the GUI enviornments (Profile
Options, Editor (Character), "PATH" $$FILE$$), does not work.
Any advice on solutions and/or work-arounds would be greatly appreciated.
Thanks in Advance.
Best Regards... Michael Cheng
Date: Tue, 8 Jun 1999 13:19:38 -0400
From: "Mark Conger" mconger@invacare.com
Subject: Re: Apps 10.7 NCA and MS Wordpad for report viewing
Hi Michael!
Rumor has it Oracle now has a patch that will let you do this although the
impplementation has been met with mixed reviews....
I spent somet time very early on with a VB developer and we came up with a
small program that will let you do this without forms modification. It
handles ASCII Text and bitmapped reports with no problems. We also added
some code for HTML based reports but have had no oportunities to test it.
Drop an email to tracy@arisiasoft.com and he can fill ya in on the info on
the application.
Mark Conger
Norstan Consulting/Invacare