ORACLE APPLICATIONS ARCHIVES

Topicwise collection of
Postings on Mail Lists
ON
ORACLE APPLICATION REPORTS

Report Set Error

Date: Fri, 19 Mar 1999 10:49:47 +0100
From: Anand.Tondapu@gemplus.com
To: oraapps-l@cpa.qc.ca
Subject: Report Set Error

When I try to run a report set, gives error message Attempting to reserve record for update or delete (^C to cancel) Help/Error gives APP-00810 Cannot set value for field * :PROGRAM.LAST_SUBMISSION_DATE Does any one know what it means. Thanks for your valuable input. Anand

Report output in Excel

Date: Tue, 23 Mar 1999 12:29:19 MST
From: "Jayakumar J" jjayakumar@hotmail.com
Subject: Re: Urgent! Reports Gurus!

Urgent! Reports Gurus! We have a unique requirement.
We are implementing the Oracle Financial Applications(GL,AP,AR,FA) [10.7 GUI, Prod16.1]
Our Specific requirement is as follows: -
Report output has to be generated in Excel file format in Account Payables Module. The report name is Expense Distribution Detail Report. We are using 10.7 SC. I heard about report ADI. Is ADI or something can be used for AP module for generating the output into Excel file.

Appreciate your help regarding this? With regards, Jay. 23-March-1999. Phone : (206) 447-7950 Ex. 4156

Date: Tue, 23 Mar 1999 12:11:32 PST
From: "usha lakshmi" laks67@hotmail.com
Subject: Re: Urgent! Reports Gurus!

Hi I have heard of ADE not ADI thru which you can load data from Oracle HRMS or Oracle Training Administration into a spreadsheet. If you don't get anything else , do get back to me because I have a work around.

Suraj

Scheduling of Reports

From: Sbala [mailto:SBala@corpacctpo.hyatt.com]
Sent: Wednesday, March 24, 1999 8:40 AM
Subject: Scheduling of Reports - Urgent

Queries regarding the scheudling of reports in AP

1. When I schedule the Payment Register report to run everyday, for the parameters start date and End date , I have assigned the Current date as the default value. The first day, it takes the current date ex: 24-March-99 and when the report runs the next day, for the start date and the End date it does not assign the 25-March-99 as the current date. It still takes the 24-March-99 as the date parameters. Is there any way by which we can assign the current date for the parameters when the report is generated everyday.

2. We want to schedule a couple of reports to run every Tuesday and Thursday. Is there any option or workarounds to do so.

TIA Kumar

Date: Wed, 24 Mar 1999 09:52:06 -0600
From: "Logan, Ernie"
Subject: RE: Scheduling of Reports - Urgent

This is a known limitation of 10.7 and below concurrent managers. I believe this has been addressed in R11. At least it looks like it has, but I haven't tested that yet.

---
Date: Wed, 24 Mar 1999 11:36:18 -0500
From: "Palad, Ed" EdPalad@firstusa.com
Subject: RE: Scheduling of Reports - Urgent

Kumar, Have you tried using :
Default Type : SQL Statement
Default Value : select to_char(sysdate,'DD-MON-RR') from dual
For both Start and End dates.
I am not not able to test because my test box is down. Just an idea. Let me know if it works. Thanks a lot in advance.

Ed Palad Consultant Oracle Financials, First USA (302) 985-8591 EMail - EdPalad@FirstUSA.com

Reports to the Web

Date: Mon, 29 Mar 1999 13:08:10 -0700
From: Deborah Linke linke@wapa.gov
Subject: Re: Reporting

Michael, we have used Discoverer to deploy reports on the Web, and it's worked fairly well for us.

"Bartoletti, Michael" BartolMi@rf.suny.edu 03/29 11:47 AM

What is the module/functionality that would allow you to deploy Oracle reports to the web? We are looking for something that would allow for functionality based on user sign on. I know the functionality could be programmed through forms, but is it easy to deploy the reports out to the web like the forms through the Forms Server? Please let me know.

Michael Bartoletti The Research Foundation of State University of New York bartolmi@rf.suny.edu

x-------------x

Date: Thu, 6 May 1999 19:59:22 -0400
From: "Robert Deem" rdeem@digital.net
Subject: RE: ' Running Reports from the Web'

Try this syntax:
http://owsservername:port/r25ows?server=repserver1.world+report=test.rdf +userid=scott/tiger@oracle_home+destype=cache+desformat=html

Make sure that your webcache and reports cachedir point to diffrent cache directories. Also, make sure that your listener points to the same virtual and physical directories as your Reports25_WEB_LOC and Reports25_WEB_LOC_TRANSLATED.

you can also check to make sure that the report server is functioning by running the r25cli32 executable.

You can also try to use desformat=pdf.

Reports directly to mailbox

--- Mark Cymerman MCymerman@DOMINOAMJET.com wrote:

Oracle Apps 11 HP/UX 11.0 I've created a printer that sends report request directly to my e-mail system(Problem #1036586), however I have to hard code the name in - printer - driver -define (mail mcymerman@dominoamjet.com $PROFILES$.FILENAME). Is there a way I can pass the user name or have the system prompt for the e-mail address? Any help would be greatly appreciated.

Thanks Mark Cymerman Domino Amjet, Inc.

Date: Wed, 31 Mar 1999 07:02:22 -0800 (PST)
From: Andy Schindler aschindl@yahoo.com
Subject: Re: Mail

Mark, I have done this a number of times. However, I created a host script (/usr/local/bin/apps_email) and passed the parameters TITLE and FILENAME. In the script, I parsed the title (ASCHINDL.123456) to get the user name and the request id.

With this extra information, I could format the email nicely and send the report to the person who issued the concurrent program.

HTH Andy Schindler NRC, Inc.

Date: Wed, 31 Mar 1999 09:27:21 -0600
From: "Shockey, David" DShockey@jwrinc.com
Subject: RE: Mail

I haven't tried this yet but an earlier message in this list gave the following solution. You put this command in the Oracle Apps driver in the command line (this usually has the lp or lpr command).

mailx -s subject user file_name

This is supposed to send the file as an attachment. There was a follow-on message that used the uuencode command instead.

Date: Wed, 31 Mar 1999 16:09:03 PST
From: "usha lakshmi"
Subject: Re: Mail

Hi Hi You can define the email address of the user in the user setup in system administration. Then create a profile variable (say USER_EMAIL) in the application developer responsibility. In the default definition of the variable write an sql which fetches this email address column with join condition fnd_user.user_name=$PROFILES$.USER_NAME. Use this profile variable in your printer driver definition as the destination as ($PROFILES$.USER_EMAIL). This surely works. Suraj

Reports Ouput needed in PDF format

From: usha lakshmi [SMTP:laks67@hotmail.com]
Sent: Thursday, April 01, 1999 4:56 PM
Subject: Reports Ouput needed in PDF format

Hi I need to generate PDF output for some reports. When I give 'VERSION=2.0b DESFORMAT=PDF ORIENTATION=PORTRAIT' and run the report, I get an error message 'REP 1800 Formatter Error'

Can anyone help me on this

Thanks in Advance Suraj

Date: Fri, 2 Apr 1999 11:43:12 -0500
From: "Vallapareddy, Krishna" kvallapareddy@noblestar.com
Subject: RE: Reports Ouput needed in PDF format

You could get the report output in ASCII format if the report is run as a character mode report or the report output comes in postscript if the report is run in bitmap mode. The postscript output can be changed to pdf format by using ADOBE DISTILLER. Hope this helps.

Regards, Krishna Vallapareddy Oracle Financials Consultant Noblestar Systems Corporation (703) 464-4000 ext 2508 or (800) 470-4668 ext 2508 http://www.noblestar.com

Date: Sun, 4 Apr 1999 11:06:53 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Reports Ouput needed in PDF format

Apologies if my answer is not accurate. I will be doing this from memory as I am not connected to my site at the moment. The setup of reports in PDF format is quite straight forward but there are several steps.

* If you are on 10.7 of the apps there are required patches. Minimum AOL patch set A

* When defining your reports the only option required is
OUTPUT_FORMAT3DPDF

* You need to place an entry as the bottom of the uiprint.txt(?) file in $ORACLE_HOME/guicommon/tk22/admin and the printer must be an existing system printer.

The formatter error indicated that it is the entry in the uiprint.txt file which is missing or has an error.

Graham.

From: Shamica Wakade [SMTP:shamica@sohm.soft.net]
Sent: 04 April 1999 10:23
Subject: Re: Reports Ouput needed in PDF format

Hello, Where do I define this parameter . Could you please be little elaborate on this.

I don't have this tk22/admin directory under guicommon. Shamica.

Date: Tue, 6 Apr 1999 09:16:20 +0100
From: Graham Duggan gjduggan@mail.com
Subject: RE: Reports Ouput needed in PDF format

It is not a parameter but rather an extra line in a file. By the way it should have been tk23, bit of a typo there. Just have a hunt around for the uiprint.txt file. That is the important bit. The file gives a reasonable explanation of what an entry should look like in the header and example.

Graham.

Printing multiple currency symbols in reports

Date: Fri, 2 Apr 1999 12:17:17 -0500
From: "Vallapareddy, Krishna" kvallapareddy@noblestar.com
Subject: RE: UGRENT !!!multi currency - Printing of multiple currency symbols

At the Org level it may not be possible to print the currency symbol for all the reports, but actually formating like the ',' or '.' can be set and is actually a feature with every standard Oracle Report. But individually for specific reports you can format the fields in the report layout to accept the currency symbol.

-----Original Message-----

From: JANAKI ALLU [SMTP:janaki_oracle@hotmail.com]
Sent: Friday, April 02, 1999 10:40 AM
Subject: UGRENT !!!multi currency

HAI FRIENDS , do anybody have idea how to print various currency symbols in reports for multiorg.do oracle reports supports it ?? please could anybody answer this !!! thanks

User Name on Reports

Date: Wed, 7 Apr 1999 17:31:28 +0530
From: amareesh amareesha@sohm.soft.net
Subject: Printing User Name

Hi, How can I print the application user name in my reports.

Thanks Amar

Date: Wed, 7 Apr 1999 13:21:01 +0100
From: "Mahendra, Anil" Anil.Mahendra@ncp.co.uk
Subject: RE: Printing User Name

Have a look at the package FND_GLOBAL

You're probably looking for the USER_NAME function

Modifying Std. Report

From: Poddar, Venkatesh [mailto:PoddarV@usa.redcross.org]
Sent: Monday, April 05, 1999 3:31 PM
Subject: Error modifying standard report

I get the following error modifying standard report. REP - 0729 . Prog Unit 'c_trans_debitformula' of size 97651 bytes too big for current platform at the limit of 65023. I cannot open the report in Reports 2.5 to modify it. Any suggestions ?

You can reach me at 703-206-6343.

Venky

Date: Wed, 7 Apr 1999 12:01:52 -0400
From: "Jain, Dhiraj" djain@kpmg.com
Subject: RE: Error modifying standard report

You need to use X windows to open this report. Windows NT and 95 cannot open reports with a big program unit.

Hope this helps. Regards, Dhiraj Jain KPMG LLP (312) 6651941 (Voicemail -- Chicago) (516) 8033984 (Cablevision) (888) 6946991 (pager)

Blank Pages

Jay Patel jpmrp@yahoo.com wrote:

All:
We have a custom report that runs every 15 minutes. If the data it is looking for does not exist, it generates a blank page and prints a blank page. We could print "No Data Found" on the report, however, we would like not to print anything if no data is found. The file size is 0KB. Is there a way in reports, or Oracle or Unix to stop this from printing ???

Thanks in advance for any suggestions... Jay

Date: Wed, 7 Apr 1999 15:43:36 -0700 (PDT)
From: rathan babu rathanb@yahoo.com
Subject: Re: Report - Blank Pages

Hello
I just created test report, PROBABLY you can use raise srw.program_abort; built-in, include that line exactly where you are conditions is failing, in other words, where you code returns no data. I am not able to imazine how your report works.

Quickly, What I did is that create a simple query

select * from emp where deptno deptno not in ('10','20','30')
which always retuns no rows,
created a summary colunm to count the number of empno's fetched at report level. I coded on format trigger of outermost frame in the layout,

if :cs_1 0 then
raise srw.program_abort;
return (false);
else
return (TRUE);
end if;

It aborts insted of running further, so, no output generated, I know this is kind of weird programming, If this works for you that fine. This is my input.

Note: I have not tested how it responds in by registering in to apps. Probably, it may give some error, I have not checked.

Rathan Babu.

Saving Reports

From: Bharat Patel[SMTP:bpatel@DOMINOAMJET.com]
Sent: Friday, April 09, 1999 2:14 PM
Subject: report questions

hi, Guys I created a custom reports and then I tried to do some modification in the on of the group query. I was able to save it at the query dialog box but once I tried to save the report it gives me an error as below:-

REP-1051; Unable to save module to file
/uo1/app/bom/11.0.28/reports/file_name.rdf
REP-1070: Object store failure occurred.
any ideas why? thanks in advance. Bharat Patel D.B.A. bpatel@dominoamjet.com 847-244-2501 ex 1249

Date: Fri, 9 Apr 1999 15:32:51 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: report questions

I get the same error too when I try to save a file. I think it is the permission settings for the file you are trying to open. Meaning it is read only. The way I get around is do a save as and save the file as a different name. This will allow you to update it. But I then have to copy this to original (the one you can't save) from the UNIX prompt. Or change the permissions on the file. Beth Carver

Report Size

From: Mary Anderson[SMTP:MaryA@sodak-gaming.com]
Sent: Friday, April 09, 1999 2:09 PM
Subject: Oracle Reports - Margin Analysis Page size

I am customizing the Margin Analysis Report, and we would like the report to use the full page (the seeded report prints landwide using about two-thirds of the page). I have had no luck in printing more rows per page. The report editor "Report Properties" form specifies a Report Width and Height of 180x66; the Concurrent Program definition uses a 180x65 landwide style; the print style for landwide uses 180x65. I have tried all sorts of frame sizes and settings on the body of my report (variable, expand, fixed). Any suggestions would be appreciated. Thanks, Mary

Date: Fri, 9 Apr 1999 16:14:23 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: Oracle Reports - Margin Analysis Page size

Try the frame settings that the fields appear in make sure those frames are all expandable. If this does not fix it you might try the printer settings to see how many lines per page the printer prints. Beth Carver

Date: Fri, 9 Apr 1999 15:19:19 -0600
From: Mary Anderson MaryA@sodak-gaming.com
Subject: RE: Oracle Reports - Margin Analysis Page size

Thanks for the help. The frames are all expandable or variable. Our other Landwide reports print the desirable length. I am wondering if it has something to do with the summary areas? Mary

Parameter Settings

From: Mohan_Rajaganapathy@notes.seagate.com
[SMTP:Mohan_Rajaganapathy@notes.seagate.com]
Sent: Sunday, April 11, 1999 11:03 PM
Subject: Parameter Query

Hai everybody,
Iam a fresher in Oracle Apps. So I have a small problem.
I want to create a parameter in Oracle Reports when has only 2 values Yes - Y or No-N.

Infact this is a summary flag and based on this i have to print my summary Information.

My question is how do i do this in Oracle Apps ?

Thanks in Advance Mohan

Date: Mon, 12 Apr 1999 11:13:41 -0400
From: "Vallapareddy, Krishna" kvallapareddy@noblestar.com
Subject: RE: Parameter Query

you can have a independent value set attached to the parameter and you have to define the two values 'yes' and 'no' for the value set.

Krishna Vallapareddy Oracle Financials Consultant Noblestar Systems Corporation (703) 464-4000 ext 2508 or (800) 470-4668 ext 2508

Date: Tue, 13 Apr 1999 08:36:45 +0000 (GMT)
From: "SAURABH K. DESHMUKH" saurabhk.deshmukh@tatainfotech.com
Subject: Re: Parameter Query

you can create an invisible field, value for which comes from the parameter(Y/N) and check the flag in 'after parameter' trigger.

hope that should work....

Adding custom reports to Note Usage's

Date: Fri, 16 Apr 1999 08:18:38 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: Adding custom reports to Note Usage's

Hello
I have created a custom report and would like to create note usage's for this report. However when I create my note usage and go to add reports to this usage my custom report is not in the pick list. I called Oracle support and they have not given me answer. Does anybody know how to get custom reports into this pick list? Beth Carver

From: Carver, Elizabeth[SMTP:ecarver@MarkAndy.com]
Sent: Friday, April 16, 1999 6:52 AM
Subject: RE: Adding custom reports to Note Usage's

I did find a dirty way to do this. You will need to add a record into SO_NOTE_USAGE_ATTRIBUTES. This will put your custom report into that note usage. However you are still unable to get that report in the pick list. It's a start. Beth Carver

From: Rupert Gonzales[SMTP:t_rupert_g1@Verifone.com]
Sent: Friday, April 16, 1999 12:47 PM
Subject: RE: Adding custom reports to Note Usage's

The query for that Pick List is:

select description, report_id from so_reports where report_id in (1,3,5,6,8) order by description

DESCRIPTION---------------------------------REPORT_ID
------------------------------------------- ---------

Bill of Lading---------------------------------1 Commercial Invoice------------------------------3 Pack Slip---------------------------------------5 Pick Slip---------------------------------------6 Sales Order Acknowledgement---------------------8

If you really want to see your report on the pick list then you need to put your report in so_reports, so_report_parameters, and so_report_usages and create a custom form modification of OEXNTDNU.fmb (Note Usages) and change the LOV, to include your report_id, for column Report.

But if your custom report is a customization of one of the above standard reports then you don't have to modify the form. Just use the existing Pick List and retrieve the notes using the standard report name.

Date: Fri, 16 Apr 1999 14:10:16 -0500
From: "Carver, Elizabeth" ecarver@MarkAndy.com
Subject: RE: Adding custom reports to Note Usage's

Thank You!!!!

Beth Carver

Modify UNIX reports with NT

From: pkandra@civicdevelopment.com
[SMTP:pkandra@civicdevelopment.com]
Sent: Wednesday, April 07, 1999 1:42 PM
Subject: RPT: How to modify UNIX reports with NT

Can anyone please tell me all of the necessary steps to modify a UNIX reports 2.5 file with the NT version of reports 2.5 ? I get the file from Unix, open it with NT and I always get a 'There exist uncompiled program unit(s)'. I know I'm missing a step, I just don't know what.

Thanks in advance Peter Kandra pkandra@civicdevelopment.com

--- "Vallapareddy, Krishna" kvallapareddy@noblestar.com wrote:

This problem usually arises when there are any program units like libraries attached to the report. The rdf file stores a link (path) to the library files which are used in the report. When you ftp the rdf file from unix to NT ,you are not able to make a connection to the library files still on the Unix system and so the program units cannot be retreived as you open the report on the NT side. What I would suggest is that you open the reports using any X-Windows software on the unix side. You could use the command ar25desb at the $ prompt.

If you are uncomfortable with working on X-Windows, then just make whatever modifications you need to the report on the NT side without bothering about the error messages and then transfer the file back to the Unix system. Once on the Unix box, you could always open the original report which you copied and also open your modified copy(with X-Windows), then you can simply copy all the program units from the original to the custom report by drag and drop. You should be able to compile this way.

Well atleast it has worked for a lot of us. Hope this helps.

Good Luck, Krishna Vallapareddy Oracle Financials Consultant Noblestar Systems Corporation (703) 464-4000 ext 2508 or (800) 470-4668 ext 2508 http://www.noblestar.com

Date: Wed, 7 Apr 1999 12:19:30 -0700 (PDT)
From: thirumalai satish vt_satish@yahoo.com
Subject: RE: How to modify UNIX reports with NT

Hi Peter
Check also whether you have access to those libraries which you are using in the reports. Without access to the libraries also you might encounter such problem.

hope this helps. Satish Consultant Noblestar Systems 703-464-4000 x2749