How to setup Apps. to get reports' output in PDF.
-
- Posts: 5
- Joined: Tue Dec 05, 2006 4:56 am
- Location: Pakistan
How to setup Apps. to get reports' output in PDF.
Hi All,
I am a new member of the group, working as Oracle Apps. Consultant in a reputed company.
I did not find any stuff regarding my problem on erpstuff.com, thats why i am posting the issue here.
Can anyone, plz, let me know of the detailed step by step process to setup Oracle EBS 11.5.9 for viewing reports' output in Acrobat reader directly when I press the View Output button on Requests Window? I will be grateful for a prompt and detailed response.
I am a new member of the group, working as Oracle Apps. Consultant in a reputed company.
I did not find any stuff regarding my problem on erpstuff.com, thats why i am posting the issue here.
Can anyone, plz, let me know of the detailed step by step process to setup Oracle EBS 11.5.9 for viewing reports' output in Acrobat reader directly when I press the View Output button on Requests Window? I will be grateful for a prompt and detailed response.
-
- Posts: 26
- Joined: Fri Nov 10, 2006 3:15 am
- Location: India
-
- Posts: 5
- Joined: Tue Dec 05, 2006 4:56 am
- Location: Pakistan
Dear Admin,
I already know all the things mentioned in "Custom Reports Integration 11i.doc" and those do not resolve my problem, further I have done the steps mentioned in "7.3 Setting Display" of the Apps DBA doc but getting the same
"
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
"
Errors. Can u plz suggest some other solution.
Dear Habibi,
The thing you mentioned is just a part of the whole pic.
Dear Azeez,
You cant get the built-in reports' output in .xls, how ever you can in case of and FSG report. Follow the steps,
1. Generate the FSG report in TAB DELIMITED format.
2. View the report output in report viewer and then go to Tools->Copy File and SAVE AS "File name.txt"
3. Open MS Excel and open the File name.txt in it, it would show you the import wizard, just press FINISH.
For built in reports, you can pick up their .rdf from server and save the query out of them. Run the query in TOAD and then save the out put in excel.
Hope it would work.
I already know all the things mentioned in "Custom Reports Integration 11i.doc" and those do not resolve my problem, further I have done the steps mentioned in "7.3 Setting Display" of the Apps DBA doc but getting the same
"
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
"
Errors. Can u plz suggest some other solution.
Dear Habibi,
The thing you mentioned is just a part of the whole pic.
Dear Azeez,
You cant get the built-in reports' output in .xls, how ever you can in case of and FSG report. Follow the steps,
1. Generate the FSG report in TAB DELIMITED format.
2. View the report output in report viewer and then go to Tools->Copy File and SAVE AS "File name.txt"
3. Open MS Excel and open the File name.txt in it, it would show you the import wizard, just press FINISH.
For built in reports, you can pick up their .rdf from server and save the query out of them. Run the query in TOAD and then save the out put in excel.
Hope it would work.
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
-
- Posts: 5
- Joined: Tue Dec 05, 2006 4:56 am
- Location: Pakistan
-
- Posts: 26
- Joined: Fri Nov 10, 2006 3:15 am
- Location: India
[quote]Dear Admin,
I already know all the things mentioned in "Custom Reports Integration 11i.doc" and those do not resolve my problem, further I have done the steps mentioned in "7.3 Setting Display" of the Apps DBA doc but getting the same
"
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
"
Errors. Can u plz suggest some other solution.
Dear Habibi,
The thing you mentioned is just a part of the whole pic.
Dear Azeez,
You cant get the built-in reports' output in .xls, how ever you can in case of and FSG report. Follow the steps,
1. Generate the FSG report in TAB DELIMITED format.
2. View the report output in report viewer and then go to Tools->Copy File and SAVE AS "File name.txt"
3. Open MS Excel and open the File name.txt in it, it would show you the import wizard, just press FINISH.
For built in reports, you can pick up their .rdf from server and save the query out of them. Run the query in TOAD and then save the out put in excel.
Hope it would work.
<i><div align="right">Originally posted by Bilal Ahmad Qureshi
I already know all the things mentioned in "Custom Reports Integration 11i.doc" and those do not resolve my problem, further I have done the steps mentioned in "7.3 Setting Display" of the Apps DBA doc but getting the same
"
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
Xlib: connection to "ebs:0.0" refused by server
Xlib: No protocol specified
REP-3000: Internal error starting Oracle Toolkit.
REP-3000: Internal error starting Oracle Toolkit.
"
Errors. Can u plz suggest some other solution.
Dear Habibi,
The thing you mentioned is just a part of the whole pic.
Dear Azeez,
You cant get the built-in reports' output in .xls, how ever you can in case of and FSG report. Follow the steps,
1. Generate the FSG report in TAB DELIMITED format.
2. View the report output in report viewer and then go to Tools->Copy File and SAVE AS "File name.txt"
3. Open MS Excel and open the File name.txt in it, it would show you the import wizard, just press FINISH.
For built in reports, you can pick up their .rdf from server and save the query out of them. Run the query in TOAD and then save the out put in excel.
Hope it would work.
<i><div align="right">Originally posted by Bilal Ahmad Qureshi
-
- Posts: 26
- Joined: Fri Nov 10, 2006 3:15 am
- Location: India
-
- Posts: 615
- Joined: Mon Sep 18, 2006 1:32 am
- Location: United Arab Emirates
- Contact:
Hi,Mr Pasha ,
How You Create Excel Output IN Oracle EBS.
Please Share Your Experience.
Waiting For Your reply.
<i><div align="right">Originally posted by abmian1981 - 07/12/2006 : 03:15:42 AM</div id="right"></i>
to get the output in excel in ERP please do the following steps:
1) goto system administrator responsibility
2) select install-->viewer options
3) ther u create a new viewer option Text Aplication/ Excel 11i outputexcel(description)
4)and select this viewer description
5) goto sysadmin-->system-->level site,profile-->viewer options
6) select the application text option and paste ur viewer profile description
7) change the responsibility and run a concurrent programme
u can c the outputto excel option along with other options
9) when u select output to excel output will be open in excel sheet
hope u understood the steps.
Regards,
Azeez
<i><div align="right">Originally posted by azeezpasha - 07/12/2006 : 11:55:16 PM</div id="right"></i>
Thanks Mr Pasha
-
- Posts: 5
- Joined: Tue Dec 05, 2006 4:56 am
- Location: Pakistan
Dear Admin,
We dont have an Oracle user. our technical team performed all the installation activities through the root user. I have performed the steps mentioned in DBA document logging in through the root user but my problem still persists.
Can you plz advise me the step by step process, we need to do, for a fresh installation to get outputs in pdf.
We dont have an Oracle user. our technical team performed all the installation activities through the root user. I have performed the steps mentioned in DBA document logging in through the root user but my problem still persists.
Can you plz advise me the step by step process, we need to do, for a fresh installation to get outputs in pdf.
Who is online
Users browsing this forum: No registered users and 0 guests