Create OKTA Users using REST - #JoelKallmanDay
Learn 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 moreBlog
Technical insights on Oracle APEX, ORDS, EBS, and Cloud ERP
Integrating APEX & ORDS with Microsoft Teams Messaging
Learn how to integrate Oracle APEX and ORDS with Microsoft Teams using Inbound and Outbound Webhooks to send rich messages and create simple chatbots.
Read moreExploring MS Graph (Office 365) APIs with Oracle APEX
Discover 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 moreAPEX 20.2 - First Look at REST Data Source Synchronization
The 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 moreOracle Cloud Infrastructure Events with APEX and ORDS
With 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 moreOracle ERP Robotic Process Automation (RPA) with APEX
By 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 moreOracle ERP Conversions Made Easy with APEX (Part 3)
In 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 moreOracle ERP Conversions Made Easy with APEX (Part 2)
Part 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 moreOracle ERP Conversions Made Easy with APEX (Part 1)
This 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 moreEating Your Own Dog Food is Easy with APEX
Since 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 moreUpcoming SameSite Cookie Changes and the Impact for APEX Apps Running in an iframe
In 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 moreClearing an APEX Popup LOV Value Using the Keyboard
One 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 moreSimplifying APEX_WEB_SERVICE & OAuth2 Client Credentials
Since 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 moreAPEX Data Parser (Data Load Made Easy)
The 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 moreAPEX User Preferences
In 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 moreUsing Roles and Privileges to Fine Tune Access to ORDS Web Services
Oracle 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 moreConvince Your Boss to Try APEX (and ORDS)
Full 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 moreWhen is an Email Template more than an Email Template? When it's an APEX Email Template
APEX 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 moreIt's Time for a New Name for Oracle APEX Social Sign-In
APEX 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 moreComparing Oracle REST Data Services (ORDS) and REST Enabled SQL to GraphQL
REST 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 moreModernizing Oracle e-Business Suite with APEX
This 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 – Is it the APEX printing solution we have all been waiting for?
APEX 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 moreUtilizing Browser Local Web Storage with Oracle APEX
APEX 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 moreSMS Messaging from Oracle ERP with ORDS and Twilio
This 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 moreBuild APEX Applications Responsibly
This post emphasizes developing APEX applications with consideration for maintenance, upgrades, and ROI rather than simply showcasing features. Complexity should serve a purpose.
Read moreODTUG KSCOPE 2018 RAD Stack Highlights
Key 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 moreHow Version 18.1 will help APEX win the Cloud
In 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 moreMobilize your Oracle Database with ORDS
In 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 moreTalk to Your ERP with Alexa and ORDS
This 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 moreERP Cloud PaaS Extensions using APEX
This 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 moreCode your own PL/SQL HMAC-SHA1 function
JMJ 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 moreRetire Your E-Business Suite Data in Style with APEX
This 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 morePPM Cloud REST API - Assigning Team Members using cURL
This 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 moreAPEX 5.X Interactive Report One Click Wonder
This 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 moreUsing Oracle Storage Cloud Service for APEX BLOBs
This 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 moreOracle APEX Instant Modal
A technical guide explaining how to create an instant modal dialog in Oracle APEX 5 that displays additional information without extra database round trips.
Read moreTuning Tomcat for APEX/ORDS in Production
This 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 moreSpec Driven REST with Oracle ORDS and RAML
Standard REST endpoints can utilize established documentation tools rather than Word or Excel. This post introduces spec-driven development using RAML with Oracle ORDS.
Read moreTuning GlassFish for Oracle APEX & ORDS in Production
Installing GlassFish and deploying Oracle ORDS is well documented. This post covers the production tuning steps needed for high volume systems.
Read moreOracle APEX as a Cloud ERP PaaS Solution
APEX 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 moreOracle Cloud ERP and APEX PaaS Mashup
This post demonstrates integrating APEX pages into Oracle Cloud ERP using Page Integration and JWT authentication, creating powerful mashup capabilities.
Read moreTomcat Vs GlassFish (Which is faster for APEX and ORDS)
Running ORDS in standalone mode is not supported for production. This post compares Tomcat and GlassFish performance for APEX and ORDS workloads.
Read moreOracle APEX Login Page - Checkered Background
This post discusses customizing APEX application login pages with a checkered background pattern similar to APEX 5's developer login page.
Read moreHow Oracle ORDS RESTful Services are Structured
Oracle REST Data Services implements REST-based services through four primary structures: schema, module, template, and handler. This post explains how they work together.
Read moreUpgrading ORDS from 3.0.5 to 3.0.7
This post provides guidance on performing an in-place upgrade of ORDS from version 3.0.5 to 3.0.7 within GlassFish.
Read moreORDS - What is it? How can I use it? How should I use it?
ORDS 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 moreORDS HTTP Headers and Variables Revisited for ORDS3
This 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 moreAccessing CGI Information from ORDS Handlers
OWA_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 moreORDS - Securing Services Using OAuth2 (Client Credentials)
This post provides a comprehensive guide to implementing OAuth2 client credentials (two-legged OAuth) security for Oracle REST Data Services.
Read moreORDS - Changing the default OAuth2 token expiry lifetime
Oracle REST Data Services offers two approaches for third party OAuth2 authentication. This post explains how to change the default token expiry lifetime.
Read more