Oracle APEX (Application Express) 24.2 continues to revolutionize low-code development by introducing innovative tools and enhancements tailored to streamline development workflows and elevate application capabilities. Here’s a comprehensive dive into the latest features in this release.
1. Harnessing Advanced AI Integration
Oracle APEX 24.2 empowers developers with an array of AI-driven capabilities that redefine application design and development processes:
Retrieval-Augmented Generation (RAG) Sources
Developers can integrate real-time, context-sensitive data sources like SQL queries, function outputs, and static text into the AI Assistant. These sources dynamically adapt based on user interactions, enabling highly personalized application behavior.
AI Configurations Shared Component
A centralized repository for managing AI components allows developers to configure system prompts, welcome messages, and dynamic RAG sources. These settings integrate with actions like “Show AI Assistant” or APIs such as APEX_AI for seamless AI-based workflows.
Dynamic Actions for AI
With the “Generate Text with AI” action, developers can automate content creation, translation, and summarization tasks directly within applications, reducing manual effort and enhancing user engagement.
Natural Language Schema Design
AI tools in SQL Workshop assist in crafting database schemas, tables, and triggers from natural language descriptions, providing an intuitive and efficient way to design databases.
Vector Search Integration
APEX now includes vector search capabilities via Oracle Database 23.ai, enabling applications to perform semantic similarity searches that retrieve results based on intent rather than exact matches.
2. Simplified JSON Data Management
The new JSON-centric enhancements make it effortless to handle complex data structures in modern applications:
JSON Sources Shared Component
Reusable JSON data sources can be created from database tables or specialized views, like Duality Views in Oracle Database 23.ai, allowing for simplified data integration.
Automatic Data Profiles
APEX auto-generates data profiles for JSON sources, mapping nested JSON structures into tabular formats without requiring custom parsing logic.
Declarative Integration
Reports, forms, and charts can now directly connect to JSON sources, enabling developers to declaratively build components on top of JSON data.
DML Operations for JSON
Full DML support ensures that JSON-based forms and grids integrate seamlessly, with changes applied to JSON data using powerful JSON_TRANSFORM operations.
Shared Hosting is an entry-level type of Oracle APEX hosting in which multiple websites are hosted on a single physical server. https://www.maxapex.com/apex-shared-hosting/
3. Workflow Enhancements for Streamlined Automation
APEX 24.2 refines its workflow capabilities with updates designed for flexibility and scalability:
Invoke Nested Workflows
Workflows can now call other workflows, encouraging modularity and simplifying the design of complex processes.
Resumable Workflows
Administrators can restart workflows at any designated activity, allowing efficient handling of errors or manual interventions.
Cross-Application Workflow Replication
Copy workflows between applications with ease, ensuring consistent logic and reducing development overhead.
Modernized Workflow UI
New templates for human task and workflow pages provide improved layouts and interactivity, making workflows easier to use and customize.
4. Expanded Oracle Fusion Applications Integration
Oracle APEX 24.2 strengthens enterprise application development through robust Fusion Applications integration:
- Enhanced API Compatibility: Direct integration with the latest Fusion REST APIs, including /api/boss endpoints, ensures applications can read from and write to Fusion data effortlessly.
- Fusion Integration Starter App: A pre-configured starter application simplifies the process of building applications connected to Oracle Fusion, accelerating time-to-value.
5. Universal Theme Enhancements for Next-Level UI
The Universal Theme continues to evolve, offering features that simplify design and enhance visual appeal:
- Font APEX 2.4: Includes 250+ colorful country flag icons, expanding the visual toolkit for developers.
- Content Row Grouping: Improved tools for organizing components within pages create cleaner, more accessible layouts.
- Multi-Avatar Regions: New avatar region options allow for visually dynamic user personalization.
- Utility Classes: Additional prebuilt CSS classes simplify styling tasks, reducing reliance on custom stylesheets.
- Password Field Toggle: Users can reveal or hide passwords in forms, a usability feature long-requested by developers.
Oracle APEX Dedicated Hosting (DedicatedDB) is the most flexible hosting plan for Oracle APEX. https://www.maxapex.com/apex-dedicated-hosting/
6. Accessibility and Monitoring Enhancements
Oracle APEX 24.2 reinforces its commitment to accessibility and application insights:
OAG 3.2 Compliance
The Builder and applications meet the latest Oracle Accessibility Guidelines, improving support for assistive technologies, live regions, and semantic HTML structures.
OpenTelemetry Integration
Track client-side application telemetry to analyze performance, user behavior, and potential issues. This data integrates with existing monitoring tools for comprehensive visibility.
7. Developer-Centric Improvements
APEX 24.2 enhances developer productivity with a suite of practical tools and updates:
- Application Dependency Reports: Visualize object dependencies across workspaces to manage references effectively.
- Cross-Workspace Page Management: Pages can be imported and exported across different workspaces, improving collaboration.
- Enhanced List Management: An updated interface makes editing and viewing lists faster and more intuitive.
- Resizable Modal Dialogs: Page Designer now supports resizable modal dialogs for better workspace optimization.
8. Interactive Reports and Document Generation
Interactive Report Enhancements
Improved filtering, customization, and visualization options make handling large datasets more intuitive and engaging.
Document Generator Updates
Support for Excel templates as report layouts adds versatility to document creation, including outputs in DOCX, PDF, and XLSX formats.
Conclusion
Oracle APEX 24.2 is a landmark release that solidifies its position as a leader in low-code development. From AI-driven automation and JSON integration to workflow advancements and theme enhancements, this update equips developers with everything needed to build scalable, secure, and user-centric applications.
Dive into Oracle APEX 24.2 today and explore how these innovations can transform your development process and applications!
Quality services and responsive professional support are the advantages I have with MaxAPEX. THANKS
I can’t say enough good things about MaxAPEX, I’ve relied on their hosting services for several years now and they’ve simply never let me down. Whenever issues have arisen, their support team is always incredibly prompt and helpful in their responses. I use their services to manage a portfolio of cloud-based databases and apps, as well as some on-premise management too, and their affordable support has removed so much of the technical overheads and allowed me/my teams to focus on development. If you’re in the market for APEX hosting, simply look no further.
Excellent service, high availability and very good price-value ratio. 100% recommended
Very nice company, excellent service, very good price-value ratio and amazing amazing support!
MaxAPEX Team is Always Ready and on the Time.
I have asked a lot from MaxAPEX this weekend but as always great work. There is only one Apex hosting company for me and that is MaxAPEX. great work!
I continue to be impressed by the always excellent support provided by MaxAPEX, thanks again.
I appreciate both the quickness and the proactive nature of how my MaxAPEX tickets are resolved. You clearly have a well qualified Oracle staff.
I am always impressed by how much time your support team are prepared to spend on my problems. Well done, as usual!
Great. It is is so nice to work with someone who knows their stuff.
Great response time and very to the point responses. very much appreciated.
You guys are awesome! Thank you for always providing such wonderful speedy support.
Gave a great answer and ticket could be closed immediately.
Excellent,
I always can depend on MaxAPEX for Super Fast Response and to the point response.
Excellent response time and got to the solution quickly. Thank you.
Awesome, in a very short timeframe, my problem was resolved, even on Saturday night
As soon as I clarified which schema I was having trouble accessing, the connection information was sent to me with a screen shot of exactly how to set it up. Excellent!
Great Job guys, app was working again not long after my request. Thanks
I was very satisfied with the way my request was handled in a very timely manner
As always the support is great! Fast and efficient. Thanks with 5 *****
We really appreciate the quick and effective response to our issue.
Very quick and adequate response !
Great support, as ever with MaxAPEX.
Very prompt and to the point which is great, thanks.
The response was amazing! The problem was resolved within a very few minutes of opening the ticket.
Support on this ticket was excellent. The help on this ticket made me feel sure MaxAPEX was an excellent choice.
Quick response to my request, understood my issue and fixed it on the spot. Great work, thanks for your help
Outstanding response time! He handled this request quickly and completely.
Excellent support. Thank you
My query was well understood and was answered very fast and with all the clarity needed. As always, excellent service from MaxAPEX. Thank you!
Like always, your support is always best in class. I appreciate this.
Just did a great job – thanks. Please keep it up!
It was a easy task, but what I really appreciate is that the issue was solved in minutes. Keep on the good work!
It is solved now, very happy with the support. Keep up the good work.
I think it is great how MaxAPEX responses to my tickets, even in the evening and during the weekends.
All of the guys provided great support for our server migration. We appreciate the hard work and dedication.
Team was able to provide me with solutions to my problem, of which i am very grateful for. Well done!
Great support, gave me information to fix a performance issue.
We are very happy to using max apex hosting. they are support very nice and prompt. i recommend APEX user to use their hosting
MaxAPEX support is very good. I have never experienced a situation where they have not been able to help or where the work was not completed very quickly.
Excellent service, full cooperation of support staff and good cloud performance.
In mid-2013 I started looking for a hosting service that could house my project of serving small businesses with specialized system solutions developed on Oracle Apex that meet the need of this market share. I found Maxapex and since then we have established this partnership with excellent cost benefit and high quality services available. Thank you Maxapex for the excellent services provided over these 6 years.
I’m glad I decided to work with you. I never have any problem at all. Thanks so much for doing a great job!
I Have been using Maxapex Service since couple of years. The most thing that attracted me, their instance support and response at any time. Hope to continue this support in future in more improve way.
We appreciate the incredible support MAXAPEX team have provided for us.
We got help with things like that linux configuration, establishing odbc connection that are not strictly related to server hosting. This is the best value for money service on this area.
Maxapex is the perfect choice for hosting Oracle Apex. The support service is speedy and responsive. We did not have a situation where they could not help. You can quickly change your tariff plan to the most suitable one. Server uptime is excellent. We did not have a situation when our business was suspended.
MaxAPEX , really facilitate my start with apex by making it Jump , the team is very helpful and understanding people , ‘I’ve passed more than 3 years with max apex and i feel happy with their support and their services
Hi, my name is Roberto Párraga. I’m developer in Oracle Apex with Oracle Database XE.
My expririence with MaxAPEX is successfully, because helpme to developer and deploy successfully my applications.
The technical support is excellent because my questions got quicly responses.
The stability of the hosting service and the continuous it’s wanderfull, 24/7.
In abstract, I recommend MaxAPEX Hosting for deploy applications developed in Oracle ApeX.
We found MaxAPEX’s technical support team very cooperative, quick & responsive. Hosting services are very much reliable, we never even think about switching to another company.
We have been using Oracle APEX hosting from MaxAPEX for almost 7 years now. I can recommend it as the service, level of expertise and support is really good. We host several Apex web applications with MaxAPEX for our customers that are mainly schools. The users and schools are depending on our Apex Apps with MaxAPEX to execute quality checks which are needed by the Ducth law. An other web app helps teachers during class to track, help and administrate students. As you can imagine it is very important for us that the MaxAPEX servers are fast and reliable which they are. Keep up the good work MaxAPEX.
One of the best oracle apex hosting i have ever used. You guys rock, very fast and active when it comes to ticket solving. Keeo up the good work. I have recomended to many Colleagues and customer about maxapex.
We looked for a company who offers APEX hosting about 2 years ago. We found MaxAPEX and were suprised about the portfolio and the pricing. So we started to use their platform with our CRM system developed on Oracle APEX.
We rate the availability, the update policy and the speed/quality of the support with five stars.
Thank you very much!
Steven Ponndorf
Excellent company!
Great service! are fast and efficient … Congratulations!
I am a MaxAPEX customer for several years now. My company inventory, stock control and invoicing system done using Oracle APEX is hosted with MaxAPEX. These guys have the best support system and a very reliable up-time. Every upgrade and maintenance is always notified in advance, so our IT team is aware to let the other team members know. My 10/10 recommendation goes to MaxAPEX!!!
I have been using MaxAPex for several years, in various configurations (shared, dedicated etc) and I have never had any issues with the serivce. Further, I find the support very responsive and very good. I have no issues with using MaxAPEX as a platform for my live customers. Using this service just takes away so much Oracle Admin headache etc. I would highly recommend MaxAPEX as a hosting partner for any Apex Applications.
As part of a volunteer organisation, I was looking for a service to help solve a big problem for us which was the hours of admin involved in running a local community centre. Services are affordable and scalable and responses to my questions were swift and the support team have been amazing in helping me get what I needed. Upgrades are managed and as an Oracle partner, these guys ensure we are running the latest and greatest and soon as it’s available. Overall I have been very happy with performance too as well as the option to host within the UK. I have managed in a very short time to release an app to our community where most of the admin is now done by them, we’ve set up over 800 events this year, cut invoicing down from one day to 15 mins per quarter and automated several other processes. We have integrated with Stripe and Twilio too!
We have been working with MAXAPEX for approximately 5 years. We have 3 mission critical applications operating in their infrastructure. The service offered by MAXAPEX has been optimal for our needs, and has allowed us to grow as we have required. Their support is excellent, and has allowed us to really concentrate on satisfying the needs of our business.
I have used MaxAPEX for over ten years now and found them to be both practical and extremely reliable. Equally impressive is their competent and timely response to my occasional questions and service tickets.
As an APEX developer, having full control of an entire Oracle XE instance gives me lots of options and because it is professionally supported by MaxAPEX I never have to worry about Oracle upgrades or new versions. I also appreciate the fact that it is physically located in a data center with fast Internet access both in and out. This is something a small company like mine cannot easily do on our own.
Thanks, MaxAPEX, for providing this valuable service at a cost I can afford.
I have been a MaxAPEX customer since 2015. It is a very stable, reliable, and fast platform. The support is excellent and very timely. It is always updated to the latest versions. In MaxAPEX we have hosted all our systems and we are extremely satisfied, I highly recommend them.
