Skip to Main Content

Oracle Application Express (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

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 = http://bit.ly/apex_office_hours_chat_20180920

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?


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

Session Resources

Experts

Your Experts
Joel Kallman
Joel Kallman, Senior Director, Software Development    
Joel is the Senior Director 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, Senior Principal Product Manager - Application Express    
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, Senior Principal Product Manager, Oracle Application Express - Database Tools | Server Technologies    
Chaitanya is a Senior Principal Product Manager for Oracle Application Express. Chaitanya has extensive knowledge and experience on various Oracle technologies such as Oracle Application Express, Oracle SQL Developer, SQL Developer Data Modeler, Oracle Database, Oracle XML DB, Oracle Database XE, Oracle Database Vault, Oracle REST Data Services, and Oracle Fusion Middleware. Chaitanya is a regular speaker at various global conferences like Oracle Open World, OTN Yathra, Oracle Code, Oracle Develop, Oracle Cloud World, OTN Developer Days, ODTUG, JavaOne, AIOUG Tech Days, Sangam, and other user groups. Chaitanya writes his technical blog @ http://chaitanyain.blogspot.com/.

Answers

Answers
Question
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
Answer

Frank,

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

Answered by David Peake -