Printing Ivoice Total at the last page of Invoice Report
Date: Thu, 12 Aug 1999 13:39:49 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: Invoice Report: Help
Hi All,
When I am trying to print the total invoice amount in the last page,
it is saying invalid printing code. I am getting this error
when I am changing properties of the filed as print condition LAST.
Could some body help me in getting
the total invoice amount to print at the end of the last page.
Thanks
Kiran
Date: Thu, 12 Aug 1999 13:41:36 CDT
From: "Prodipto Mitra" pamitra@hotmail.com
Subject: Re: Invoice Report: Help
Hi Kiran,
Create a summary column at the report level for the "Sum" of the invoice
amount field.
At the report footer print the summary column.
HTH,
Prodipto
Date: Thu, 12 Aug 1999 16:42:12 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
Subject: RE: Invoice Report: Help
I need to print the total at every invoice and if
the lines goes beyond one page then I need to
print the total in the last page of that invoice.
I am modifying the default oracle invoice report .
Please let me know,
Thanks
Kiran
Date: Wed, 18 Aug 1999 14:02:37 -0400 (EDT)
From: Satyanarayana Venuganti CMCISMV@NJTRANSIT.STATE.NJ.US
To: oraapps-l oraapps-l@cpa.qc.ca,
Subject: Re: Reports : Invoice total
Hi Kiran,
If you look at Invoice Report (RAXINV.rdf), you can see that freight
amount,tax
amount and total line amount is comming from AR_PAYMENT_SCHEDULES table and
these are there in MARGIN LAYOUT EDITOR and they will print for each page.
If you want to get the invoice total in the last page, just create summary
column and set print condition as last.
Go through the Q_INVOICE query, you will get clear understanding.
Don't forget to delete the fields in MARGIN LAYOUT EDITOR.
All the best.
HTH,
Satya
Date: Wed, 18 Aug 1999 14:11:57 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Reports : Invoice total
I already tested by creating the summary column and gave
the print condition as the last, but it gave an error by saying
the invalid print condition.
What do you mean by deleting the fields in the margin layout editor?
I am confused, What all I want is to print the total in the last page of
every invoice, not in the last page of the report. And I didn't have any
fields
in the margin.
Thanks
Kiran
Date: Wed, 18 Aug 1999 14:38:57 -0400 (EDT)
From: Satyanarayana Venuganti CMCISMV@NJTRANSIT.STATE.NJ.US
To: oraapps-l oraapps-l@cpa.qc.ca,
Subject: Re: Reports : Invoice total
They are there in M_PAGE_FTR Frame ( or search for F_TRX_LINE_AMOUNT,
F_TRX_TAX_AMOUNT, F_TRX_FREIGHT_AMOUNT Fields etc..).
In which repeating frame you are keeping the Summary column field ( Hope
it's
in R_INVOICE)and make sure to keep the summary column in G_INV_TERM group.
If you have any questions, let me know.
HTH
Satya.
Date: Wed, 18 Aug 1999 14:48:44 -0400
From: "Epuri, Kiran" KEpuri@comintertech.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Reports : Invoice total
I putting the invoice total in the r_terms repeating frame and
I am using the inv_all_amount filed for the invoice total it is in the
g_inv_term group.
Date: Wed, 18 Aug 1999 15:58:23 -0400 (EDT)
From: Satyanarayana Venuganti CMCISMV@NJTRANSIT.STATE.NJ.US
To: oraapps-l oraapps-l@cpa.qc.ca,
Subject: Re: Reports : Invoice total
INV_ALL_AMOUNT field does not have the TAX and FRIEGHT amount in it. It's
just
quantity_invoiced*unit_selling_price. If you want only that sum, create
summary
column field in R_LINES repeating frame and it's going to work for u.
Create summary column x, give the source as D_LINE_EXTENDED_AMOUNT and reset
at
G_LINES level and function as sum.
I do not have Recievables Application to test ur scenario, but I worked on
other customization.
Thanks,
Satya
Date: Wed, 18 Aug 1999 13:30:45 -0500
From: "Anil Kumar (ns)" akumar@cap.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Reports : Invoice total
you need to customize the RAXINV.rdf. You may need to create a small
repeating frame and select main repeating frame as source for it. Then add
a field to that repeating frame and select invoice total summary column as
its source. Set return(false) for the original invoice total field. Place
this frame in the appropriate position and set its print condition to LAST.
Hope this helps.
Anil Kumar
akumar@cap.org
Date: Wed, 18 Aug 1999 13:55:44 PDT
From: "Satish Hakim" satish_hakim@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Reports : Invoice total
Hi Kiran,
I assume you have created a summary column, then a field using layout editor
with a print condition as 'last' and type as 'anchoring'.
If it is so and you are getting this error then you can check whether this
field is anchoring to the repeating frame. I guess it is not, then try play
around in layout editor to see that the field is anchoring to the desired
frame. You can even try explict anchoring.
I hope this works.
Satish
Report customization
Date: Thu, 19 Aug 1999 14:22:58 +0530
From: Susan susan_jackson@mail.usa.com
To: "oraapps-l@cpa.qc.ca" oraapps-l@cpa.qc.ca
Subject: Report Customization *URGENT*
Hi ALL,
How is a report customization undertaken in Oracle Apps, if
anybody has worked on it please write me if possible along
with a report 2.5 or 3.0 RDF format.
I am badly in need, an early reply is an urgency.
Regds
Susan
Date: Thu, 19 Aug 1999 10:30:45 +0100
From: "SRS FreeZone" srs@freezone.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Report Customization *URGENT*
Susan,
If you modify a seeded Oracle App report they don't support it, so you have
to copy it, modify the copy, and run with that by changing the concurrent
request to point to the new rdf (or better still create a fresh concurrent
request and just disable the original - that way if Oracle upgrade the
report/concurrent requests you will not lose your settings/changes.
I know that the actual Oracle report itself is a bit complicated...!
Steve.
Date: Thu, 19 Aug 1999 10:56:47 GMT
From: sujata/Polaris@POLARIS.CO.IN
To: oraapps-l@cpa.qc.ca
Subject: Re: Report Customization *URGENT*
Hi Susan,
There is no fixed report format. What I will do is copy a report from the
same module and save as some other name.The you can customize it based on
the requirement.
Costomization may include -
writing a new query,
changing Layout,
Triggers re writing.
After the report is over you will need to register it with Oracle Apps
under
Sys Admin ->Concurrent -> Program -> executable then Program -> Define.
Hope it helps.
regds,
Sujata Kanchan
Polaris Software Lab Ltd.
Noida, India.
Date: Thu, 19 Aug 1999 18:53:59 +0530
From: arindam.sarkar@in.pwcglobal.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Report Customization *URGENT*
Hi, there is nothing fixed about report customisation. What you can do is
a take out a present apps report, save it in a different name and modify
it i.e. change the query, add some new fields, layout etc. make sure when
you FTP the RDF from the surver you do it in binary.
b write a new report using report writer 2.5 and register it with apps.
This I find to be more elegent way of doing a report customisation.
Whenever you follow this option make sure proper value sets are attached
for your parameters to run the report.
if you want I can send you RDF files for a customised report.
regards
ari.
Date: Thu, 19 Aug 1999 10:05:26 -0400
From: "Jagannathan, Ravi" RJagannathan@prcnet.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Report Customization *URGENT*
Susan,
Sujatha is right and in addition
While registering the report rename it and do not use the existing name.
(give a you company initials as a prefix)
If you add any new Parameters and if you need a LoV for that you may have to
add a new Value set (if not available)
Ensure that the custom reports are ftp ed to your custom top and not the
standard top.
Thanks
Ravi Jagannathan (MIS)
Tel : (305) 816 4831
Date: Fri, 20 Aug 1999 11:21:47 +0530
From: Susan susan_jackson@mail.usa.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Report Customization *URGENT*
Hi Sujata,
Thank you very much, the information you've
sent is a great help.
Regds
Susan
Pick Slip Report - to include order created by name
Date: Thu, 19 Aug 1999 09:56:27 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
To: "'OraApps-L@cpa.qc.ca'" OraApps-L@cpa.qc.ca
Subject: reports question
Hi, Guys, I am working on Pick slip report. My user want to see who(name of
employee) enter the order on this report.
I am trying to link the employee name with field called created_by in
SO_HEADERS_ALL table. created_by field is standard who column and it's data
type is number.
I want, base on this created_by field, get the employee name who enter the
order.
This thing we can see by login as order entry user on sale order screen help
- about this records.
Created by : name xxxx
Any idea ?
thanks.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Date: Thu, 19 Aug 1999 09:03:24 -0700 (PDT)
From: "MURTHY ADURI UDAY B." adurimurthy@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Re: reports question
Hi Bharat,(HOW R U?)
1.Look in fnd_user table for user_name based on the created_by you get.
Hope this helps,
Murthy.
Date: Thu, 19 Aug 1999 09:12:53 -0700
From: sagarwal@guthy-renker.com
To: oraapps-l@cpa.qc.ca
Subject: Re: reports question
link so_headers_all to fnd_user to get the name
Sanjay
(sagarwal@guthy-renker.com)
Date: Thu, 19 Aug 1999 12:07:32 -0400
From: "Kurylo, Mary" Kuryma@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: reports question
Does your user want to see which user created it or which employee created
it.
The CREATED_BY field refers to USER_ID in FND_USERS and from there you can
get the USER_NAME. If you want the EMPLOYEE_NAME, then if each user is
assigned to an employee, you can get the employee record that is associated
with the USER_ID from per_people_f
Mary Kurylo
Applications Development Analyst
Consumers Union of US Inc.
kuryma@consumer.org
Date: Thu, 19 Aug 1999 11:09:11 -0500
From: "Ramana Jessu (ns)" rjessu@cap.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: reports question
All the user names along with the user ids are stored in fnd_user table. The
user id is the foreign key for created by in all the other tables. To get
the user name you should join the created_by field of so_headers table with
the user id column of fnd_user.
HTH
Ramana Jessu
Ext : 7412
Date: Thu, 19 Aug 1999 13:36:12 -0500
From: Bharat Patel bpatel@DOMINOAMJET.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: reports question
Thanks all, it works great now.
Bharat Patel
D.B.A.
bpatel@dominoamjet.com
847-244-2501 ex 1249
Reports submission - notifying other users
Date: Mon, 23 Aug 1999 18:17:08 -0400
From: "Bartoletti, Mike" BartolMi@rf.suny.edu
To: "'Multiple recipients of list'" oraapps-l@cpa.qc.ca
Subject: GEN: Report Submission
This may be a stupid question but here goes. In the standard reports
submission you have the option of notifying other people by username. How
does this notify the users? Please let me know. Thanks.
Michael Bartoletti
Applications Development
Research Foundation of SUNY
ph:(518)434-7204
fx:(518)434-7211
mailto:bartolmi@rfsuny.org
Date: Tue, 24 Aug 1999 12:12:29 +0400
From: IjlalR@mashreqbank.com
To: oraapps-l@cpa.qc.ca
Subject: RE: GEN: Report Submission
I think the user gets a pop up box when he/she logs in but
I'm not sure.
Date: Thu, 26 Aug 1999 18:36:53 -0600
From: Amber amber@allen-sauer.com
Subject: RE: GEN: Report Submission
Michael -
This a new feature in Rel.11. Oracle Support claims it is a function of
Workflow and the person (or persons) you select when submitting a
concurrent request will be sent an email notifying them the concurrent
request has completed. The down side is that you must had Workflow
completely setup for this one feature to work.
I have a 9 page document support sent me to complete the setup, if you
would like a copy I would be glad to forward it to you.
Hope this answers your question!
Amber
Allen-Sauer Consulting, Inc.
Phone : (303) 399-4137
Fax : (303) 399-0660
Internet: amber@allen-sauer.com
Combined Report from FSG and AP
Date: Tue, 24 Aug 1999 12:38:00 -0700
From: "Seth Umar" sepora32@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: GEN: How to create combined report from FSG & AP
Dera ALl,
Have anybody ever created a combined report? I need to create a
report of expense acivities. Currently, I have to run a FSG report (of expense
accounts) and run another standard report in AP (to see details of each
expense account activities). My questions are:
1. I want everything in one report .. cutomized report.
My understanding I just need to copy FSG's query (from log file for
that FGS program) and combined it together with AP standard report
query. Can somebody verify this?
2. Is there any other way to doing this and can you share your
experience on doing stg like this.
Thanks.
Seth.
Date: Tue, 24 Aug 1999 08:06:25 -0400
From: "Maliszewski, Joseph" Joseph.Maliszewski@FMR.COM
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: How to create combined report from FSG & AP
Please be more specific in what you are looking for and what version of the
Apps you are running.
GL has a few specific reports which shows some AP detail. It is not in FSG
format but might suffice for what you are looking for.
And the answer to your question is undoubtedly yes. Many people have created
reports that cross modules.
Regards,
Joe Maliszewski
Consultant
Standard Reports for entire suite - Rel 11
Subject: [orahrms-l] Sample Reports in Release 11 Oracle Products
From: "Bacchus, Frank" fbacchus@rwjf.org
Date: Fri, 16 Apr 1999 09:16:14 -0400
The current manuals for Release 11 omitted the samples of the Standard
Reports. Does anyone know where I can view these standard reports for
Release 11 GL, AP, HR, PY, PO ? Is there a manual with these Standard
sample reports around or is there an FTP Site from which they can be
downloaded ?
Thank you.
Frank Bacchus
720-7529
Export Report 2.5 to Excel
Subject: Export Report2.5 to Excel
Author: oraapps-l@cpa.qc.ca
Date: 7/22/99 3:07 PM
Hello all,
Have couple of questions on reports2.5
HRMS custom report(Orcl apps)
1.I need to add a value called `all' to parameter list, So that user
could able to run the report
either for all the cost centers or for one cost center.
2. Also need to write/export report out put/ report to a excel
spread sheet.
Is this possible ? Is there any pkg available like TEXT_IO in
reports to do this?
Any help in this matter would be appreciated.
Thanks in advance
suma
Date: Fri, 23 Jul 1999 14:24:30 -0300
From: Jeff Preston Jeff.Preston@moncton.org
Subject: RE: Export Report2.5 to Excel
Hi Suma
The text_io package will allow you to output directly to an excel
spreadsheet, we do it all the time.
Place the following code in your after parameter form report trigger.
myfile TEXT_IO.FILE_TYPE;
begin
myfile := TEXT_IO.FOPEN(:DESNAME,'w');
TEXT_IO.PUT(myfile,'Item Class Lookup Code');
TEXT_IO.PUT(myfile,CHR(9));
TEXT_IO.PUT(myfile,'Item Description');
TEXT_IO.PUT(myfile,CHR(9));
TEXT_IO.PUT_LINE(myfile,'Line Total');
This code will create the file and create the headings
Then in the repeating frame trigger place the code that writes the data
function R_G_ITEM_CLASS_LOOKUP_CODEForm return boolean is
myfile TEXT_IO.FILE_TYPE;
begin
myfile := TEXT_IO.FOPEN(:DESNAME,'a');
TEXT_IO.PUT(myfile,:ITEM_CLASS_LOOKUP_CODE);
TEXT_IO.PUT(myfile,CHR(9));
TEXT_IO.PUT(myfile,:ITEM_DESCRIPTION);
TEXT_IO.PUT(myfile,CHR(9));
TEXT_IO.PUT_LINE(myfile,:line_total);
TEXT_IO.FCLOSE(myfile);
return (TRUE);
end;
Hope this helps
Jeff
Bitmap report via Reports
From:
James.Walker@blackwell.co.uk
10/13/99 9:00 PM
Subject:
[orafin] Printing a bitmapped image via Financials Reports 2.5
To:
orafin@mail-list.com
We're trying to print a bitmapped image of our logo on our Customer
Statement. It looks OK in Designer but when run through Financials the
image does not show. Any ideas?
10.7 SC Prod16.1 on 7.3.3.5 SUN/Solaris 2.6
From:
Swaminathan S swami@irs.co.id
10/14/99 7:44 AM
Subject:
RE: [orafin] Printing a bitmapped image via Financials Reports 2. 5
To:
orafin@mail-list.com
Hi James,
For Printing a bitmapped image from Apps :
First of all in your Report designer make this bitmap file as a link file
(ensure that the bitmap file is in the same directory as your report). so
that path is not required.
Ftp this bitmap file in your srw directory.. in Unix.
Try it out..Now it will run perfectly..
We are also on 10.7 SC Sun Solaris
Hope that helps..
Regards.... Swaminathan
From:
James.Walker@blackwell.co.uk
10/14/99 4:06 PM
Subject:
RE: [orafin] Printing a bitmapped image via Financials Reports 2. 5
To:
orafin@mail-list.com
Swaminathan - This did the trick, Many Thanks!
We edited the Shortcut for Designer to start it in the directory that held
the report and the bitmap.
Report as a Concurrent Programme from another Prog
Date: Wed, 6 Oct 1999 07:37:24 -0700 (PDT)
From: Rajesh TL priyarajesh@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: Reports as a Concurrent Program from another
Hi
I have a Oracle Reports Pgm that I registered
as a Concurrent Program (Con Pgm A).
The report runs and displays as desired when
I execute the same as a concurrent program.
The requirement is that another concurrent
program (Con Pgm B) does some DML and Calls
Con Pgm A through
FND_REQUEST.SUBMIT_REQUEST
The same report when launched through the
FND_REQUEST function from Con Pgm B displays the
report with some '|' like characters (mostly)
in the start of each line,
I have a feeling that Con Pgm A does not default
some Height/Width Settings from Con Pgm A settings
when called from Con Pgm B.
Has anyone encountered this .
Please throw some light
Thanks and regards
Rajesh
Special Copy File Feature
Date: Thu, 28 Oct 1999 15:14:05 -0700 (PDT)
From: Syed Ali wajid_us@yahoo.com
Subject: Special Copy File
Hello Everyone,
I am working in envirnoment
OS : UNIX Solaris 5.6
App.Ver : Rel 11.0.2.
RDBMS : SQL 8.0.5
Tools : Developer 2000 (Reports 2.5)
I am creating a NEW report using Reports 2.5 and
registering into Application it is running perfectly
and I can see the output also by clicking VIEW OUTPUT.
But If I want to transfer this file into a Browser
(Netscape) using SPECIAL-->COPY FILE (within VIEW
OUTPUT) it is giving me a ERROR FRM:40735 Special 1
Trigger Raised DATA_NOT_FOUND.
On the Other hand Oracle Reports are running perfectly
and you can use SPECIAL-->COPY FILE to see the output
in Netscape Browser. The problum is with the new
reports only.
Did anybody know about this problum?
Thank you in Advance. Your earliest reply is highly
appriciated.
Regards,
WAJID.
Date: Thu, 28 Oct 1999 15:22:04 -0700
From: "Catherine Gauchat" catherine_gauchat@tcibr.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Special Copy File
We are having the same problem in an NT environment. We are using the
same database and application versions as you. Oracle tells me that
Special Copy File doesn't work with custom reports. I have a couple of
people about it but they haven't had any success either.
I would also like to know if it is working for anyone.
Catherine
Date: Tue, 2 Nov 1999 14:22:56 -0800 (PST)
From: Syed Ali wajid_us@yahoo.com
To: oraapps-l@cpa.qc.ca
Cc: catherine_gauchat@tcibr.com
Subject: Re: Special Copy File
We have open a TAR with oracle regarding this issue.
They have send us a Patch (BUG fnd 770147) that has
resolved this problum. Our TAR number was 1006052.999
under Metalink.
Regards,
WAJID.
Date: Mon, 1 Nov 1999 22:22:35 -0000
From: "Jonathan Stuart" jdstuart@globalnet.co.uk
To: oraapps-l@cpa.qc.ca
Subject: Re: Special Copy File
Catherine,
Special Copy File does work with custom reports however there is a bug in
the Define Concurrent Program form which will prevent it from working. When
a new concurrent program is defined as having 'Text' output the record in
the database will contain the string 'Text' rather than 'TEXT' in the
appropriate column. When a concurrent job is run the output type is also
stored in the requests table. If you try and do a Special File Copy and the
output type is not valid (i.e. it is 'Text' not 'TEXT') you will get the
error you describe. The solution to this is to change the column in the
table storing the definitions so that any occurrence of 'Text' is changed to
'TEXT'. From then on when you run those reports you will be able to use Copy
File and it will work. If you do this remember to make the change again
after any further concurrent jobs are defined. To Copy File any jobs you
have already run make the same change in the FND_CONCURRENT_REQUESTS table.
Regards,
Jonathan.