Technical insights on Oracle APEX, ORDS, EBS, and Cloud ERP
With Oracle Integration 3 (Gen 3) projects now configurable as MCP servers, the pieces are coming together for agentic AI to handle the repetitive orchestration of ERP operations. This post explores what becomes possible when you connect conversational AI to your Oracle Financials environment.
Read moreAI-assisted development has collapsed the cost and timeline of custom software. For enterprise IT leaders, the build vs. buy equation has fundamentally shifted, and the case for owning your technology stack grows stronger every quarter.
Read moreLearn how to use Oracle APEX's APEX_WEB_SERVICE package to create and manage OKTA users via REST API, enabling programmatic user provisioning from your APEX applications.
Read moreLearn how to integrate Oracle APEX and ORDS with Microsoft Teams using Inbound and Outbound Webhooks to send rich messages and create simple chatbots.
Read moreDiscover how to integrate Oracle APEX with Microsoft Office 365 services using the MS Graph API, including Azure AD sign-on, SharePoint file storage, and OneDrive integration.
Read moreThe Pre-Production Release of APEX 20.2 is now available on apex.oracle.com! In this article, we'll have a look at the new REST Data Source Synchronization feature which will be super handy when using APEX to extend ERP Cloud.
Read moreWith the evolution of ERP Cloud and Oracle Cloud Infrastructure (OCI), we are starting to see ERP Cloud utilize OCI features. In this post I will cover how you can leverage more from this integration using OCI Events and Notifications.
Read moreBy now, most people have heard about Robotic Process Automation (RPA) tools. In this post I will describe a real-world example where APEX automates and orchestrates a repetitive e-Business Suite process, and why APEX may be a better choice than traditional RPA tools.
Read moreIn this final part of our blog series, we show you how APEX will make your ERP Cloud conversions simpler, faster and repeatable with real-world examples including employee conversion and PO change orders.
Read morePart 2 of our ERP conversions series discusses tools available in ERP Cloud and highlights associated challenges. We review ADFDi, FBDi, SOAP and REST web services, HCM Data Loader, BI Publisher, and BI Cloud Connector.
Read moreThis is the first in a two-part post on how to use APEX to facilitate data conversions (and data uploads) into Oracle e-Business Suite (EBS) and Oracle ERP Cloud. In this first post, we will focus on Oracle e-Business Suite (EBS).
Read moreSince the weekend we started our business (when we built our time sheet application in APEX) through to our most recent push to replace Jira Service Desk with an APEX App, we have been using APEX to solve our own business problems as well as our customer's.
Read moreIn May 2019, Google announced upcoming cookie handling changes. By February 2020, Chrome version 80 began rolling out these modifications. This post covers the impact on APEX applications running in iframes and how to work around it.
Read moreOne minor drawback of the Popup LOV (introduced in APEX 19.2) is that it seems to be impossible to quickly clear an existing value via the keyboard. In this post I will review an alternative where we can clear an existing Popup LOV value using the Delete key by creating a simple Dynamic Action.
Read moreSince APEX 18.1, there is a much better way to call OAuth2 Client Credentials secured web services. This method eliminates the need for developers to manage OAuth2 credentials and token expiration manually.
Read moreThe APEX_DATA_PARSER PL/SQL package was introduced in APEX 19.1. It comes from a long line of useful APIs produced by the APEX development team. APEX_DATA_PARSER solves a number of challenges with loading file based data that I have faced throughout my Oracle career.
Read moreIn this post I will demonstrate a useful feature of APEX that does not get a lot of attention: User Preferences. It's another one of those APEX features that saves you time and allows you to focus more on building important business logic.
Read moreOracle REST Data Services (ORDS) provides many options for authenticating users. While it is important to ensure your ORDS web services are secured, you also need to consider what a client has access to once authenticated. In this post, I dive into roles and privileges and explain their part in authorizing access to ORDS web services.
Read moreFull disclosure, I have absolutely no experience in trying to convince my boss to try APEX or ORDS. I do, however, have experience in basking in the glow of clients who have reaped the benefits of implementing mission critical systems using these two no-cost options of the Oracle database.
Read moreAPEX Email Templates, introduced in APEX 18.1, provide real value to developers and end users. In this post, I describe how we used them for much more than email templates when building a notification framework for a customer.
Read moreAPEX Social Sign-In undersells the actual scope of authentication capabilities available in Oracle APEX. While the feature supports Google and Facebook authentication, it extends far beyond social login to enterprise identity management solutions like Okta and Auth0.
Read moreREST enabled SQL was first introduced in ORDS 17.4. It is an important feature in the continued evolution of ORDS as a product. In this post I compare it to GraphQL and demonstrate how RAD stack developers can achieve similar benefits.
Read moreThis post explores using Oracle APEX to modernize Oracle e-Business Suite interfaces without significant additional costs. APEX can bring modern user experiences to aging ERP systems.
Read moreAPEX Office Print (AOP) is a solution for generating formatted documents in Word, Excel, PowerPoint, HTML, and plain text. This post explores whether AOP is the printing solution APEX developers have been waiting for.
Read moreAPEX is obviously a database centric product. Even so, there are times when we may want to limit round trips to the server. In this post I will talk about Web Storage, the apex.storage JavaScript API and how they can help persist information locally.
Read moreThis post discusses integrating Twilio SMS messaging with Oracle e-Business Suite using ORDS to notify employees about expiring certifications, including architecture and best practices.
Read moreThis post emphasizes developing APEX applications with consideration for maintenance, upgrades, and ROI rather than simply showcasing features. Complexity should serve a purpose.
Read moreKey takeaways from the ODTUG KSCOPE 2018 conference, including the introduction of the Oracle RAD Stack, APEX automation, mobile features, and Oracle Database 18c XE.
Read moreIn this post I will discuss three key features in Oracle APEX 18.1 that position APEX as a leading cloud development platform: REST Web Source Modules, REST Enabled SQL, and Social Login.
Read moreIn this post I will discuss implementing Oracle REST Data Services (ORDS) for native iOS mobile applications accessing Oracle E-Business Suite data, including architecture, security, and best practices.
Read moreThis post explores how ORDS can be leveraged for artificial intelligence applications, specifically building Alexa skills based on ERP data such as Oracle e-Business Suite and ERP Cloud.
Read moreThis post discusses extending Oracle ERP Cloud functionality through APEX as a Platform-as-a-Service solution, building custom pages that can be embedded directly into ERP Cloud.
Read moreJMJ Cloud documented a solution for implementing HMAC-SHA1 signatures in Oracle's Exadata Express, which lacks the DBMS_CRYPTO package available in Enterprise editions.
Read moreThis post discusses what to do with years of accumulated EBS data when migrating to newer systems. APEX provides an elegant solution for retiring legacy data while maintaining access.
Read moreThis article demonstrates using the PPM Cloud REST API to automate worker assignments to projects, addressing a common challenge in Oracle PPM systems where manual assignment maintenance becomes burdensome.
Read moreThis post describes a technique for implementing single-click actions on Oracle APEX 5.X interactive reports. Users can now take an action on a report via a popup and still maintain the context of the report.
Read moreThis post addresses storing Binary Large Objects (BLOBs) in Oracle's Storage Cloud Service rather than database columns, offering a practical alternative to traditional database storage.
Read moreA technical guide explaining how to create an instant modal dialog in Oracle APEX 5 that displays additional information without extra database round trips.
Read moreThis post addresses configuring Apache Tomcat for production use with Oracle APEX and ORDS. Out of the box, Tomcat comes configured for use in a development environment with several limitations.
Read moreStandard REST endpoints can utilize established documentation tools rather than Word or Excel. This post introduces spec-driven development using RAML with Oracle ORDS.
Read moreInstalling GlassFish and deploying Oracle ORDS is well documented. This post covers the production tuning steps needed for high volume systems.
Read moreAPEX was born for the Cloud given its web-based development environment and natural container in the Oracle Database. This post explores four primary use cases for APEX as a Cloud ERP PaaS solution.
Read moreThis post demonstrates integrating APEX pages into Oracle Cloud ERP using Page Integration and JWT authentication, creating powerful mashup capabilities.
Read moreRunning ORDS in standalone mode is not supported for production. This post compares Tomcat and GlassFish performance for APEX and ORDS workloads.
Read moreThis post discusses customizing APEX application login pages with a checkered background pattern similar to APEX 5's developer login page.
Read moreOracle REST Data Services implements REST-based services through four primary structures: schema, module, template, and handler. This post explains how they work together.
Read moreThis post provides guidance on performing an in-place upgrade of ORDS from version 3.0.5 to 3.0.7 within GlassFish.
Read moreORDS allows you to capture or expose data in an Oracle Database using the ubiquitous REST protocol. This post covers the fundamentals of ORDS and best practices for implementation.
Read moreThis post provides a comprehensive guide to accessing HTTP headers and bind variables in Oracle ORDS 3.x, updating earlier documentation from ORDS 2.x.
Read moreOWA_UTIL is a database package that provides access to PL/SQL Common Gateway Interface (CGI) variables. This post explains how to use it in ORDS handlers.
Read moreThis post provides a comprehensive guide to implementing OAuth2 client credentials (two-legged OAuth) security for Oracle REST Data Services.
Read moreOracle REST Data Services offers two approaches for third party OAuth2 authentication. This post explains how to change the default token expiry lifetime.
Read more