Error running reports

There are many available reports in Oracle Apps so you can discuss the requirements related to these reports here.
Post Reply
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Error running reports

Post by lukman »

Hello,

I followed the steps in the doc that admin created to create and register reports in oracle apps but after running the request I got error. What's the problem and how to solve it? I copied the log below :

+---------------------------------------------------------------------------+
General Ledger: Version : 11.5.0 - Development

Copyright (c) 1979, 1999, Oracle Corporation. All rights reserved.

MODULE2 module: General Ledger Test Report 2
+---------------------------------------------------------------------------+

Current system time is 30-MAR-2007 20:26:17

+---------------------------------------------------------------------------+


+-----------------------------
| Starting concurrent program execution...
+-----------------------------

Arguments
------------
P_SET_OF_BOOKS_ID='289'
------------

APPLLCSP Environment Variable set to :

XML_REPORTS_XENVIRONMENT is :
/home/oracleapps/oracle/visora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb

XENVIRONMENT is set to: /home/oracleapps/oracle/visora/8.0.6/guicommon6/tk60/admin/Tk2Motif_UTF8.rgb


Current NLS_LANG and NLS_NUMERIC_CHARACTERS Environment Variables are :
American_America.UTF8

'.,'

Spawned Process 12310
REP-1212: Object 'Margin' is not fully enclosed by its enclosing object 'BEGIN_BALANCE_CR_BEQ'.

Report Builder: Release 6.0.8.25.0 - Production on Fri Mar 30 20:26:18 2007

(c) Copyright 1999 Oracle Corporation. All rights reserved.

Enter Username:
+---------------------------------------------------------------------------+
Start of log messages from FND_FILE
+---------------------------------------------------------------------------+
+---------------------------------------------------------------------------+
End of log messages from FND_FILE
+---------------------------------------------------------------------------+
Program exited with status 1
Concurrent Manager encountered an error while running Oracle*Report for your concurrent request 2736975.

Review your concurrent request log and/or report output file for more detailed information.


+---------------------------------------------------------------------------+
Executing request completion options...


Output is not being printed because:
The print option has been disabled for this report.


Finished executing request completion options.

+---------------------------------------------------------------------------+
Concurrent request completed
Current system time is 30-MAR-2007 20:26:19

+---------------------------------------------------------------------------+

Thanks.
akram1976
Posts: 1
Joined: Sun Jun 10, 2007 10:26 am
Location: Saudi Arabia

Post by akram1976 »

Dear,

If you find the solution for this problem please reply me,

Thanks
kareem2003
Posts: 40
Joined: Tue Jun 12, 2007 11:25 am
Location: India
Contact:

Post by kareem2003 »

in concurrent program u have
check box called PRINT option
anabled that check box
admin
Posts: 2073
Joined: Fri Mar 31, 2006 12:59 am
Location: Pakistan
Contact:

Post by admin »

First of all run the report in the report builder if it is showing output then use the same in apps. Such errors come when you manually modify/develop the report while not taking care the frames. thanks
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by lukman »

Hello,

After learn how to create report using TOAD and Oracle Reports Developer 6i I built my own sales order testing report and read the documentation of how to register report and printer.

Oracle E-Biz : 11.5.10.2
OS : Red Hat Linux Advanced Server 4 update 3
Printer : Epson LQ2170
Output format : PDF

Test to print the report definitely failed so I read Apps doc and found out that I need to setup DISPLAY before I can see my report in PDF. So I follow the doc.

Change DisallowTCP in gdm.conf to false

$ set DISPLAY=localhost:0.0

$ xhost +
got message :
<i>access control disabled, clients can connect from any host (now this message didn't exist in the doc but I go through)</i>

$ export DISPLAY=localhost:0.0

$ xhost + localhost
got another message :
<i> xhost : unable to open display "localhost:0.0"</i>

After that I tried to execute xclock and of course it won't work so I tried to set display again using hostname

hostname : vis.test.com

$ set DISPLAY=vis:0.0

$ xhost +
got message :
<i> unable to open display "localhost:0.0"</i>

$ export DISPLAY=vis:0.0

$ xhost + vis
got message :
<i> xhost : unable to open display "vis:0.0"</i>

xclock still didn't work so I tried to set display again
hostname : vis.test.com

$ set DISPLAY=vis.test.com:0.0

$ xhost +
got message :
<i> unable to open display "localhost:0.0"</i>

$ export DISPLAY=vis.test.com:0.0

$ xhost + vis.test.com
got message :
<i> unable to open X server 'vis.test.com:0.0'</i>

and still couldn't open xclock for testing

Now my questions are :
1. Because display setup doesn't work, should I change the gdm.conf back to #DisallowTCP=true or let it be?

2. in $ set DISPLAY=localhost:0.0, do I type it exactly or change it to my hostname (which is vis.test.com) so that it become $ set DISPLAY=vis.test.com:0.0 or $set DISPLAY=vis:0.0? I read in http://www.leidinger.net/X/xhost.html that using localhost is fine but it won't worked for me whether I used localhost, vis or vis.test.com.

3. What's the condition of application & database server before change display?

4. How to solve the display problem?


Thanks.
malahmad
Posts: 18
Joined: Mon Mar 05, 2007 1:29 am
Location: United Arab Emirates

Post by malahmad »

I face the same problem I check all the display setting after log time I found from where the error you have to login to the oracle application manager ten site map then auto config then click where the report host then click on the server then edit parameter
On search all --- display click on search

Just see the value must be

: 0.0

If there is any value before the: 0.0 you have to remove it and on the server type xhost +
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by lukman »

Thanks for your guide malahmad. I followed it and I found that the value is vis:0.0 instead of 0.0 so I must delete the vis:, right?

Suppose something happen and I can started my system, how do I undo that process? Thanks.

[quote]I face the same problem I check all the display setting after log time I found from where the error you have to login to the oracle application manager ten site map then auto config then click where the report host then click on the server then edit parameter
On search all --- display click on search

Just see the value must be

: 0.0

If there is any value before the: 0.0 you have to remove it and on the server type xhost +


<i><div align="right">Originally posted by malahmad
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by lukman »

Ok, I finally could solve my problem. Looks like the /etc/hosts file was wrongly setup. At first it was :

192.168.10.5
127.0.0.1
192.168.10.6
192.168.10.7

then I changed it to :

127.0.0.1
192.168.10.5
192.168.10.6
192.168.10.7

then after that I can setup the display.

For malahmad, after setup above I didn't need to change any parameter like you said, maybe it's another way to setup display?

Now I had another problem. I'm trying to setup my EPSON LQ-2170 printer in Oracle but I don't know the initialization and reset parameter. I already downloaded the information file from EPSON but couldn't find the information. I already searched in metalink and all I could find is Doc. ID 1011524.102 which I assumed that Oracle didn't support for LQ2170.

I tried settings below as my setup :

Arguments : lp -d$PROFILES$.PRINTER -n$PROFILES$.CONC_COPIES
Initialization : /e[!p
Reset : /e[!p

But the result was not as I expected. If any of you use EPSON LQ-2170, can you tell me the Arguments, Initialization and Reset parameters? Thanks
lukman
Posts: 170
Joined: Wed Aug 09, 2006 11:12 pm
Location: Indonesia

Post by lukman »

strange, somehow suddenly I couldn't view my report in pdf format and when I check I got information that xhost unable to display vis:0.0.

I tried to restart and setup more than 10 times then suddenly it can show the display again. anyone had experienced with this? thanks
Post Reply

Who is online

Users browsing this forum: No registered users and 0 guests