ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
ORACLE APPLICATION REPORTS



Bit-mapped report on Windows NT Version 11

Date: Thu, 12 Aug 1999 13:34:54 +0100
From: rchalton@dunnes-stores.ie
Subject: AOL: Bit-mapped reports on Windows NT for Release 11

Help!

Trying to print a bit-mapped report. Have done the following...

Set up printer, style and driver combination w/o initialisation or reset strings, SRW driver PSL132, Columns 132, Rows 64.

Defined concurrent program to output as POSTSCRIPT and set 'Execution Options' field to 'VERSION=2.0b' and set style and printer to that defined above.

When running report to printer I get ERR REP-0826: Invalid printer driver 'xxxx' specified by DESFORMAT, where xxxx is the name of my printer. If I don't specifiy any printer I get ERR REP-0826: Invalid printer driver 'dflt' specified by DESFORMAT.

Any suggestions appreciated.
Thanks.


Date: Fri, 13 Aug 1999 09:04:06 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Bit-mapped reports on Windows NT for Release 11

Have you placed an entry in the
$ORACLE_HOME/guicommon2/tk23/admin/uprint.txt file. Does this entry name a printer that exists on your server.

Graham.


Date: Fri, 13 Aug 1999 10:39:20 +0100
From: rchalton@dunnes-stores.ie
Subject: RE: Bit-mapped reports on Windows NT for Release 11

There is no $ORACLE_HOME/guicommon2 directory.

Should there be one for tools on NT?
Thanks. Rob


Date: Fri, 13 Aug 1999 17:28:58 +0100
From: Graham Duggan gjduggan@mail.com
Subject: FW: Bit-mapped reports on Windows NT for Release 11

Sorry, I missed the NT bit. I really should pay more attention sometimes.

I had a look on one of the PCs we use here for development and could not see this directory.

My comment about the printer, if the queue does not exists or reports an error you get a message

REP-1800: Formatter error.
and
APP-00969 Program exited with status 1
APP-01125 Concurrent Manager got error running Oracle Reports for =
request xxxx

The uiprint.txt file I mentioned contains
# OSName:Type:Version:Long Name:Description File:
# The first field is the name of the printer.
# The second field is the type of driver
# The third field is the version of the type of printer driver
# The fourth field is a long description of the printer
# The fifth field is the printer description file to be used.

If this file is not configured properly I think you get the same errors as above so I now think that this is not your problem.

My next suggestion would be to check the existence and contents of the SRW drivers defined for your printer style in $FND_TOP/srw. What is the style you specify when you submit the report? Is it your postscript style?

Graham.


Date: Tue, 17 Aug 1999 12:03:14 +0100
From: rchalton@dunnes-stores.ie
Subject: Re: FW: Bit-mapped reports on Windows NT for Release 11

Thanks for your response - off yesterday so only now checking my mail.

The SRW drivers exist (in fact the report prints fine from Developer - but not from the application). The DESFORMAT parameter is dflt. I assume the the concurrent manager sets this based on the output type. If I do not specify any options at runtime (i.e. print to the screen) I get the message that DFLT is invalid. If I specifiy a printer I get the message that PSL132 is invalid.

Cheers. Rob


Date: Fri, 13 Aug 1999 09:59:33 -0700
From: McRaney Ronald-MCG32315 rmcraney@itexchsrv2.phx.mcd.mot.com
Subject: RE: Bit-mapped reports on Windows NT for Release 11

There is a paper Note:68408.1 on MetaLink that gives excellent write up on 'Set up Oracle Applications Bit Mapped report on Windows NT'. It appears you did not specify any 'Completion Options' on the request.

Cheers.


Date: Tue, 17 Aug 1999 12:15:24 +0100
From: rchalton@dunnes-stores.ie
Subject: RE: Bit-mapped reports on Windows NT for Release 11

Thanks for your response. I have read the note you mention and followed it to the letter. I have tried to run with completion options (selecting the Postscript printer) and without completion options. In the former case it fails telling me that "Invalid printer driver 'Oracleprt' specified by parameter DESFORMAT", where Oracleprt is my Postscript printer using driver PSL132; in the latter case it fails telling me that "Invalid printer driver 'dflt' specified by parameter DESFORMAT".

Rob.


Date: Sat, 14 Aug 1999 10:24:17 -0400 (EDT)
From: Madhu Sudan Dada dada@csee.usf.edu
To: Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: RE: Bit-mapped reports on Windows NT for Release 11

uiprint.txt and tk23 or tk21 need to find.

Madhu Sudna Dada


Date: Sun, 15 Aug 1999 19:51:18 +1200
From: Mark Healey MHealey@swichtec.co.nz
Subject: RE: Bit-mapped reports on Windows NT for Release 11

You will need to define your printer definitions fully i.e

\\printserver1\HPLaser

and when define you report your options setting under executable must be VERSION=2.0b

Thanks



Report Error 1219

Date: Fri, 13 Aug 1999 10:24:10 PDT
From: "KK Sridharan" kksridharan@hotmail.com
Subject: Report Error 1219

Hi ALL,

I am getting an error "REP-1219: object name has no size --- length or width is zero. But the same report is running without error thru Report Designer.

Please help me to resolve this problem..
Thanks and Regards
KKSRI


Date: Sat, 14 Aug 1999 07:25:23 PDT
From: "prasad surisetty" surisettyp@hotmail.com
Subject: Re: Report Error 1219

INCREASE THE SIZE OF THE OBJECT. It should work.



A Basic report for Invoice information and Salesperson

Date: Tue, 17 Aug 1999 00:34:15 -0400
From: Sara Nigbor 105312.414@compuserve.com
Subject: Report Help

Hi. Am new to Oracle Apps. My customer needs to produce an Report that lists basic INvoice information (Order #, etc) along with the Salesperson.

This sounds very simple but cannot find a vanilla report for it.

Any help would be appreciated! Suresh
Please reply to 105312.414@compuserve.com
THANKS!!!


Send Report as an attachment to an email

Date: 17 Aug 99 12:18:37 EDT
From: SUNIL SHARMA sunil-k-sharma@usa.net
To: oraapps-l@cpa.qc.ca
Subject: sending email of report output

Hi guys,

i am sending report output on email but it is coming as the part of the body.

script i am using is the shell script, that is the part of printer definition, in the argument column of the define driver screen. that is

#/bin/ksh
email_addr=$2@hotmail.com
mailx -s "$3" $email_addr $1
exit 0

$1 filename
$2 email id
$3 subject/title of the report

we are on Digital 4.0.D unix. and APPS 10.7 SC 16.1

dis you have any idea how can we send this file as attachment in place of body.

regds and TIA sunil


Date: Tue, 17 Aug 1999 13:54:03 -0400
From: "Kurylo, Mary" Kuryma@consumer.org
To: "'oraapps-l@cpa.qc.ca'" oraapps-l@cpa.qc.ca
Subject: RE: sending email of report output

try

uuencode filename name of attachment | mailxor elm -s "e-mail
subject" e-mail recipient
uuencode $1 $1 | mailx -s $3 $2

I use this to send a Word document when an certain alert fires. You may have to specify the entire path of the filename and mailx (in my case its /usr/local/bin/elm).

Mary Kurylo
Applications Development Analyst
Consumers Union of US Inc.
kuryma@consumer.org


Date: 17 Aug 99 15:50:55 EDT
From: SUNIL SHARMA sunil-k-sharma@usa.net
To: oraapps-l@cpa.qc.ca, Multiple recipients of list oraapps-l@cpa.qc.ca
Subject: Re: [RE: sending email of report output]

Hi mary,

i tried, still the report output is showing in the body of the email, not as attachment.

regds and TIA
sunil