Left padded zeroes - convert to number
Date: Tue, 07 Sep 1999 19:18:40 GMT
From: "bharathi Yarlagadda" bharathi_d72@hotmail.com
To: OraApps-L@cpa.qc.ca
Subject: How to get LEFT PADDED zeroes to a number in reports 2.5
Hi All,
Can somebody tell me how to get Left PAdded ZEROES to a number
from SQL and from reports layout.
Thanks,
-chakrapani
Date: Tue, 7 Sep 1999 15:32:08 -0400
From: "Anil Shenoy" ashenoy@shiva.com
To: oraapps-l@cpa.qc.ca
Subject: Re: How to get LEFT PADDED zeroes to a number in reports 2.5
use tochar( cloumn_name, '9000000.00')
Hope this helps
Anil.
Date: Tue, 7 Sep 1999 15:02:25 -0500
From: "Mahesh Goyal" f2it@gte.net
To: oraapps-l@cpa.qc.ca
Subject: RE: How to get LEFT PADDED zeroes to a number in reports 2.5
select lpad(to_char(your_number),length,'0') your_string
from your_table
where your_condition
Please send a mail back, if you need more help.
enjoy.
Mahesh Goyal
Director, Oracle Implementation Services
Fast Forward Implementation Technologies Inc.
The Millenium Center
Suite 1750
222 W Las Colinas Blvd.,
Irving, Texas 75039
972.594.7777 Phone
972.594.7775 Fax
Email: mahesh.goyal@f2it.com
www.f2it.com
Scheduled Report Date
From: Melanie Jubinville [SMTP:Melanie.Jubinville@future.ca]
Sent: Thursday, 9 September 1999 2:44
To: Multiple recipients of list
Subject: AP URGENT-Scheduled Report Date
Hi,
We are currently on Version 10.7 Char. When we scheduled a report to run
weekly, the report date is always the day that the report was first ran
and
scheduled.
Is there a way to fix that problem ?
Thanks
Melanie
Date: Wed, 8 Sep 1999 22:30:19 -0400
From: "Satyakanth Abbaraju" satyakanth@mindspring.com
To: oraapps-l@cpa.qc.ca
Cc: "'Jim Crum'" jrcrum@mindspring.com
Subject: RE: AP URGENT-Scheduled Report Date
Hi,
I'm reproducing the following from OAUG's Tips and Techniques bi-monthly
publication (edited by Jim Crum). There might be a continuation of this one,
which I can find if you need more info, so let me know.
1. If you need to set my "Payables Transfer to General Ledger" program to
run each day at the same time, unfortunately, the parameters require a "Post
Through Date". This is a problem because if you set it up today to post
through TODAY, then each day it runs, it will only post through TODAY
when you had set up. One way out is to schedule Payables Transfer to
General Ledger monthly with a "post through" date of the last day of the
month. (R11? Read next tip).
2. If you are on Release 11, then it's a breeze. Release 11 has several cool
enhancements to Request Submission. One of them is the Schedule option
'Increment date parameters each run'. This enables you to schedule the
Payables Transfer to run at a specific time each day and have the Post
Through Date parameter increment to the current date. The catch here is that
if you want the Batch Name to include the date, you have to customize the
standard report parameter; this is not recommended. An alternative is to set
up a Request Set to run the program and define SQL statements for the Post
Through Date and Batch Name parameters.
Satyakanth
Date: Thu, 9 Sep 1999 05:42:44 -0700 (PDT)
From: Sri Kay sreekayam@yahoo.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AP URGENT-Scheduled Report Date
One way of donig this is to submit the report from a program using
FND_SUBMIT request. This way tou can control the date from the program.
We did this and it works.
Date: Thu, 09 Sep 1999 06:35:40 PDT
From: "Lakshmi Viswanath" lviswanath@hotmail.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AP URGENT-Scheduled Report Date
Can you please elaborate a little bit on how to submit thru FND_SUBMIT?
The work arounds for this so-called bug in 10.7, I have heard so far from
the forum are
a) Use CONCSUB to submit rescheduled jobs
b) Have somes sort of trigger update the row of this rescheduled job in
fnd_concurrent_requests with the current date.
c) Use periodic alerts thru Oracle Alerts.
It will be interesting to hear any other work arounds
Thanks,
Lakshmi.
Date: Thu, 9 Sep 1999 06:33:17 -0700
From: CFowler@littonapd.com
To: oraapps-l@cpa.qc.ca
Subject: RE: AP URGENT-Scheduled Report Date
Hi,
Another way is to use CONCSUB to submit the request. We use this way to
submit several different reports daily that require a date parameter.
I posted an example back on Aug. 19th.
Please click here for the
referred mail
Our environment is IBM AIX 7.3.4 10.7 16.1SC.
Candace
Date: Thu, 09 Sep 1999 11:02:04 -0400
From: Mohan Thanikanti mthanika@camail2.harvard.edu
To: oraapps-l@cpa.qc.ca
Subject: RE: AP URGENT-Scheduled Report Date
Hi,
Actually you can find about the Fnd_submit in Oracle Applications
Standard Manual.
Incase you did not find the manual....Please click here for furthere details
Currency Format mask
Date: Fri, 10 Sep 1999 14:11:00 +0200
From: "Blaise Rempteaux" brempteaux@auchan.com
To: oraapps-l@cpa.qc.ca
Subject: Currency format mask in report
Hello,
In a report, we want to display the amounts.
The format mask depends on the currency precision.
We use the user_exit FND FORMAT_CURRENCY
This is an example where we use the user_exit.
function CF_col_periode_1_DSPFormula return CHAR is
begin
SRW.REFERENCE(:CP_CURRENCY_CODE);
SRW.REFERENCE(:COL_PERIODE_1);
SRW.REFERENCE('19');
SRW.USER_EXIT('FND FORMAT_CURRENCY
CODE=":CP_CURRENCY_CODE"
DISPLAY_WIDTH="19"
AMOUNT=":COL_PERIODE_1"
DISPLAY=":CF_COL_PERIODE_1_DSP"');
RETURN(:CF_COL_PERIODE_1_DSP);
end;
We use the currency ESP. The precision is 0.
If the amount is for example 123, we display 123
If the amount is 123.456789, we display 123,46
We don't understand why we display 123,46 and not 123 (the precision is 0).
Has anyone has got an idea?
Blaise.
Multiple Reports with same parameter
Date: Sat, 23 Oct 1999 01:13:48 +0800
From: Eric lee cellolee@ctimail.com
To: oraapps-l@cpa.qc.ca
Subject: Report 2.5 Question
Hi
I just created two reports let say report A and B which take
information from AP_CHECKS_ALL and AP_INVOICE_ALL and both have the same
input parameter ( CHECK_NUMBER) , could I just run report A and in
report A calls a function call or something to run report B?
Please gives me some hints.
Thanks
Eric
Date: Fri, 22 Oct 1999 14:05:13 -0400 (EDT)
From: Balalji Sundaralingam CMCISSB@njtransit.state.nj.us
To: oraapps-l oraapps-l@cpa.qc.ca
Subject: Re: Report 2.5 Question - COMMON PARAMETER.
You could create a Report Set and assign those 2 reports to run one after
the
other.
You need to specify the shared parameter name (common to both the reports)
and
disable
the parameter for the second report only. This way, the user would need to
specify the
value only once for the first report and thru shared parameter concept, the
value gets
populated to the second report parameter automatically.
HTH
Bala.
Date: Fri, 22 Oct 1999 11:45:37 -0700
From: "Prasad Sanikommu" prasad.sanikommu@sentrol.com
To: oraapps-l@cpa.qc.ca
Subject: RE: Report 2.5 Question - COMMON PARAMETER.
Hi balaji,
can I pass the request id of the first report as a parameter to the second
report by this shared parameter concept.
If you have any idea can you please pass this on to me.
TIA
Prasad
Date: Mon, 25 Oct 1999 01:22:29 -0700
From: "Sadhwani, Suneel" SSadhwani@ea.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: Report 2.5 Question
Try using srw.run_report to call report B from report A .
Rgds
Suneel
Report output in custom directory
Date: Mon, 25 Oct 1999 12:15:47 +0800
From: cellolee@ctimail.com
To: oraapps-l@cpa.qc.ca
Subject: Report Question
Hi All,
When I submitt a request ( Report ) , there is an option of
saving output file. The output file will be save in Application /
Common/ Out directory. Could I have my output files saved in directory
other than the standard Common/ Out directory?
Thanks in advance
Eric
Date: Mon, 25 Oct 1999 09:29:57 -0400
From: "Subramani Thulasiram" subramani.thulasiram@acnenergy.com
To: oraapps-l@cpa.qc.ca
Subject: Re: Report Question
APPLCSF is the top-level directory in which the Concurrent Manager puts
log and output files. Change the path for this variable in the
environment_name.env file
to point to the new directory and restart the whole system again. The
above worked for me.Hope this helps.
Thanks
-Ram
Report as attatchment to Email - query 2
From: Venkatayogi, Swami [SMTP:SVenkatayogi@comintertech.com]
Sent: 27 October, 1999 7:42 AM
To: Multiple recipients of list
Subject: Report Output as an email attachment
Hi Gurus,
We have a requirement at our company where the outputs from reports need
to
be sent as
attachments to an email.I defined a printer driver whose arguments would
include the mail
command , but the report goes as body of the email rather than as an
attachment.
Can anyone please let me know what are the options available in Unix
(HP-UX
11.0)
to send email as an attachment and how do we include that in Oracle
Applications.
Any input is greatly appreciated..
Thanks and Regards
Swamy Venkatayogi
Commercial Intertech Corp.
Date: Wed, 27 Oct 1999 10:06:18 -0400
From: "Phillips, Brant" phillib@mps.bellhowell.com
To: "'OAUG Distributions'" oraapps-l@cpa.qc.ca
Subject: FW: Report Output as an email attachment
Swami,
The following sends a file as an attachment. Our E-Mail(Text) printer
driver has been configured to run this script:
filedate=`date "+%m%d%y"`
senddate=`date "+%x"`
sendtime=`date "+%X"`
report=`echo $1`
title=`echo $2`
username=`echo $3`
ux2dos $report /tmp/"$username".tmp
uuencode /tmp/"$username".tmp "$username".txt | mailx -ms "Oracle Report:
$title sent on $senddate at $sendtime" "$username"@mps.bellhowell.com
rm -f /tmp"$username".tmp
Hope this helps you. Any questions, feel free to ask.
Brant
Brant Phillips
Systems Consultant
Bell & Howell Mail & Messaging Technologies
GUI type reports
From: Newman, Kelly [mailto:Kelly.Newman@fishersci.com]
Sent: Wednesday, November 03, 1999 10:28 AM
To: Multiple recipients of list
Subject: GEN: GUI printing with NCA
We're running 10.7 NCA on a Solaris Server. Thus far, all of our custom
reports have been developed in character mode - - developed on Windows,
moved to the server to execute. Our brief attempts at producing some nicer
reports resulted in garbage when the report was executed from the
application. We're at a point where we have time to try some things. Does
anyone have any experience getting GUI type reports from a UNIX environment?
Can we produce these types of reports in our environment - is it possible?
What steps are we missing? The documentation is a little light here. Will
setting up the font alias file help us.
Date: Wed, 3 Nov 1999 12:47:46 -0600
From: "Logan, Ernie" Ernie_Logan@bmc.com
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: GEN: GUI printing with NCA
Yes, you can, and it's not that difficult.
1) "GUI" reports, assuming proper registration, are actually produced in
PostScript by the Oracle Apps. Therefore your printers must be postscript
capable.
2) You must create a custom driver with NO initialization or reset strings
specified.
3) Associate the custom driver with a custom printer type and style, and
register the postscript printer as that custom printer type.
4) uiprint.txt file in ORACLE_HOME/guicommon2/tk23/admin must be updated to
reflect the printer name. Instructions are found in the header of the file.
5) Register the report with Options set to 'Version=2.0B' without the
quotes. (That's a zero, btw) Associate the "GUI" report with the custom
printer style created previously.
You might also consider searching the OraApps archives for information on
this topic, as it has been well discussed before.
http://www.cpa.qc.ca/Lists/OraApps-L/Search The archives apparently have not
been maintained for recent postings, but you should be able to find some
good information on postscript printing from earlier postings.
Good luck.