| Report Printing problem [message #455125] |
Mon, 10 May 2010 06:19  |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
Hi I have configured report from instance manager in apex_admin as stated in documnets. Then I have created a report and configured printing attributes for printing the report region. but whenever I try to print the report I see the error :
ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified., Now I am really stuck into this. Please help.
Hasan Al Mamun
|
|
|
|
|
|
| Re: Report Printing problem [message #455203 is a reply to message #455136] |
Mon, 10 May 2010 11:29  |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
Thanks for the link. I have been searching for the solution for Last few days and eventually found this link too. Now My question is did you really solve it ? If yes then please give me step by step solution, which will be great help for me.
Hasan Al Mamun
|
|
|
|
|
|
|
|
|
|
| Re: Report Printing problem [message #455570 is a reply to message #455528] |
Wed, 12 May 2010 03:41 |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
|
In all the documentations on Apex Installation and post installation tasks, they have Network configuration for Oracle 11g. They provided a pl/sql blok to resolve the problem for 11g. In the a ferquent soled problems link by oracle said that If Apex is not configured for network configuration, when you try to print the report you will get the report printing error. ORA-20001: The printing engine could not be reached because either the URL specified is incorrect or a proxy URL needs to be specified. Now if ther is pl/sql code for Oracle 11g there should be some solution for 10g also. But where is that?? I have got no help yet to resolve this problem.
|
|
|
|
|
|
|
|
| Re: Report Printing problem [message #455713 is a reply to message #455659] |
Wed, 12 May 2010 11:56 |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
I am using Oracle 10g enterprise edition, I have setup oracle companion CD to install Apex 3.2 in Oracle 10g EE. It is working just fine for all the jobs other than report printing. Oracle 11 has Apex installed by default, but u need to upgrade it to apex 3.2. Then u have to run the pl/sql code given in the installation documentation, else you cant print report. this is what's written in the manual, I did not try it in 11g. I have tried the code in 10g, DBA_NETWORK_ACLS table or view does not exist is the error, it's not working. I need to do it in 10g EE, but yet to find any solution. please any body....
Hasan Al Mamun
Programmer
Bangladesh Bank
Bangladesh
[Updated on: Wed, 12 May 2010 12:03] Report message to a moderator |
|
|
|
|
|
| Re: Report Printing problem Solved [message #456236 is a reply to message #455728] |
Sun, 16 May 2010 06:40 |
BBMamun
Messages: 94
Registered: February 2010
Location: Dhaka, Bangladesh
|
Member |
|
|
Hi, problem solved. The key to printing is to install Oracle BI Publisher. I have installed BI Publisher 10.1.3 and configured Apex to incorporate BI Publisher, and then set the report printing attribute. The PL/SQL for Oracle 11g is applicable only for 11g. Means that even if you install BI Publisher in Oracle database 11g environment you have to run the Network configuration PL/SQL. Else you cannot print report. For 10g EE you only need to install BI and necessary configurations..
Hasan Al Mamun
|
|
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
