For BI Publisher server licensing you have to contact Oracle Corporation in your region. We're coming up with another video in which we will demonstrate how to create such reports in JasperReport for free.
It doesn't work on my Oracle APEX cloud. In Report queries the message is: "Report Queries are not supported" and if I try to create Report query, when I try to download pdf the message is: ORA-20987: The requested URL has been prohibited. Contact your administrator. Am I doing something wrong or do I have to make some requests for my Oracle Cloud? Thanks.
thank you sir, very impressive, please inform (for my local environment) what are the requirements to install and configure to integrate BI Publisher into Oracle Apex? can you please guide us step-by-step from scratch ( what should i download and install, BI Publisher Server or Desktop or both ) OR any link from where i can learn this? regards
@@TechMining69 please inform (for my local environment) what are the requirements to install and configure to integrate BI Publisher into Oracle Apex? can you please guide us step-by-step from scratch ( what should i download and install, BI Publisher Server or Desktop or both ) OR any link from where i can learn this? regards
Nice Demo on BI Publisher Report From Oracle Apex But madam, ABC CORPORATION assign to any variable, this variable to be put on each bi report how to do that
You can fetch this value in your report's SQL query from the company setup table. Of course, you need to have such a table in your schema where you have the company profile.
Madam, Thank you for your Valuable reply. Madam Scott schema, dept and emp table are there, Now I want to Each Dept PDF individual. That how to do either in specified folder or Specified ORACLE DIRECTORY .
Of course, you need the server for your local environment and need some configuration in APEX to use it as your print server. In near future, we will be uploading a video on Jasper Report which is a better alternative.
Hi. Thanks, I needed this. Regards.
Glad it was helpful!
Great video 👍
Thanks 👍
Please advise the licensing implications for using BI publisher in Apex. Great video.
For BI Publisher server licensing you have to contact Oracle Corporation in your region. We're coming up with another video in which we will demonstrate how to create such reports in JasperReport for free.
Thanks... excellent work... but what are the previous settings because the test report shows an error?
Please elaborate "previous settings".
It doesn't work on my Oracle APEX cloud. In Report queries the message is: "Report Queries are not supported" and if I try to create Report query, when I try to download pdf the message is: ORA-20987: The requested URL has been prohibited. Contact your administrator. Am I doing something wrong or do I have to make some requests for my Oracle Cloud? Thanks.
Hey dear, I need a help with the same custom pdf report devlopment in 23 version it's giving url probited error..can you help me
Thanks for the video, I want to preview the PDF output in new tab instead of downloading it and then previewing it. Thanks in advance
You are welcome!
thank you sir, very impressive, please inform (for my local environment) what are the requirements to install and configure to integrate BI Publisher into Oracle Apex? can you please guide us step-by-step from scratch ( what should i download and install, BI Publisher Server or Desktop or both ) OR any link from where i can learn this? regards
Stay tuned. We will upload this video in near future.
@@TechMining69 please inform (for my local environment) what are the requirements to install and configure to integrate BI Publisher into Oracle Apex? can you please guide us step-by-step from scratch ( what should i download and install, BI Publisher Server or Desktop or both ) OR any link from where i can learn this? regards
Nice Demo on BI Publisher Report From Oracle Apex
But madam, ABC CORPORATION assign to any variable, this variable to be put on each bi report
how to do that
You can fetch this value in your report's SQL query from the company setup table. Of course, you need to have such a table in your schema where you have the company profile.
Madam, Thank you for your Valuable reply.
Madam Scott schema, dept and emp table are there, Now I want to Each Dept PDF individual.
That how to do either in specified folder or Specified ORACLE DIRECTORY .
Can it work on my local network. My oracle db not on clouds. Any configuration requirements?
We created this tutorial on Oracle APEX cloud. It works there. You need to create the query and upload RTF.
@@TechMining69
Means no requirement of bipublisher server to be install
Of course, you need the server for your local environment and need some configuration in APEX to use it as your print server. In near future, we will be uploading a video on Jasper Report which is a better alternative.