8 Replies Latest reply on Jul 13, 2018 12:27 PM by Mahmoud_Rabie

Oracle Forms/Reports to APEX

User492103-OC Jun 28, 2018 2:41 PM

I am currently using Oracle Forms/Reports bundled with my Internet Application Server EE License. I want to now develop using APEX. Can all the logic previously implemented in Forms/Reports be recompiled in/converted to APEX?

1. Re: Oracle Forms/Reports to APEX

Mahmoud_Rabie Jun 28, 2018 5:17 PM (in response to User492103-OC)

Hi

Solution
(1) In the side of Forms/Reports, make sure that all your business logic, in the database e.g. packages, functions, ...etc
(2) Create your APEX application to connect to the database
(3) Build all your APEX pages and components from scratch.

Here is a good resource to know where to start
https://insum.ca/oracle-forms-conversion-to-oracle-apex-where-to-start/

I hope that helps

Regards
Mahmoud
1 person found this helpful
Like Show 2 Likes(2)

Actions
2. Re: Oracle Forms/Reports to APEX

TinkerBoy Jun 28, 2018 7:16 PM (in response to User492103-OC)

We are busy with the same type of project.
The short answer is yes, The long one is it depends on what your forms look like and what they do.
We are able to create complex forms but you have to re code them and move your program units to the DB side in packages.
1 person found this helpful
Like Show 1 Likes(1)

Actions
3. Re: Oracle Forms/Reports to APEX

User492103-OC Jun 29, 2018 8:31 AM (in response to Mahmoud_Rabie)

Thank you Mahmoud. So I will also be able to recreate my reports in APEX as well as the forms?
Like Show 0 Likes(0)

Actions
4. Re: Oracle Forms/Reports to APEX

User492103-OC Jun 29, 2018 8:32 AM (in response to TinkerBoy)

Hi Tinkerboy Some of our forms were written many years ago and are based on many different DB schema. We will probably end up having to reimplemmnet them from scratch. What are ye doing with your reports? Are ye moving onto APEX or straight to the more expensive BI Publisher (or another reporting tool)?
Like Show 0 Likes(0)

Actions
5. Re: Oracle Forms/Reports to APEX

Scott Wesley Jun 29, 2018 8:55 AM (in response to User492103-OC)

Most certainly, you can take the SQL out of your reports and stick it straight into APEX, and then make it a little more interactive.

If you really wanted to, you can invoke your existing Oracle Reports from APEX, but you'll probably be paying for unnecessary server licensing.

It really depends on what you want out of your reports. Do you need to produce documents (PDFs etc?)
If so, then your main options are BI Publisher (Oracle) or APEX Office Print (3rd party)
Like Show 1 Likes(1)

Actions
6. Re: Oracle Forms/Reports to APEX

Mahmoud_Rabie Jun 29, 2018 11:52 AM (in response to User492103-OC)

I agree with Scott's suggestions.

In addition, if you have a budget, I would recommend converting your legacy Oracle Reports to Oracle BI Publisher Reports.
http://www.oracle.com/technetwork/middleware/bi-publisher/e28918-02-1967539.pdf
Like Show 0 Likes(0)

Actions
7. Re: Oracle Forms/Reports to APEX

User492103-OC Jul 13, 2018 12:12 PM (in response to User492103-OC)

Hi Scott/Mahmoud, Thanks for the response and sorry about not replying. Do any of you know if there are licensing implications with doing any of the above. Currently Oracle Reports are bundled for licensing with Internet Application Server EE or Web Logic Server Basic. Oracle Reports are now on a terminal release and the upgrade path is BIP. Can I convert my Oracle Reports to BI Publisher without incurring big Oracle License costs?
Like Show 0 Likes(0)

Actions
8. Re: Oracle Forms/Reports to APEX

Mahmoud_Rabie Jul 13, 2018 12:27 PM (in response to User492103-OC)

For me, I would recommend asking that question in BI Publisher forum
BI Publisher
Like Show 0 Likes(0)

Actions

Go to original post

Join the world’s largest interactive community dedicated to Oracle technologies.