oracle-apex-forms-modernization-2023.pptx

Oracle APEX - Form Modernization

1. Modernizing Oracle Forms Using Oracle APEX Fata Hudaya Oracle Developer

2. Fata Hudaya Oracle Developer PT XYZ 3 Copyright © 2023, Oracle and/or its affiliates

3. Overview Oracle Forms Oracle APEX Should you Modernize? Key Reasons to Modernize Similarities, Differences and Advantages Considerations and Modernizations Steps Resources Success Stories Useful Links Agenda Copyright © 2023, Oracle and/or its affiliates 4

4. Copyright © 2023, Oracle and/or its affiliates 5 Oracle Forms

5. 6 Copyright © 2023, Oracle and/or its affiliates Oracle's long-established technology to design and build enterprise applications. A component of Oracle Fusion Middleware. Powerful desktop applications delivered with the ease and scalability of a web applications. Oracle Forms

6. 7 Copyright © 2023, Oracle and/or its affiliates Non-responsive = Not suitable for mobile devices. Not ideal for cloud native apps. Non-intuitive runtime user experience. Challenging to find skilled Oracle Form developers. Oracle Forms Challenges

7. Copyright © 2023, Oracle and/or its affiliates 8 Oracle APEX

8. What is Oracle APEX? Copyright © 2023, Oracle and/or its affiliates APEX is the world’s most popular enterprise low-code application development platform It enables you to build scalable and secure enterprise apps with world-class features 20X faster with 100X less code Oracle APEX delivers the most productive way to develop and deploy Mobile, Web, and Desktop apps everywhere - cloud and on-premises

9. Comprehensive Low-Code Platform Oracle APEX Copyright © 2023, Oracle and/or its affiliates App Builder Data Loading Object Browser SQL Workshop RESTful Services Team Development App Gallery Monitor Build powerful cloud apps using a web browser Import/export data Publish REST APIs Integrate local and remote data Unified, Comprehensive Low-Code experience for Data Modeling, APIs, UX, and Lifecycle from a single vendor

10. Oracle APEX Copyright © 2023, Oracle and/or its affiliates Low Code Developers Professional Data Scientist LOB Citizen Solutions Time, Cost & Complexity UX, Capability & Success Develop & Deploy Cloud On-Prem APEX Architecture Web Server App Definition + APEX Runtime & Local Datastore Mobile, Web ORDS Datastores & APIs External

11. Radically Faster Oracle APEX Application Development Copyright © 2023, Oracle and/or its affiliates Minutes Lines of Code Lines of Code Pique Solutions Time and Motion Study : ReactJS vs. Low-Code APEX Source: www.oracle.com/a/ocom/docs/pique-solutions-apex-vs-reactjs-study.pdf 38X Faster 20X Less Code Development Time ReactJS ReactJS APEX APEX

12. Need modern, responsive user interface running on any device Need solution for external use (such as customers / partners) Need simplified UX as extending to corporate-wide Major functionality needs to be redeveloped Unable to maintain / enhance existing Forms apps Key Reasons to Modernize Copyright © 2023, Oracle and/or its affiliates 13

13. 14 Copyright © 2023, Oracle and/or its affiliates Should you Modernize? Are you on a supported version? Can you easily upgrade? Is Forms meeting all requirements? Yes Are they net new requirements? Modernize Forms Using APEX No Stay on Oracle Forms Keep Oracle Forms + Build new apps in APEX Yes No Yes No Yes No

14. Oracle APEX The Best “Proven” Alternative Copyright © 2023, Oracle and/or its affiliates 15

15. 16 Copyright © 2023, Oracle and/or its affiliates Primarily code in SQL and PL/SQL Database-centric development Low-code, declarative platform Can very easily integrate Oracle packages, functions, procedures Can fully utilize Oracle Database features Oracle APEX Similarities

16. 17 Copyright © 2023, Oracle and/or its affiliates Oracle APEX Differences Oracle Forms Oracle APEX Requires full WebLogic Server Requires Oracle REST Data Services Requires browser plug-ins or Java Web Start Any modern web browser Generates files Metadata based Suitable for desktops only Runs on any device (zero development effort) Difficult to style Out of the box theming and theme styles

17. 18 Copyright © 2023, Oracle and/or its affiliates No additional licensing cost Easy to train Forms Developers as key similarities Re-use all existing Database objects Can readily co-exist with Oracle Forms Flexibility in platform for development / deployment Rapid, low-code, beautiful, intuitive, responsive app dev APEX Community and Partners Oracle APEX Advantages

18. 19 Copyright © 2023, Oracle and/or its affiliates Oracle APEX Advantages on Oracle Cloud Secure Environment On the world's first and only Autonomous Infrastructure. Fully Managed Automatic monitoring, backups, patching, and upgrades. Highly Available Highly available with Auto Scale. Available in 40+ public cloud regions. Compliant Compliant with regional data regulations, including FedRAMP, HIPAA, SOC 1-3, PCI

19. Considerations Copyright © 2023, Oracle and/or its affiliates 20 Upfront Planning

20. Modernization is non-trivial Requires significant investment in time and resources New apps should be modern and intuitive not mimic Forms The new APEX applications will look and behave differently Should modernize business processes not just screens Key Points Copyright © 2023, Oracle and/or its affiliates 21

21. Push as much business logic into the Database as possible Identify a suitable functional area as Proof-of-Concept Review how APEX Consulting Companies may add value Train developers in APEX Secure SMEs for functional input and reviews Before you Start Copyright © 2023, Oracle and/or its affiliates 22

22. Availability of Forms developers who know the functionality Getting buy-in from existing “Power Users” Managing scope creep Ensuring new apps implement appropriate business rules Agreeing on new application look and feel Challenges Copyright © 2023, Oracle and/or its affiliates 23

23. Success Stories Copyright © 2021, Oracle and/or its affiliates 24

24. “Our goal is to continue to upgrade, develop and release cutting-edge and innovative COTS solutions leveraging APEX for the Federal market. We intend to continue to team with Oracle and PITSS to gain greater exposure on our successful adoption of APEX.” Lisa Kazor CEO, Savantage Solutions Results: By adopting Oracle’s Low-code solution, Savantage was able to incorporate their consultants more inclusively in the software development life cycle of their products, which enhances their professional skills and satisfaction. Savantage’s internal KPI for time to market has improved with the APEX upgrade by 37.5% , with all other KPI’s remaining relatively consistent and well above market standards. Positive impact on customer usability and increased ease of maintenance. Savantage upgrades ERP Solutions tailored to the needs of US Federal market with Oracle APEX Copyright © 2023, Oracle and/or its affiliates Business Challenge: Enhance customers operations, performance and security in a cost-effective way while maximizing the partnership with Oracle to provide leading-edge solutions. Number of Forms: 700 forms~ Number of Reports: 300 reports~ Reports developed in: APEX Native components / Third-party tools Environment: On-premises / Oracle Cloud (OCI) / AWS Teams involved: Savantage R&D/ Savantage Project Teams/PITSS/Oracle Timeline: 2022/2023

25. Business Challenge: Oracle Forms no longer gave Humanic the ability to provide customers with a robust, enterprise-level payroll solution. The company needed a new development platform that would give customers a modern user interface and the highest level of security. Humanic also wanted to reuse its proven payroll application code and reduce the effort to bring new applications to market. “The customer experience is a top priority for us. We want to create applications that users will enjoy using. APEX allows us to achieve that while maximizing developer efficiency.” Bradley Toland President , Humanic Results: Migrating from Oracle Forms to Oracle APEX allowed Humanic teams to enhance the Humanic Payroll solution while reducing development time by 35% . In addition, Oracle APEX and Oracle Database provided the functionality Humanic developers needed without the traditional trade-off of time-consuming data integrations. The team also redesigned its security and menu system. Read story Humanic significantly improves the customer experience using Oracle APEX Copyright © 2023, Oracle and/or its affiliates Number of Forms: 300 forms Number of Reports: 110 reports Reports developed in:  BI Publisher Environment: On-premise, moving to OCI soon. Business Logic:  Most of the logic migrated to the database Team involved:  3 developers Timeline: 18 months

26. “APEX lets me immediately create a page and begin changing that page to fit the process I am working on. I don’t have to create separate files for front-end and back-end code. I don’t have to worry about versioning or connecting to the database. All of this made the project go quickly and with little debugging” Heidi Cautrell Senior Applications Developer, State of Louisiana Results: Increase in productivity and time save for all the users that now can quickly access the reports and forms they need. Reduction on the number of support tickets created by the users. State of Louisiana improves productivity with Oracle APEX Copyright © 2023, Oracle and/or its affiliates Business Challenge: The key challenges faced by the State of Louisiana were aging infrastructure that led to performance and security issues and a shrinking developer team. Number of Forms: 37 forms Number of Reports: 58 reports Reports developed in: APEX Native components / BI Publisher Environment: On-premises moving to OCI soon. Business Logic: Some migrated to the Database / kept inside the form in APEX. Team involved:   Two developers (1 Full time and 1 Partial time) Timeline: 3 years

27. Business Challenge: Novatech undertook a modernization of their IT systems, which included upgrading their primary enterprise application, a version of E-Business Suite (EBS) dating back to the early 2000s that made adding new functionality and business processes difficult. Novatech also wanted to do away with manual spreadsheet updates and the risks of human error during the lists’ approvals and renewals. Products Used: Oracle Database Oracle APEX “With Oracle APEX, we dramatically improved our ability to develop new apps and reporting to help our manufacturing business react faster to the market and to our customers. We’ve increased data security and productivity. The Oracle team is easily reachable and responsive, which has reinforced our confidence.” Mick Morin IT Manager, Groupe Novatech Inc. Results: Novatech updates its EBS apps with the low-code development framework, APEX, to increase data security and reduce costs. The company was provided with better exposure to single-sourced data from E-Business Suite (EBS), enabling management to react faster and increase manufacturing production efficiency APEX helped to spark an accelerated evolution of business processes and created a renewed enthusiasm among end users for the improved functionality Cut development time in half by replacing Forms apps Read story Novatech modernizes manufacturing processes with Oracle APEX Copyright © 2023, Oracle and/or its affiliates

28. Business Challenge: Based in Gujarat, India, the IT company, the Soham ERP Solutions offers several products for its 2,000-plus customers, ranging from ERPs to salesforce automation systems to barcode tools. As the pharmaceutical industry grew, Soham ERP’s customers expected improvements in software functionality, experience, and efficiency. Additionally, customers who had adopted the company’s on-premises software wanted help with growth challenges, such as costs associated with server upgrades, database licenses, and investments in IT staff to manage on-premises infrastructure. The company decided to migrate to Oracle Cloud Infrastructure (OCI) and low code platform, APEX, paving the way for a more modern approach to application development. However, the decision to choose Oracle was not a foregone conclusion.  Products Used: Oracle Cloud Infrastructure Oracle Database Oracle APEX “Our more than 100 enterprise customers are thrilled with the performance of OCI. With Oracle APEX and Database Cloud Service, we have faster time to market to build and deploy plus data security. And Oracle Consulting helped us seamlessly convert our existing forms and reports and trained our current staff.” Suketu Shah Director , Soham ERP Solutions Results: Soham ERP was able to develop a new application, PharmaCloud , using Oracle APEX with Oracle Database Cloud Service on Oracle Cloud Infrastructure. PharmaCloud supports about 100 of Soham’s customers, equivalent to roughly 1,200 concurrent users. Before the transition to the cloud, customers would need to invest about $100,000 for on-premises hardware, licensing, and maintenance. Now, that initial cost has dropped to about $20,000, which better aligns costs with benefits.   Thanks to OCI, Soham has seen a 25% improvement in application performance—leading to faster turnaround time for complex processes—while reducing costs by 40%. Plus, customers can access PharmaCloud from anywhere in the world, from any device. Read story Copyright © 2023, Oracle and/or its affiliates Soham ERP builds new app using Oracle Cloud

29. “By migrating our core business systems to Oracle Autonomous Database, we have eliminated dependency on a third-party service provider, taken control in-house, and reduced operational costs by 30%.” Alexey Novikov Head of Software Development, REACH REACH cuts IT overhead by 30% with Oracle Autonomous Database and APEX Copyright © 2023, Oracle and/or its affiliates Business Challenge: REACH was using Oracle Forms to develop and run a core business application that managed a range of internal business processes and financial operations. But managing data and interactions via Oracle Forms had limitations, so the team was looking for alternatives with greater capabilities. As an added complication, REACH depended on a third-party vendor to manage what was a technically complex environment. The in-house software team of REACH had very little control over the production environment, leading to added administrative costs for systems upgrades and monitoring. REACH needed to move to a new IT environment that provided greater scalability, more in-house control, faster turnaround on new initiatives, and enterprise grade security. Products Used: Oracle Autonomous Transaction Processing Oracle APEX Results: REACH has reduced IT operating costs by 30% by migrating to Oracle APEX, using Oracle Autonomous Database for transaction processing on Oracle Cloud Infrastructure (OCI). REACH can now more quickly and cost-effectively develop and deploy applications. The Oracle Cloud Lift Services team worked with the REACH team to assist in migrating their database and applications to OCI in just two weeks. The Lift Services team also helped REACH set up an OCI tenancy, all the virtual networking, Autonomous Database for transaction processing, and Oracle APEX. Read story

30. Business Challenge: King Hamad University Hospital offers national healthcare for all residents of Bahrain, an Arabian Gulf island nation, with more than 40 specialties. The core healthcare information system, HOPE (Healthcare Operating Environment), spans every aspect of the healthcare system, from scheduling, admissions, electronic medical records, lab testing, specialty care, pharmacy, catering, and revenue management, among other patient and staff services. Products Used: Oracle Database Oracle APEX “HOPE has a clear and profound positive impact on the way the hospital operates. It streamlines hundreds of business processes across the organization. HOPE is powered by Oracle APEX, which offers unparalleled speed, integration, and security. We now have the agility to rapidly build and evolve our hospital information system in record time on minimal infrastructure, and to provide excellent healthcare more efficiently. Oracle APEX has no competition.” Dr. Mohamed Helal HOPE Architect and Lead Designer, Head of Hospital Information Systems, King Hamad University Hospital Results: Modernized its operating environment using Oracle APEX by creating one large application that spans a suite of more than 40 modules The hospital app serves 5,000 users, including all physicians and staff and handles 4 to 5 million hits per day and 8,000 to 10,000 sessions per day without capacity issues Read story King Hamad University Hospital accelerates application development and saves costs Copyright © 2023, Oracle and/or its affiliates

31. Modernization Steps How to Move to Oracle APEX Copyright © 2021, Oracle and/or its affiliates 32

32. 33 Copyright © 2023, Oracle and/or its affiliates Provision your APEX Service or Install APEX into your local Oracle Database Know the important business logic Create APEX application(s) Use Create App Wizard for “First-Cut” Enhance pages based on requirements Use Create Page Wizard to add additional pages Review with key stakeholders Iterate and repeat from step 2 Overall Strategy

33. 34 Copyright © 2023, Oracle and/or its affiliates Creating a workspace Creating the APEX app Customizing the APEX app – Customers Form Customizing the APEX app – Orders Form The last enhancements apex.oracle.com/go/forms2apex-blog Practicing a Modernization

34. 35 Copyright © 2023, Oracle and/or its affiliates Practicing a Modernization Alternatives for Customers Form in APEX: Faceted Search Interactive Report Tree Alternatives for Orders Form in APEX: Master Detail Stacked Side by Side Drill Down Faceted Search Page

35. 36 Copyright © 2023, Oracle and/or its affiliates Practicing a Modernization Orders Form apex.oracle.com/go/forms2apex-app

36. Copyright © 2023, Oracle and/or its affiliates 37 Useful Blog Posts apex.oracle.com/go/reasons-forms apex.oracle.com/go/forms-faq

37. Primary site apex.oracle.com Modernizing Oracle Forms apex.oracle.com/go/Forms2APEX APEX Shortcuts apex.oracle.com/shortcuts Blog apex.oracle.com/blog Tutorials apex.oracle.com/ hols Download apex.oracle.com/ otn Useful Links Copyright © 2023, Oracle and/or its affiliates 22

38. Thank you Text Text 39 Copyright © 2023, Oracle and/or its affiliates