View reports run by others
Date: Mon, 19 Jul 1999 11:08:54 -0400 (EDT)
From: David Callaghan callaghand@yahoo.com
Subject: Production Schedule?
Good Morning,
I am looking for some help. I have a group of users submitting
jobs/requests using different responsibilities. They want to be able
to view reports run by others on line. I know Oracle allows users to
view reports of others within the same responsibility.
Concurrent:Report Access Level must be set to responsibility. We have
our responsibilities set-up in a hierarchy. (I.e. GL00 Superuser to
GL07 Accounting Clerk) Canned Oracle allows for a horizontal
integration any suggestions on how to achieve a vertical integration
where a user with a higher responsibility has the right to see your
output. Any suggestions would be greatly appreciated. Thank you in
advance for all your help.
Regards,
David Callaghan
Date: Mon, 19 Jul 1999 12:12:34 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
Subject: Re: Production Schedule?
May be report group will help you. You can include all the reports in
the Lower group to the higher group and can assign this to the higher
responsibility.
Thanks,
MOHAN
Date: Mon, 19 Jul 1999 12:24:35 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
Subject: RE: Production Schedule?
I do not believe a Report Group would help here.
Mohan, please explain how the other Users would be able to see a Concurrent
Request submitted by another.
As far as I know you can not accomplish this with standard functionality.
Cheers,
Joe Maliszewski
Consultant
Date: Mon, 19 Jul 1999 10:51:29 -0700
From: CFowler@littonapd.com
Subject: RE: Production Schedule?
Hi,
Look at the system profile option "Concurrent:Report Access Level". It can
be set to either "User" or "Responsibility" which would determine at what
level the request log/output files are controlled (by user or by
responsibility).
I hope that helps.
Candace Fowler
Reports in Rel 11.02
Date: Mon, 26 Jul 1999 13:09:11 -0400
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
Subject: GEN: Reports in Release 11.0.2
When I bring an RDF file from the server onto my PC and open it in Dev2k
Reports 2.5, I get a bunch of warnings about sizing and character mode and
other stuff. Can I develop the reports in Win95 and then port them over to
the apps sever, or do I need to develop them on the server software
(Solaris)? In the reports directories under the module top directories, the
rdf files are present not the REPs, why? Any help would be great. Thanks
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rfsuny.org
Report output directly to file
Date: Mon, 26 Jul 1999 18:16:27 -0400 (EDT)
From: Mohan muthan mmuthan@yahoo.com
Subject: Sending a Report Directly to a File
I need the output of a Report in Oracle Applications to be Directly
sent as a File into a respective Directory.
Any immediate would be appreciated.
Thanks
Mohan
Date: Mon, 26 Jul 1999 18:40:49 -0400
From: "Stephen J. Farley" farleysj@bellatlantic.net
Subject: Re: Sending a Report Directly to a File
Redwood4 (www.redwoodsw.com ) offers Information DeliveryWare to deliver
any OraApps, ERP or homegrown apps output to any defined local or remote
destination: web, file; fax; printer; pager, email, etc. By directing
the output to the web, you can support and manage your intranet portal.
Steve Farley, Redwood America, 610.722.5185 sfarley@us.redwoodsw.com
Date: Mon, 26 Jul 1999 16:49:00 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
Subject: RE: Sending a Report Directly to a File
Mohan,
What about something on the order of:
1) Build a special little Printer Driver on the order of "mv
$PROFILE$.FILENAME directory_you_want _to_put_this_thing"
2) Define a DUMMY type printer this driver for the report
3) Use the DUMMY type printer for your report, when report is generated it
moves it to the location you want, instead of printer queue.
You get the idea.
Regards.
Customize Std report-change in rdf not seen in all connected reports
Date: Thu, 29 Jul 1999 13:47:35 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: Customization of Standard Reports
Hi, Guys I get rid of the some fields from the standard reports call
CSTRINVR.rdf.
This rdf files shares by two reports called SUBINVENTORY ACCOUNT VALUE
REPORT and
INVENTORY VALUE REPORT.
I can see the changes in only Inventory value report but I can't see the
same changes in other report.
I would like to see the changes in Subinventory account value report only.
I am thinking to register a new report with all the changes I want. Only
thing I am wondering is why I can't see the changes in both reports if this
single rdf shares by two reports.
Any feedback greatly appreciated.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Thu, 29 Jul 1999 15:10:11 -0400
From: "Sankala, Dinesh" Dinesh.Sankala@lgeenergy.com
Subject: RE: Customization of Standard Reports
HI
It is because depending on the user input the same rdf displays two
different layouts
i..e the other one is programatically supressed depending on th user input.
check the user parameters I believe U can find there I think it is P_sort_by
or P_sort_option
I dont remember exactly ( I worked on it long back)
hope this will help u
dinesh
Date: Thu, 29 Jul 1999 15:42:18 -0400
From: Reddy Ahalya-G1921C G1921C@ga25epd.mot.com
Subject: RE: Customization of Standard Reports
Hi Bharat,
The SUBINVENTORY ACCOUNT VALUE report is CSTRSAVR.rdf
While the INVENTORY VALUE report is CSTRINVR.rdf
They are two different reports
Check which report you are changing
Regards,
Ahalya
Date: Thu, 29 Jul 1999 15:06:18 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
Subject: RE: Customization of Standard Reports
Ahalya, I went through sysadmin res and found out regarding the executable
rdf for SUBINVENTORY ACCOUNT VALUE REPORT. It has the CSTRINVR.rdf. the
CSTRSAVR is the short name of that report. This one I did before any
modification to that report.
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Averae calculation in Reports
Date: Thu, 29 Jul 1999 16:23:51 -0500
From: "Cheley, Dave" DCheley@sandc.com
Subject: Report Question
I am working on an Oracle report with Developer 200 and I am having a
problem with creating a field with an average value. The problem is that I
have columns that contain values but they also contain zero's. I want to
calculate the average of the column but in the calculation it calculates the
average with the zero's. For example, if I had the values 0 and 100. I
want the average to be 100 (ignoring the 0) but it actually calculates the
average to be 100. I would imagine that there is some simple solution to
this problem but I am missing it.
Thanks in advance for your help.
Dave Cheley
Programmer / Analyst
Date: Thu, 29 Jul 1999 15:27:41 -0600
From: PKBATCHU@micronpc.com
Subject: RE: Report Question
You may need to write a function in the report and use it.
Report customization - REP-0729 error
Date: Mon, 2 Aug 1999 09:33:41 +0800
From: "Sriram, PUC - 4055" sriram@panunited.com.sg
Subject: Help needed on Report Customization
Hi All
When I try to open the report ARXCAR (Applied Receipts Register)for some
customization, I am getting the follwing error
REP-0729: The program unit 'arp_standard' of size '128889' bytes is too big
to be loaded for the current platform
at the limit of '65023'
Any help to overcome this problem is greatly appriciated
Please cc your reply to sriram@panunited.com.sg
Thanking you
Sriram
Date: Mon, 2 Aug 1999 11:30:04 +0530
From: "manoj_bhatnagar/Polaris"@polaris.co.in
Subject: Re: Help needed on Report Customization
Hi Sriram
You have to load the 32 bit version of Developer/2000 in your client. You
are
facing
this problem because right now the 16 bit version of Developer/2000 is
loaded in
your
machine with the limit of 65023 bytes.
Hope this helps.
Manoj Bhatnagar
Associate Consultant - Technical
Polaris Software Lab Ltd, India.
Date: Mon, 02 Aug 1999 11:52:57 +0530
From: Susan susan_jackson@mail.usa.com
Subject: Re: Help needed on Report Customization
Hey!!! Whaz this......
Is 65023 bytes for a maximum limit to a program unit
in the report or......
Also if you have other limits please share with me
as of procedure/trigger at database and forms or reports
level.
Regds
Susan
Date: Mon, 02 Aug 99 12:29:54 -0800
From: sagarwal@guthy-renker.com
Subject: Re: Help needed on Report Customization
Sriram
What platform is your production? If it is UNIX, modify the report in
UNIX platform only because you have size limitation on Windows
platform.
Sanjay Agarwal
sagarwal@guthy-renker.com
Directory for output of reports
Date: Mon, 2 Aug 1999 06:58:05 -0400
From: "Bob Delaney" rdelaney@prodigy.net
Subject: AOL: Report 2.5 Extract File
My client is generating an asci file using Reports 2.5. We see the logic
within the report to open, write and close a specific file name, but have
not been able to figure out how the output directory is defined.
Any help would be greatly appreciated.
Thanks,
Bob Delaney
ISS, Inc
Date: Mon, 2 Aug 1999 17:07:14 +0530
From: "manoj_bhatnagar/Polaris"@polaris.co.in
Subject: Re: AOL: Report 2.5 Extract File
Hi Bob
While installing the Oracle Applications we have to specify the Output and
Log directory to install program. After installation all the Output and Log
files go to the respective Output and Log directories.
There is an option while installation where we can specify that whether we
want seperate Output and Log directories for individual modules or only one
common set of Output and Log directories for all the Modules.
Hope it solves your problem.
Manoj Bhatnagar
Associate Consultant-Technical
Polaris Software Lab Ltd, India.
Date: Mon, 2 Aug 1999 09:01:10 -0400
From: "Kelly.Newman" Kelly.Newman@plpit.fishersci.com
Subject: Subject: AOL: Report 2.5 Extract File
Hi Bob,
Is the report using UTL_File to create the file? If so, one of the
parameters in the 'FOPEN' statement has to be the location. This location
must be one of the allowable directories defined at instance start up.