Oracle APEX: The Next Chapter for Oracle Forms

Join our exclusive webinar series to explore the journey from legacy Oracle Forms to modern Oracle APEX. Through 6 expert-led videos, discover key strategies, insights, and best practices for a successful modernization.

A diverse oracle development team gathers around computers going over some codes

Watch Now

Looking to convert Oracle Forms to APEX? Join us for our exclusive series on modernizing Oracle Forms with Oracle APEX

Welcome to our exclusive series dedicated to highlighting the key considerations when modernizing Oracle Forms applications with Oracle APEX. While we won’t delve into the nitty-gritty of implementation, our focus is on instilling confidence and sharing tips and tricks with those of you who wish to convert Oracle Forms to APEX. Join industry experts Keny Colina and Velimir Corovic as they guide you through the essential steps and strategies for modernizing your Oracle Forms applications with Oracle APEX. This series covers everything from handling PL-SQL code to managing long-running processes, essential for ensuring a smooth transition.

Get Full Access to the Series

What to Expect:

Empower Your Team

Through detailed sessions, gain valuable insights into the modernization journey from Oracle Forms to APEX. Learn the techniques and strategies our experts use to drive a successful transition.

See the Impact

Explore real-world scenarios where APEX proves to be the ideal replacement for Oracle Forms. See how modernization can boost productivity and user satisfaction.

Understand the Transition

Discover the key differences between Oracle Forms and APEX. Our sessions offer a clear understanding of the architecture, development paradigms, and the path to modernize your applications.

Leverage Proven Strategies

Benefit from the extensive experience and knowledge we bring to the modernization process. Learn best practices and avoid common pitfalls, ensuring a smooth and efficient transition to APEX.

About the Episodes

Episode 1: Oracle Forms to Oracle APEX Overview

Join Keny Colina and Velimir Corovic, with special guest Monica Godoy, Oracle APEX Product Manager, as they explore the benefits of transitioning from Oracle Forms to APEX. They’ll discuss practical examples and essential considerations to set you on the right path

Episode 2: Oracle Forms vs. Oracle APEX Session Management

Dive into the differences between stateless and stateful architectures, and learn how to manage sessions, audit columns, and global variables in APEX with insights from our experts

Episode 3: Oracle Forms Built-Ins

Learn about the PL-SQL runtime engine, built-ins, and their alternatives in APEX with Eglé Ledezma and Pierre Chiu. Understand how to handle ‘Set Item Property’ and ‘Enter_Query / Execute Query’ commands in APEX

Episode 4: Oracle Forms to Oracle APEX Conversion techniques

Omaliny Gonzalez shares tips and tools for effective conversion, leveraging Insum’s internal tools and conversion templates, with insights from Elisabeth Ashley.

Episode 5: Asynchronous processes

Explore strategies for managing long-running processes with Marwa Chouchene and Jacky Le-Blay, focusing on synchronous and asynchronous processing.

Episode 6: RDFs Conversion

Azzedine Makhoukh explains the conversion of Oracle Reports using APEX Office Print (AOP), with insights from Anoir Ben-Mabrouk.

Watch Episode 1 now

APEX the Next Chapter for Oracle Forms - Episode 1

Fill Out the Form to Unlock Full Access

Our Oracle Forms Modernization Success Stories

Our team of seasoned experts has guided numerous businesses through their Oracle Forms modernization journeys. With our deep knowledge of Oracle technology, a keen eye for business process optimization, and a client-centric approach, we ensure that your journey is not just successful, but also a significant leap towards enterprise excellence.

Aerospace Agency Transforms with APEX

Insum delivered four successful migration phases, converting applications for security management, project tracking, and internal training. APEX’s Universal Theme and AOP reporting ensured usability and consistency.

The Result

  • 250+ Forms migrated to APEX
  • On-time, on-budget delivery
  • Internal teams trained and equipped for future development

“Insum gave us a strong start with APEX, providing the tools, training, and support our developers needed.”
— IT Manager, Federal Agency

Energy Leader Embraces APEX Modernization

A global energy technology provider needed to migrate 323 material management Forms screens to Oracle APEX within 12 months due to an upgrade by their software editor. Many of the screens included complex extensions.

The Challenge

  • Maintain existing functionality
  • Improve performance and navigation
  • Ensure a smooth transition
  • Stay on time and on budget

The Results

Despite unforeseen scheduling challenges, the Insum-Talan team delivered successfully, meeting the timeline and budget. Key achievements included:

  • Reducing unnecessary applications and features
  • Harmonizing the user experience
  • Adding advanced search and visualization tools
  • Providing expert coaching and advice

A formalized global process, including quality control and change management, was key to the project’s success.

Law Practice Upgrades Legacy Systems

A leading U.S. government-debt collection law firm managing over $10 billion in delinquent accounts needed to update its tax collection systems running on outdated Oracle Forms, Database, and APEX versions.

The Challenge

Outdated systems using a mix of role-based and application-level security required modernization to improve efficiency, UX, and security.

The Priorities

  • Enhance service quality through innovation
  • Improve user experience
  • Achieve strong information security

The Results

After updating the database and applications, Insum migrated 117 Oracle Forms to Oracle APEX, leveraging existing database logic and adding native APEX enhancements without impacting delivery. Outcomes included:

  • Streamlined applications and reduced unnecessary features
  • Powerful search and visualization tools
  • Consistent user experience
  • Expert guidance and coaching

The migration leveraged Oracle Real Application Security (RAS)—the latest in Oracle’s application security technology.

Logistics Provider Moves ERP to the Cloud

A logistics company specializing in trailer leasing and rental needed to modernize its on-premise Oracle Forms ERP to support new business processes and improve data visibility.

The Challenge

  • Review and update on-premise Oracle Forms ERP
  • Quickly incorporate new business workflows
  • Enhance reporting and data visualization

The Priorities

  • Modernize while extending existing Forms investments
  • Reduce on-site infrastructure
  • Improve reporting flexibility and data insights
  • Streamline billing and reduce errors

The Results

Insum migrated the Oracle Forms applications to the Cloud and developed secure, high-performance dashboards using Oracle APEX, including Interactive Reports. The solution integrated real-time telematics data with ERP systems, delivering better visibility and efficiency.

Management Consultancy Secures and Modernizes Apps

A sales and marketing services consultancy specializing in employee recognition and loyalty programs needed to replace Oracle Forms due to outdated web technology, lack of responsive design, and security concerns.

The Challenge

  • Replace legacy Forms to improve security and UX
  • Enable secure access from anywhere
  • Improve customer experience
  • Provide developer training and a technology roadmap

The Results

Insum migrated all Oracle Forms to Oracle APEX and:

  • Set up a secure, scalable APEX infrastructure
  • Designed a Time Entry and Approval app as a proof of concept
  • Created a unified design standard with shared themes and components
  • Developed remaining applications using this template
  • Delivered ongoing knowledge transfer, best practices, and coaching

The project resulted in a secure, user-friendly system and empowered the client’s developers for future growth.

Regulatory Agency Enhances with APEX

A state government agency regulating the pari-mutuel horse and greyhound racing industry needed functionality beyond its legacy Oracle Forms applications to better fulfill its regulatory role.

The Challenge

  • Outdated Forms limiting critical functionality
  • Manual processes slowing operations
  • Complex navigation and security concerns

The Priorities

  • Automate manual workflows
  • Simplify and declutter navigation
  • Enhance application security

The Results

New APEX applications replicated existing Forms features and introduced many enhancements:

  • Streamlined “one-stop” navigation for all animal records
  • Reduced excessive navigation in case tracking with powerful, customizable reports
  • Automated manual processes and strengthened security in rulings
  • Improved licensing application with clearer interfaces and relational links

“Insum customized our ruling system precisely to our needs, listened carefully, and delivered changes quickly and thoroughly.”
— Director of Licensing, Regulatory Agency