How to setup Apps. to get reports' output in PDF.

[Bilal Ahmad Qureshi]

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.

[admin]

Download document "Custom Reports Integration Document " from the Documents section and follow the steps. After integration if you will not be able to view the reports in PDF then also download the Apps DBA document and follow the steps mentioned in Display Settings. Hope will help you.

[habibi]

Hi Bilal

You just do a pdf report as if you do a char. report. But while registering the report in the Apps. concurrent program just select the output format as PDF.
Then u can get your report output in the pdf. format

Bye
Habibi

[azeezpasha]

[quote]
Hi Bilal

You just do a pdf report as if you do a char. report. But while registering the report in the Apps. concurrent program just select the output format as PDF.
Then u can get your report output in the pdf. format

Bye
Habibi

<i><div align="right">Originally posted by habibi

[Bilal Ahmad Qureshi]

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.

[ahmadbilal]

Mr Pasha ,

How You Create Excel Output IN Oracle EBS.
Please Share Your Experience.


Waiting For Your reply.

[admin]

Dear Bilal Ahmad Qureshi,
Pl let us know the steps you have performed to set Display settings. Paste your steps here. You have used dbs instead of localhost instead of ebs:0.0?
Do let us know.

[Bilal Ahmad Qureshi]

Dear Admin,

These were,

1- Login as user root.
2- Write export DISPLAY=localhost:0.0 Press Enter
3- Write xhost +

[admin]

Login as Oracle user and follow the steps mentioned in the DBA document. Your display settings are not properly configured. thanks

[azeezpasha]

[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

[azeezpasha]

[quote]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

[admin]

The demonstration of this tip will be included in the next version of admin document. thanks

[ahmadbilal]

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>

Hi,

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

[Bilal Ahmad Qureshi]

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.