Skip to Main Content

APEX Office Hours

Free tips and training every month! Subscribe for reminders and more from Office Hours. FAQ

Header container

September 20, 2018

14:00 UTC   Start Times Around the World

Subscribe to be notified of changes to sessions and give us feedback!

Having trouble watching the video on this page? Open the video in your browser.


Oracle Forms Modernization
Watch Joel Kallman, Senior Director of Software Development, along with a number of experts from the global APEX Community, to discuss Oracle Forms Modernization. Learn about the positive aspects, together with the challenges, of using Oracle APEX to modernize your Oracle Forms applications. Real-world success stories, challenges, and tips are presented.

Session chat transcript =

Key Video Timestamps:
Panel Introduction [9:15]
Question 1 [11:55] - Can you please give a brief overview of one of your completed projects (or something which is underway)?
Question 2 [20:50] - What would you say is your approach in modernization with APEX? Rewrite? Partial migration? Create new apps adjacent to the existing Oracle Forms apps?

Question 3 [29:40] - What were some of the biggest challenges you faced in this type of project?

Question 4 [36:15] - What was the biggest benefit to the customer? Has the customer been satisfied with the result?

Question 5 [41:50] - We always talk about preserving your investment in the back-end business logic, in SQL and PL/SQL. Is this a fallacy? How much of the back-end code had to be modified to work in the new world with APEX?
Question 6 [46:30] - Can you describe the process you follow to assess if something is appropriate to be modernized with APEX? Can you give an example of something you would not use APEX to modernize a Forms app?

Question 7 [50:55] - How do you go about educating someone to use APEX, who comes from a Forms background? It is Web, and Web is different.
Question 8 [1:01:45] - How long does it take for the existing Forms developers to become competent in APEX and Web development? Were they able to carry on with further development on their own?

Question 9 [1:04:35] - Can customers do this migration on their own? This Office Hours forum is comprised of our many partners, and if I were watching this, I might think "wow, I need outside help to get this done". What would you say?
Question 10 [1:08:40] - For anyone watching this, who is contemplating modernizing some fo their Forms apps with APEX, do you have any specific advice?

Session Resources

Your Experts

    Joel Kallman

    Joel Kallman   

    Joel is the Vice President of Software Development at Oracle America, Inc., managing the development and product management of Application Express (APEX). He started working with Oracle Database in 1992 and joined Oracle in 1996. Joel's passion is to make customers extraordinarily successful with the Oracle Database, SQL and Oracle Application Express (APEX). He is a proud alumnus of The Ohio State University, College of Engineering, with a Bachelor's degree in Computer Engineering.
    David Peake

    David Peake   

    David joined Oracle in 1993. He spent the first 13 years within Oracle Consulting in Australia, New Zealand, and the United States. In 2006, he joined the Product Development team as the Oracle Application Express (APEX) Product Manager. He presents at many conferences around the world including Oracle Openworld, ODTUG KScope, OGh APEX World, DOAG and UKOUG.
    Chaitanya Koratamaddi

    Chaitanya Koratamaddi   

    Chaitanya Koratamaddi is a Director of Product Management for Oracle APEX and is responsible for all Product Management activities of Oracle APEX including APEX on Autonomous and APEX Service. Chaitanya leads the JAPAC Product Management and is on a mission to ensure customers embrace and utilize the full potential of low-code application development with Oracle APEX. Chaitanya is a regular speaker at various global conferences. You can gain insights into what Chaitanya is up to by following @chaitanya_in on Twitter.


Oracle Forms has some strength and is still the best BackOffice tool from ORACLE from my Point of view. Here are some issues that I miss with APEX. Maybe you already have these Options in 18.x.? Can you check this list: 1. 100% accessiblity for blind users (full keyboard, screenreader control) 2. object.libraries - referencing most properties of all items like colors, sizes, pos in one file 3. Independence of browsers (Firefox, IE, Chrome) and CSS specifica 4. Running 2000 sessions on one server sharing the app-load between weblogic and database 5. In Block Memory - loading 100.000 records and more into one LOV or POPLIST in seconds 6. Automatic locking of changed records. Automatic Binding of queries 7. Starting an application on client in less than 3 seconds Frank


Thank you for your excellent questions. Let me answer each of them as best I can Show more.

Answered by David Peake -