Calling Report from APEX

Eslam_Elbyaly

Hi. I used to work with Oracle developer suite 10g years ago, but unfortunately, I remember nothing about it.

I installed the 10g release 2 suite and created a report and saved it. The result was a .JSP file. Is that .JSP an executable file? If so, where is the original file?

I installed Oracle Developer Suite(Complete) which installed the OC4J as well. As far as I am aware, I now am using it as a standalone, right?

APEX 22.1.4. which I am using, only needs a URL to call the report. But, I do not know what the structure of the URL is?

Could you answer my questions and provide me with steps to call the report?

Thanks in advance.

InoL

You should ask this in the Forms/Reports forum. For many other APEX developers it is probably years ago too....

Note that Oracle Reports is not a free product, like APEX. Installing the Developer Suite is not an option for production. To run reports in production you need Weblogic. The URL is then

http://web_server.domain_name:port/alias/rwservlet?parameters

Eslam_Elbyaly

Pardon me. I thought I was in the Reports forum. Thanks.

Michael Ferrante-Oracle

Thread moved to Reports

Suresh Sangaran-Oracle

Please check the response from https://community.oracle.com/tech/developers/discussion/4504135/oracle-reports-deployment#latest

Eslam_Elbyaly

https://community.oracle.com/tech/developers/discussion/comment/16849435#Comment_16849435

Thanks but it's a different question. I am asking about the executable and original generated files and the url structure. Kindly, review the question.

Suresh Sangaran-Oracle

.jsp file should be in the place where you saved the file in Reports Builder. JSP's can be run as simple as calling it via Reports Servlet URL(rwservlet) or embeded HTML

http://web_server.domain_name:port/rwservlet/testreport.jsp?parameters=.....

Go through the documentation on how to build

https://docs.oracle.com/cd/B14099_19/bi.1012/b13895/orbr_concepts2.htm#sthref327

Deploying and running JSP reports

https://docs.oracle.com/cd/B14099_19/bi.1012/b14048/pbr_run.htm#sthref1421