7 Replies Latest reply on Oct 30, 2009 8:17 AM by Roel Hartman

    Oracle Forms and APEX

    user11109917
      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
        • 1. Re: Oracle Forms and APEX
          Roel Hartman
          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/
          • 2. Re: Oracle Forms and APEX
            user11109917
            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
            • 3. Re: Oracle Forms and APEX
              Roel Hartman
              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...
              • 4. Re: Oracle Forms and APEX
                user11109917
                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
                • 5. Re: Oracle Forms and APEX
                  Roel Hartman
                  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/
                  • 6. Re: Oracle Forms and APEX
                    user11109917
                    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...
                    • 7. Re: Oracle Forms and APEX
                      Roel Hartman
                      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...