OTN Discussion Forums : Oracle Forms and APEX ...

This question is answered.

Reply to this Thread

Search Forum

Back to Thread List

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

user11109917

Posts: 24
Registered: 04/27/09

Oracle Forms and APEX
Posted: Oct 28, 2009 7:47 AM

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,936
Registered: 05/04/99

Re: Oracle Forms and APEX
Posted: Oct 28, 2009 7:59 AM

in response to: user11109917

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|http://roelhartman.blogspot.com/2008/11/integrate-oracle-forms-with-apex.html] 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|http://roelhartman.blogspot.com/2009/10/forms-apex-integration-video.html] 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: 24
Registered: 04/27/09

Re: Oracle Forms and APEX
Posted: Oct 28, 2009 10:27 AM

in response to: Roel

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,936
Registered: 05/04/99

Re: Oracle Forms and APEX
Posted: Oct 28, 2009 11:26 AM

in response to: user11109917

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: 24
Registered: 04/27/09

Re: Oracle Forms and APEX
Posted: Oct 28, 2009 2:15 PM

in response to: Roel

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,936
Registered: 05/04/99

Re: Oracle Forms and APEX
Posted: Oct 29, 2009 5:19 AM

in response to: user11109917

Correct

Hello Greg,

I managed to get it working. You can read about it in [this blog post|http://roelhartman.blogspot.com/2009/10/integration-of-forms-and-apex-calling.html].

Greetings,
Roel

http://roelhartman.blogspot.com/

user11109917

Posts: 24
Registered: 04/27/09

Re: Oracle Forms and APEX
Posted: Oct 29, 2009 7:34 PM

in response to: Roel

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,936
Registered: 05/04/99

Re: Oracle Forms and APEX
Posted: Oct 30, 2009 1:17 AM

in response to: user11109917

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...

Pages: 1

Back to Thread List

Legend
	Guru : 2500 - 1000000 pts
	Expert : 1000 - 2499 pts
	Pro : 500 - 999 pts
	Journeyman : 200 - 499 pts
	Newbie : 0 - 199 pts
	Oracle ACE Director
	Oracle ACE Member
	Oracle Employee ACE
	Helpful Answer (5 pts)
	Correct Answer (10 pts)