Thread: Oracle Forms and APEX

This question is answered.


Permlink Replies: 7 - Pages: 1 - Last Post: Oct 30, 2009 1:17 AM Last Post By: Roel
user11109917

Posts: 13
Registered: 04/27/09
Oracle Forms and APEX
Posted: Oct 28, 2009 7:47 AM
 
Click to report abuse...   Click to reply to this thread Reply
Hello all-
I have a project management application that was developed in Oracle Forms v10.1.2.0.2 and an asset management application developed in Application Express 3.1 - both in the same database. There are new requirements to include some of the asset data in the project application for editing. There are existing APEX forms in the asset application that they want to include in the project application forms. Is there a way to "embed" an APEX form within and Oracle Form? I know that I can use web.show_document() in Forms, but that will pop up another browser window and that is not acceptable to the users. I also know that I can re-create the asset form in Oracle Forms and that will be part of the project application. But this means I have 2 asset forms to maintain in case there are any changes. I would really like to have Oracle Forms "use" my APEX form. Is this possible?

Thanks in advance,
Greg
Roel

Posts: 1,821
Registered: 05/04/99
Re: Oracle Forms and APEX
Posted: Oct 28, 2009 7:59 AM   in response to: user11109917 in response to: user11109917
 
Click to report abuse...   Click to reply to this thread Reply
Hello Greg,

First a shameless plug...
If you had visited Oracle Open World (or ODTUG) you could have come to my session called : "Its Great to Integrate - Combining Oracle Forms and Oracle Application Express"....
If you've planned to visit the upcoming UKOUG, I will redo that same session there...

In this blog post I describe how you can do that (although the current version is more sophisticated). There is also a blog post about the video of the demo available.

If you need more details plz contact me directly (roel<dot>hartman<at>logica<dot>com)

Greetings,
Roel

http://roelhartman.blogspot.com/
user11109917

Posts: 13
Registered: 04/27/09
Re: Oracle Forms and APEX
Posted: Oct 28, 2009 10:27 AM   in response to: Roel in response to: Roel
 
Click to report abuse...   Click to reply to this thread Reply
Hello Roel-
I checked out your links and video and they are great. But, you have integrated a Forms page into an APEX page (very cool!). My users want me to integrate an APEX page inside a Forms page. The project application (in Forms) has many users that need to edit the asset data. I would like to make a couple of the asset forms (in APEX) display inside a project form (Oracle Form).

Thanks,
Greg
Roel

Posts: 1,821
Registered: 05/04/99
Re: Oracle Forms and APEX
Posted: Oct 28, 2009 11:26 AM   in response to: user11109917 in response to: user11109917
 
Click to report abuse...   Click to reply to this thread Reply
Yeah I know, it is just the other way round. The approach should be a little different. I'll try to work out an example - where you can call an APEX page from an Oracle Form - tomorrow. I guess that's soon enough..

I am thinking about adding either a DIV or an IFRAME tag to the basehtml (that's somewhere on your forms server) that contains the applet. And use that tag as the 'target' for an APEX page using some javascript calls from within Forms. I'll give it a try.

To be continued...
user11109917

Posts: 13
Registered: 04/27/09
Re: Oracle Forms and APEX
Posted: Oct 28, 2009 2:15 PM   in response to: Roel in response to: Roel
 
Click to report abuse...   Click to reply to this thread Reply
Roel-
Thanks for working on this. I am going through the example on your blog to integrate an Oracle Form in my APEX page. I am working on creating the PJC from the document link on your blog. But I do still need to find out if we can integrate an APEX page into an Oracle Form.

Thanks again
Roel

Posts: 1,821
Registered: 05/04/99
Re: Oracle Forms and APEX
Posted: Oct 29, 2009 5:19 AM   in response to: user11109917 in response to: user11109917
Correct
Click to report abuse...   Click to reply to this thread Reply
Hello Greg,

I managed to get it working. You can read about it in this blog post.

Greetings,
Roel

http://roelhartman.blogspot.com/
user11109917

Posts: 13
Registered: 04/27/09
Re: Oracle Forms and APEX
Posted: Oct 29, 2009 7:34 PM   in response to: Roel in response to: Roel
 
Click to report abuse...   Click to reply to this thread Reply
Roel-
You are THE MAN! We use SSO, so authentication will not be a problem. I assume that the PJC to handle communication between the Form and APEX will work in this situation. Thanks again for your time working on this. I better earn my pay and get working...
Roel

Posts: 1,821
Registered: 05/04/99
Re: Oracle Forms and APEX
Posted: Oct 30, 2009 1:17 AM   in response to: user11109917 in response to: user11109917
 
Click to report abuse...   Click to reply to this thread Reply
You don't need a PJC to communicate from Forms to APEX (only for the other way round - and when you embed Forms in APEX pages). Just plain HTML and Javascript...
Legend
Guru Guru : 2500 - 1000000 pts
Expert Expert : 1000 - 2499 pts
Pro Pro : 500 - 999 pts
Journeyman Journeyman : 200 - 499 pts
Newbie Newbie : 0 - 199 pts
Oracle ACE Director
Oracle ACE Member
Oracle Employee ACE
Helpful Answer (5 pts)
Correct Answer (10 pts)

Point your RSS reader here for a feed of the latest messages in all forums