ORACLE APPLICATIONS ARCHIVES
Topicwise collection of
Postings on Mail Lists
ON
ORACLE APPLICATION REPORTS
Custom Report run - APP-01048 error
Date: Fri, 27 Aug 1999 03:19:03 PDT
From: "seth umar" sepora32@hotmail.com
Subject: Gen: GL Customised report error
Dear All,
I modify GL report by inserting new column (from a new table)
I can compiled in Dv2000 report 2.5. Then I saved, and ftp back to
server. When I run that report, I had the error below (after relink this
program that i modified).
APP-01048 Invalid executable: /apply2/app/applmgr/fnd/6.1.1/bin/ar25run
APP-01125 Concurrent Manager got error running Oracle Reports for request
324310
I searched through archives, but the closes that I found is to use ar25run
from the server. I don't know how to login, esp the database?. Is there a
way not to use server's ar25run?
FYI I'm using 10.7 16.0 GUI, 7.3.2. and DV2000 2.5
Thanks
Seth
Date: Tue, 31 Aug 1999 11:17:10 +0530
From: Kasturi Srinivasan srinika@pcsbom.patni.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Re : GEN: Costomized report error Invalid Executable ar25run
Hi,
Please check if you have FTP'ed the right version in the appropriate
directory.
Regards
srinika@pcsbom.patni.com
Kasturi Srinivasan
Oracle Application Consultant
Patni Computer Systems Limited
Request Sets - Select specific Report from
Date: Fri, 27 Aug 1999 07:54:21 -0700 (PDT)
From: chris johnson ora_us@yahoo.com
Subject: ****Request Sets****
Hello all,
I defined a request set in GL. I am wondering how to stop one
report of the report set from running.
Is there any way to select only specific reports of a request set.
Thanks for any suggestion or comments,
Chris
Grouping in Report thru Layout Editor
Date: Fri, 27 Aug 1999 19:30:55 GMT
From: "Jaayanti Vishwanathan" vijaay@hotmail.com
Subject: Report Question ..
Hi All,
I am customizing existing standard report. I'ts very complex report. Part of
Layout is like this :
Inv # Inv Date Amount Paid Account Dist Amount
----- -------- ----------- ------- -----------
1234 10-JAN-99 50.00 135-32790 50.00
1234 10-JAN-99 50.00 135-32250 -50.00
I want to suppress Inv # , Inv Date , Amount Paid fields if there is same
value repeating on next record. It should be like this :
Inv # Inv Date Amount Paid Account Dist Amount
----- -------- ----------- ------- -----------
1234 10-JAN-99 50.00 135-32790 50.00
135-32250 -50.00
One way is I can create one upper group in Data Model editor and pull first
three fields in that group so that it will not print those fields if value
is repeating . But I don't want to change Data model editor and possibly
make change in Layout Editor itself.
My question is : Is there any way to get above output other than pulling
those fields in upper group in Data model ?
Thanks in advance.
Date: Fri, 27 Aug 1999 16:59:40 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: RE: Report Question ..
Hi,
What I think you can do is write a trigger on the repeating frame
and copy the inv# into a place holder column and then
write triggers on the fileds inv#, inv_date, amount paid
and check whether the current value in the field is equal to
the place holder column and then if it is same value of the field
then return false other wise return true.
HTH
Kiran
Modifying GL Report
Date: Sat, 28 Aug 1999 00:57:57 +0500
From: Naqi Mirza mirzas@isb.apollo.net.pk
Subject: Reports - GL
Hi, I have this problem where a report from the general leger, 'journals
- general 132 char' description field is not printing the entire
description of a certain journal. I was wondering if anyone knows the
best way to solve this. I'd assume altering the report's description
field itself would solve the problem, which leads me to the question,
what is the easiest or rather best way to determine the name of a
certain report so that i can locate it and make the necessary
alterations to it? i'm guessing all gl reports would be located in
%GL_TOP% directory, but then how do i determine which is the one i want
any help would be appreciated thanks
Naqi Mirza
Date: Fri, 27 Aug 1999 15:36:38 -0500
From: Kim Bauman kbauman@midcom-inc.com
Subject: RE: Reports - GL
The way to find the executable name of the report is to have someone with
System Adminstrator permissions look it up for you. It is very easy to find
under Concurrent Programs.
Kim Bauman
Date: Fri, 27 Aug 1999 16:24:59 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
Subject: RE: Reports - GL
Naqi,
Query on the Program name in SysadminConcurrentProgramDefine and get the
Executable name
Go to ConcurrentExecutable and query on the executable name... you will
find the report type and name...this will be the report name under the
respective tops...
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Bitmap Report on NT - errors
Date: Fri, 30 Jul 1999 08:18:06 +0000
From: ktoure@bceao.int
To: oraapps-dba@cpa.qc.ca
Subject: Bitmap report error
Platform : NT4 SP3
APPS : 107NCA
DB : 734 NLS
When i run a bitmap report a get the following message
APP-00931 Program stop with statut 1
APP-00882 Impossible to open C:\TEMP\OFB.tmp in read mode
Thanks
Date: Fri, 30 Jul 1999 18:26:08 +0400
From: mzaveri@eppco.co.ae
To: oraapps-dba@cpa.qc.ca
Subject: Re: Bitmap report error
As I remember, users need some explicit right on C:\ under NT to run
reports.
Also you can try out regedit Oracle variable -> REPORTS25_TEMP ,
REPORTS25_TMP (Try first both, I don't remember)
to writable path for users.
Reprts across modules - List of
Date: Sun, 29 Aug 1999 21:09:30 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: REPORTS !
Hi ALL,
We are looing for a list of reports that need to be
ran after each task for eachof the GL, AP , PO & CE
modules.
For examle, the data entry validation reports for the
invoices and JV's ... etc
Thanks for HELP.
Firas Al Tamimi
ADWEA
OF Support
Username on Reports
Date: Mon, 30 Aug 1999 12:00:24 -0400
From: Erik Ritters eritters@prg.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: Adding Username to Report
Has anyone modified their oracle reports 2.5 application reports to include
the username or login?
If so, does anyone have a good way to do this?
Thanks
Erik Ritters
_________________________________
Information Technology & Strategy
Production Resource Group, L.L.C.
539 Temple Hill Rd.
New Windsor, NY 12553
Phone - (914)567-5784
Fax - (914)567-5805
Email - eritters@prg.com
_________________________________
http://www.prg.com
Date: Mon, 30 Aug 1999 09:44:08 -0700
From: "Kalyan Chak" kalyanchak@visto.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Adding Username to Report
Hi There,
Just use a formula column of char type at report level and write just :
Return (USER);
in it's formula. This will create a field and boilerplate in layout editor.
Set the position for them and run the report and enjoy....
Regards,
Kalyan Chak
Date: Mon, 30 Aug 1999 17:40:07 -0400
From: Erik Ritters eritters@prg.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: Re: Adding Username to Report
Kaylan,
Where do I put the field associated with this new formula column?
I tried placing a field in the margin along with my report title and page
number info but received the following error during runtime:
Field 'my_field' references column 'my_formula' at a frequency below its
group.
Thanks Again For Your Help!
Erik
Unale to view Reports from Apps
Date: Thu, 02 Sep 1999 01:45:22 PDT
From: "David Philips" philipsdavid@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: Urgent:Not able to view report output from OraAPPS
HI all
I am not able to view report or view log from Application
r11.0.3 in vision database
i am able to print
The error was
"An error while attempting to establish an
Application File Server Connection
with node RELICONB.There may be network configuration
problem or TNS listener may not be running "
my listener is running
can any one throw some light on this
where can be the problem
David
RELICON
Frames - manipulating
Date: Thu, 2 Sep 1999 12:06:34 -0400
From: "Cathy LaMarre" lamarreca@irctt.com
To: "oraapps" OraApps-L@cpa.qc.ca
Subject: TOOLS: Reports 2.5 question
I am having a time understanding how the concept of sending frames to
the front, back, forward, backwards works. I cannot find an explanation
in the Building Reports Manual. I have looked under Arrange, Frames,
Send, etc. Here is my situation. I created an oracle report and
modified the layoout so it looks like I want. Now I have added a new
group above all my groups in the data model. I manually created the
group frame around all other frames and a repeating frame under that.
The problems are (1) the repeating frame shows at the same level as the
group frame when it should be under the group frame. I do not quite
understand what frame has to be sent forward/backward to fix it and (2)
the group frame that was the top before I added the new group is also
showing at the same level as the new one, when it should be under the
new one.
Any help would be appreciated.
Thanks. Cathy
Date: Thu, 2 Sep 1999 12:42:00 -0400
From: Naga Naga@centuryaluminumwv.com
To: "\"Multiple recipients of list\" " oraapps-l@cpa.qc.ca,
Subject: RE: TOOLS: Reports 2.5 question
hi cathy,
just create the frame anywhere outside. Then copy or cut the frame
that you've created and paste in the frame which is going to be the
master frame. before doing that you've to select the master frame.
this is how i did, something like what you're trying to do.
bhaskar
Date: Thu, 02 Sep 1999 13:00:13 -0400 (EDT)
From: Balalji Sundaralingam CMCISSB@NJTRANSIT.STATE.NJ.US
To: oraapps-l oraapps-l@cpa.qc.ca
Subject: Re: TOOLS: Reports 2.5 question
Hi Cathy,
Its better to open two windows side by side. One for viewing the Navigator
and
the other for the Layout. This would help you to know where exactly the
frames
are created and whether they should be moved forward or backward. Each
frame
or field you select in the Layout, the corresponding object gets highlighted
in
your object navigator.
HTH
Bala.
Date: Sat, 4 Sep 1999 10:49:16 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: TOOLS: Reports 2.5 question
Hi
I have been in this mire and I know how gummy it is. If you are in version
2.5 or more the first thing you do is ensure that 'Confine' (icon with a
lock) is set on -- that way you ensure that things will generally be held
where they are supposed to be. Then you resize the layout window in such a
way that the object navigator is visible on the side. That way you have a
better handle on what you are doing and the frames that you have actually
selected and are working with.
Send to Back sends the selected frame behind all the other frames and Bring
to Front brings it in front of all other frames. The Move Backward and Move
Forward options move the frame in single steps in the relevant direction.
As I understand, since you have created a group that is a parent of all the
other groups, you should send this to the back. If I may give you a hint on
this, it is a good idea to keep on saving multiple versions of the .rdf file
as and when you make even a small change to the layout. This way it is
possible to fall back on a suitable earlier version when the one you are
working gets messed up as it is sure to do more than once!
If you encounter any problems please feel free to email me.
Regards
Summary Line on Positive Pay Report
Date: Thu, 02 Sep 1999 19:14:30 GMT
From: "bharathi Yarlagadda" bharathi_d72@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: Help neded to Solve Reports 2.5 Problem
Hi,
Excuse me as I am little new to Reports....
I am modifying the report for Positive Pay and I was able to manage
till the details level.
My report should also have a summary line at the end of all transactions for
that BANK_ACCOUNT_NUM as for ex:
09098765122 000000021000000000000005311999000000000000000
09098765122 000000021400003053853405051999000000000000000
09098765122 000000023300000006000005311999000000000000000
09098765122 000000023400000005000005311999000000000000000
0909876512T 000000001500000225111300000000000000000000000
I am able to manage till detail level like the first 4 lines above.
Please let me know how to work on the summary level.
As you know , I cannot break on a column as this will not show that
column for ex: I cannot have output as follows:
09098765122 000000021000000000000005311999000000000000000
2 000000021400003053853405051999000000000000000
2 000000023300000006000005311999000000000000000
2 000000023400000005000005311999000000000000000
T 000000001500000225111300000000000000000000000
Please suggest the solution.
Thanks a lot.....
-Bharathi Yarlagadda
run_product - use to run report errors
Date: Fri, 3 Sep 1999 14:36:14 +0100
From: rchalton@dunnes-stores.ie
To: oraapps-l@cpa.qc.ca
Subject: GEN: Apps 11.0.2 NT, report from a form using RUN_PRODUCT
Trying to run a custom report from a custom form. Do not want to use
concurrent manager. So Reports 2.5 has been installed on the APPS server
and the RUN_PRODUCT built-in is being used to call the report. Works OK
when run outside of the application but fails with FRM-40733 when run from
inside the application. The report has been placed in the REPORTS25_PATH.
Would rather not use the HOST command.
Any suggestions would be greatly appreciated.
Regards
Rob C.
Report Viewer Setup
Date: 04 Sep 99 13:59:50 -0300
From: "Prakash Abraham" PABRAHAM@SA.oracle.com
To: oraapps-l@cpa.qc.ca
Subject: Editor (Viewer ) set up in Apps rel 11.0.2 in NT
Hi,
Problem no:1 Report viewer setup
-------------------------------
The Profiles options I am settings currently are as follows
Viewer HTML as path:/iexplore.exe (i have ie4.0)
Viewer text as Browser
Viewer as Postscript Local path:\winword.exe
After doing there changes it prompts an error saying that
When i try ot view a log or output
"Could Not determine the URL for web file viewing"
If i remove all these it gives the output in default viewer.
Can somebody advice me what else i have to do to setup, so that i can view
in word or wordpad or netscape or ie.
Problem no:2 GUI objects output from oracle reports thru oracle applications
rel 11.0.2
------------------------------------------------------------------
I have customized some reports which has GUI Objects like lines boxes logos
etc.
But looks like reports in apps rel 11 still runs in character mode. All my
GUI objects are coming as junk characters.
How can i change the reports runtime in apps to GUI mode
or
Do i have to install the printer and related styles and drivers in such a
way that it runs in GUI mode
Can some body help me out all the possibilities and limitations on the
issues above.
Earlier reply is useful and appreciated
Thanks and Regards
Prakash Abraham
Designer Version with 10.7SC 16.1
Date: Sat, 4 Sep 1999 23:43:28 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Reports Designer for APPS 10.7
Hi,
I need to know which certified Reports Designer version
i must use
with the Financials 10.7SC 16.1
Thanks
Firas
Date: Sun, 5 Sep 1999 10:04:50 +0300
From: Mohammad Fouwaaz Mfouwaaz@savola.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Reports Designer for APPS 10.7
Reports 2.5
Regards
Date: Sun, 5 Sep 1999 22:02:56 -0700 (PDT)
From: FMT firas70@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Reports Designer for APPS 10.7
do you mean 1.3.2 ?
Is there a 32 bit version and another 16 bit version for
the reports in this release ?
Firas