Skip to main content

Oracle APEX Academy

Here at Traust, we’re passionate about Oracle APEX — #orclapex for those in the know — and consistently use it to build enterprise web applications for our clients. Whenever we discover new APEX tips and tricks, we love sharing them with the rest of the community.

Oracle APEX screenshot showing the updated SQL query.APEXOracleTechnicalThe Amazing API: IS_COMPONENT_USED in Oracle APEX
November 26, 2024

The Amazing API: IS_COMPONENT_USED in Oracle APEX

In this blog post, we will be working through a case study on how to use APEX_PLUGIN_UTIL.IS_COMPONENT_USED in Oracle APEX. This amazing function can save you a lot of work…
Screenshot of code for adding a member to an Oracle APEX collection.APEXTechnicalExploring Oracle APEX Collections
October 31, 2024

Exploring Oracle APEX Collections

Oracle APEX collections provide developers with powerful tools for managing temporary data, enhancing workflows, and improving app performance. This guide covers essential features, practical use cases, and strategies to maximize…
Screenshot announcing Oracle EBS 12.2.14 at Cloud World 2024OracleAPEXITTechnicalWhat to Expect in Oracle EBS 12.2.14: Key Enhancements for Your Business
September 12, 2024

What to Expect in Oracle EBS 12.2.14: Key Enhancements for Your Business

The new Oracle EBS 12.2.14 offers improved ERP functionality, tighter APEX integration, and enhanced customization tools.
A mathematically generated set of colors that passes accessibility contrast tests.APEXCreating an Accessible Color Palette for Oracle APEX Universal Theme
August 13, 2024

Creating an Accessible Color Palette for Oracle APEX Universal Theme

Learn how to select colors that meet contrast accessibility standards, customize themes for better usability, and ensure WCAG compliance for your Oracle APEX applications.
The Traust development team talks to Kscope24 attendees in the exhibit hall.APEXBusinessInnovation, Engagement, and Growth in the Oracle APEX Community: Key Takeaways from Kscope24
July 25, 2024

Innovation, Engagement, and Growth in the Oracle APEX Community: Key Takeaways from Kscope24

ODTUG Kscope24, held in Nashville, TN, July 14–18, was a vibrant gathering of more than 500 attendees from various industries, including healthcare, aerospace, manufacturing, financial services, higher education, and government.…
Mini figures clean up pencil shavings, representing the work involved in creating an Oracle Forms to APEX migration plan.ITAPEXBusinessTechnicalOracle Forms to APEX Migration: What You Need to Create a Successful Plan
July 18, 2024

Oracle Forms to APEX Migration: What You Need to Create a Successful Plan

In this follow-up to our previous article on how to migrate from Oracle Forms to APEX, we're diving into the nitty-gritty details you'll need to ensure a smooth transition. For…
APEXCelebrating Success: Traust Developers Achieve Oracle APEX Cloud Developer Professional Certification
June 6, 2024

Celebrating Success: Traust Developers Achieve Oracle APEX Cloud Developer Professional Certification

Traust is excited to announce that three of our dedicated Oracle APEX developers—Andrew Schultz, Luke Rohde, and Stephen Piper—have successfully completed the Oracle APEX Cloud Developer Professional certification exam. Their…
Traust to exhibit at ODTUG's Kscope24 in Nashville, TN.AnnouncementsAPEXBusinessTraust to Exhibit at Kscope24 in Nashville, TN
May 9, 2024

Traust to Exhibit at Kscope24 in Nashville, TN

Traust is proud to announce our sponsorship of Kscope24, North America's premier Oracle APEX conference, July 14-18, 2024, in Nashville, TN.
Migrate Oracle Forms to APEX: Miniature figures make construction repairs to a keyboard.APEXBusinessNavigating the Shift: A Strategic Approach to Migrate Oracle Forms to APEX
February 22, 2024

Navigating the Shift: A Strategic Approach to Migrate Oracle Forms to APEX

Discover the strategic approach to migrate Oracle Forms to APEX, enhancing your applications with modern functionalities and user experiences. This guide offers insights into the migration process, benefits, and how…
David Lopez Abugattas, Oracle APEX Practice DirectorBusinessAPEXWelcoming David Lopez Abugattas to Traust: Our New Oracle APEX Practice Director
February 12, 2024

Welcoming David Lopez Abugattas to Traust: Our New Oracle APEX Practice Director

Traust is pleased to announce the addition of David Lopez Abugattas as our new Oracle APEX Practice Director. In this role, David will be focused on the growth and maturity…
User-defined colors in Oracle APEXAPEXChange Select List Color in Oracle APEX Based on User-Defined Colors
February 1, 2024

Change Select List Color in Oracle APEX Based on User-Defined Colors

Learn how to let users define a list of colors that can then be used to dynamically change the color of a select list in Oracle APEX.
APEXTechnicalLink to a Specific Tab in Oracle APEX with JavaScript
December 21, 2023

Link to a Specific Tab in Oracle APEX with JavaScript

In this Oracle APEX tutorial, learn how to link to a specific tab on another page within APEX using JavaScript. With this process, you're directly improving the user experience –…
Quote from Juan Loaiza Executive Vice President, Mission-CriticalDatabase Technologies, Oracle: “By adding AI vector search to Oracle Database, we help customers to quickly and easily get the benefits of artificial intelligence without sacrificing security, data integrity, or performance.”OracleITTechnicalOracle Database 23c: Empowering Developers with AI-Enhanced Features
October 26, 2023

Oracle Database 23c: Empowering Developers with AI-Enhanced Features

Oracle recently announced that Oracle Database 23c will empower developers to utilize generative AI, simplifying enterprise application development. Learn how these AI capabilities enhance security, performance, and cost-efficiency.
Unlocking the benefits of Oracle APEX: abstract image of a key with locks.APEXBusinessITUnlocking the Benefits of Oracle APEX: 10 Reasons Why You Should Already Be Using this Free Resource
October 12, 2023

Unlocking the Benefits of Oracle APEX: 10 Reasons Why You Should Already Be Using this Free Resource

In the ever-evolving realm of modern business, companies are constantly striving to improve their back-end systems to stay competitive and meet customer demands. Oracle APEX is a powerful, accelerated development…
Extending ERP, EPM, SCM, and HCM Operations with Oracle APEX Low-CodeBusinessAPEXExtending ERP, SCM, EPM, and HCM Operations Using the Oracle APEX Low-Code Platform
September 27, 2023

Extending ERP, SCM, EPM, and HCM Operations Using the Oracle APEX Low-Code Platform

For IT managers and directors handling complex operations in manufacturing, supply chain management, and other enterprises, leveraging technology is critical to driving efficiency — and success. If your company relies…
Traust team — Dan Hogan, Andrew Schultz, and Stephen Piper — attending the 2023 ODTUG Kscope Conference.APEXBusinessExtending ERP and SaaS Environments: Insights from the 2023 ODTUG Kscope Conference
July 17, 2023

Extending ERP and SaaS Environments: Insights from the 2023 ODTUG Kscope Conference

The 2023 ODTUG Kscope conference in Aurora, CO recently concluded, bringing together a vibrant community of Oracle experts, professionals, developers, end users, and enthusiasts. I had the pleasure of attending…
Measurements from a digital caliper can be used to calculate CPK for precision manufacturing.APEXBusinessTechnicalHow to Calculate a CPK in Oracle APEX
April 20, 2023

How to Calculate a CPK in Oracle APEX

In this article, Traust developer Stephen Piper explains how to use Oracle APEX to calculate CPK — process capability index — a critical metric for precision manufacturing.
3 new formAPEXAutomated Emails with HTML Formatting
February 14, 2023

Automated Emails with HTML Formatting

In the final article of our series on email in Oracle APEX applications, we show how we can easily incorporate basic HTML elements to send a better looking, more accessible…
5 point message formAPEXAutomated Emails with Dynamic Messages
February 7, 2023

Automated Emails with Dynamic Messages

In part 2 of our series on email in Oracle APEX applications, we show how to produce unique welcome messages to new Employees depending on which Department they work in.
You can see all of the department employees, along with their email addresses.APEXEmail All Users in an Oracle APEX Report
January 31, 2023

Email All Users in an Oracle APEX Report

In the first of a three-part series detailing advanced techniques for utilizing email in your Oracle APEX applications, we show you how to send a message to all the addresses…
two software developers working reviewing software testsBusinessTechnical6 Types of Tests All Business Software Must Pass
October 6, 2022

6 Types of Tests All Business Software Must Pass

Most of us realize that testing is vital to the software development process. You have to make sure the thing works, right? But what many don’t realize is that software…
Screenshot showing Scatter chart type selected in Oracle APEX dropdown menuAPEXTechnicalHow to Add Charts in Oracle APEX
August 25, 2022

How to Add Charts in Oracle APEX

In this demo, software developer Stephen Piper shows you how to create charts using the built-in chart functionality in Oracle APEX.
Logo for ODTUG KSCOPE 2022 in Grapevine, TXAPEXFood for thoughtOracleKey Takeaways from ODTUG Kscope 2022
August 11, 2022

Key Takeaways from ODTUG Kscope 2022

Members of the Traust team enthusiastically attended ODTUG Kscope 2022 held June 19–23 in Grapevine, TX — the first one to be hosted in-person since 2019. ODTUG Kscope bills itself…
Copyright notice stampAPEXOracleTechnicalCreating a Dynamic Copyright Notice in Public-Facing APEX Applications
May 19, 2022

Creating a Dynamic Copyright Notice in Public-Facing APEX Applications

Most websites and web-based applications are built on original intellectual property that needs to be protected using a copyright notice. Over at Love2Dev.com, Chris Love has created a nice explainer…
APEXOracleTechnicalA printer friendly template for the APEX Universal Theme
January 13, 2022

A printer friendly template for the APEX Universal Theme

The printer_friendly output of multi-page reports in the APEX Universal Theme can be reactivated with a custom page template, a menu entry, and by printing with a jQuery plugin. These…
Businessman uses Oracle EBS software with IE11IT SecurityBusinessOracleWhat the Death of Internet Explorer Means for Oracle E-Business Suite Users
June 10, 2021

What the Death of Internet Explorer Means for Oracle E-Business Suite Users

On May 19, Microsoft announced that it would be ending support for Internet Explorer (IE) 11 starting in June 2022. This move is a long time coming. In 2015, Microsoft…
cdl-blurredAPEXITOracleTechnicalProducing a Report from a Colon Delimited List in Oracle APEX
May 13, 2021

Producing a Report from a Colon Delimited List in Oracle APEX

Being a data-driven company means dealing with, well, data. But it's not enough to just have the data — you also have to be able to use it effectively. This…
Oracle APEX interview with Jackie McIlroyAPEXCommunityGuest ContributorInterviewsInterview with Jackie McIlroy, APEX Boss
April 12, 2021

Interview with Jackie McIlroy, APEX Boss

Our next guest appearance from the Oracle APEX world is Jackie McIlroy, Director of Product and Client Services at United Codes and APEX content chair for ODTUG’s KSCOPE event. It is…
APEXITTechnicalSetting the Value of a Popup LOV Page Item via IG
April 5, 2021

Setting the Value of a Popup LOV Page Item via IG

This blog will teach you about how to set the value of Popup LOV page item with an Interactive Grid Dynamic Action in Oracle APEX Many times we wish to…
APEXITTechnicalRead-Only/Disable Switch Widgets in Oracle APEX
March 16, 2021

Read-Only/Disable Switch Widgets in Oracle APEX

This blog will show you how to implement read-only and disabled switch widgets in Oracle APEX.  Unlike other page items, the switch widget is more tricky because it transforms when…
APEXITTechnicalLose Focus DA and Submit Page in Oracle APEX
March 10, 2021

Lose Focus DA and Submit Page in Oracle APEX

This blog will show you how to get around a problem with the Lose Focus event in Oracle APEX.  It isn't as though the event doesn't fire, but in some…
APEXITTechnicalDisable IG Column in Oracle APEX
February 10, 2021

Disable IG Column in Oracle APEX

This blog will show you how to disable a column in an interactive grid (IG) in Oracle APEX. Imagine a situation where we have a page that has a form…
APEXITTechnicalConditional Error Button on IG in Oracle APEX
December 8, 2020

Conditional Error Button on IG in Oracle APEX

This blog will teach you how to conditionally render an error button on an Interactive Grid (IG) in Oracle APEX. To review some of the techniques used and learn about…
APEXITTechnicalConditionally Change Select List Color in Oracle APEX
December 1, 2020

Conditionally Change Select List Color in Oracle APEX

This blog will teach you how to conditionally change the background color of a select list in Oracle APEX.  We will be focusing on a select list and changing the…
APEXITTechnicalCascading LOV with a Popup in Oracle APEX
November 19, 2020

Cascading LOV with a Popup in Oracle APEX

This blog will teach you how to create a cascading list of values (LOV) using Shared Components of Oracle APEX. After that, we will show you how to implement the cascading…
APEXITTechnicalRandomize an Oracle APEX Login Page Background
November 12, 2020

Randomize an Oracle APEX Login Page Background

This is a blog post about customizing the background of an Oracle APEX login page so that it doesn't appear so static. We will show you how to randomize background…
TechnicalAPEXGuest ContributorITCentralizing List of Values (LOVs) in Oracle APEX
October 29, 2020

Centralizing List of Values (LOVs) in Oracle APEX

Oracle Application Express (APEX) allows developers numerous of ways to make use of List of Values (LOVs). These LOVs are often defined in the moment while the form is being…
TechnicalAPEXITOracle APEX JS Confirm and PL/SQL Dynamic Action
October 22, 2020

Oracle APEX JS Confirm and PL/SQL Dynamic Action

This blog is about how to use an Oracle APEX Dynamic Action to display a JavaScript (JS) confirm message and then run a subsequent PL/SQL block if confirmed. Example Scenario…
APEXITTechnicalDynamic LOV with a Subquery in Oracle APEX
October 15, 2020

Dynamic LOV with a Subquery in Oracle APEX

A dynamic List of Values (LOV) in Oracle APEX is used to fetch data that will be in a constant state of change.  For this blog, we will be examining…
TechnicalAPEXOracle APEX Application Import – Error Processing
September 30, 2020

Oracle APEX Application Import – Error Processing

This blog is about the "error processing condition" message that can occur when trying to import an Oracle APEX application in your workspace.  More likely than not, the cause of…
Case StudiesAnnouncementsAPEXBusinessCase StudiesITOracle APEX and Nonprofits – House of Charity
September 21, 2020

Oracle APEX and Nonprofits – House of Charity

This blog is about how Traust created an Oracle APEX app for the House of Charity nonprofit.  It is also about how other nonprofits could benefit from affordable technological solutions…
APEXCase StudiesTechnicalDiving into Master Detail Pages with APEX
September 10, 2020

Diving into Master Detail Pages with APEX

Related Tables This blog will give an overview of a recent experience with creating a Master Detail page in Oracle APEX.  For a new application, I had to create a…
APEXCase StudiesFeaturedFood for thoughtInterviewsOracle APEX Journey of Andrew Schultz: Part 2
September 2, 2020

Oracle APEX Journey of Andrew Schultz: Part 2

The Journey Continues Part 1 of my Oracle APEX journey ended on a cliffhanger.  Part 2 will conclude my first project in Oracle APEX. If you need a refresher on…
APEXCase StudiesFeaturedFood for thoughtInterviewsOracle APEX Journey of Andrew Schultz: Part 1
August 26, 2020

Oracle APEX Journey of Andrew Schultz: Part 1

Mission Start My Oracle APEX journey started in 2008 when I was still an undergraduate in college.  One day after class, the professor approached me and suggested I apply for…
APEXITTechnicalAPEX Beginners Guide: Build a Quick App
August 12, 2020

APEX Beginners Guide: Build a Quick App

Oracle APEX beginners can find their first project on their own to be a daunting task. In my previous post, "Five Things to Love About Oracle APEX," I ended with…
APEXCommunicationInterviewsITTechnicalFive Things to Love About Oracle APEX
August 6, 2020

Five Things to Love About Oracle APEX

This is my story of five things that I love about APEX, and a real-world example of how they helped me build my first production APEX application. The first three…
APEXCommunicationInterviewsITTechnicalLuke Rohde Joins the Traust Team
July 28, 2020

Luke Rohde Joins the Traust Team

Traust is very excited to announce the addition of Luke Rohde to the team. Luke is a recent graduate of Prime Digital Academy, where he developed a strong full-stack skill…
TechnicalAPEXOracle APEX Dynamic Action on a List View Element
July 23, 2020

Oracle APEX Dynamic Action on a List View Element

The List Views in Oracle APEX look fantastic, but it would be nice to extend the functionality of them by adding a Dynamic Action when an item is clicked.  To…
APEXCommunicationInterviewsITTechnicalLuke Rohde’s Experience Learning Oracle APEX
June 29, 2020

Luke Rohde’s Experience Learning Oracle APEX

One year ago, I made a major life change to leave a job I was happy with, and at a company that I loved.  That decision led me to pursue…
TechnicalAPEXOracle APEX Page isn’t Available Error
June 24, 2020

Oracle APEX Page isn’t Available Error

Oracle APEX introduced the friendly URLs feature in APEX 20.1. If you are not careful with your page naming conventions, this feature can cause a page rendering error of:  “Sorry,…
TechnicalAPEXITIT SecurityTechnicalSet Value without Violating Session State Protection in Oracle APEX
June 2, 2020

Set Value without Violating Session State Protection in Oracle APEX

Oracle APEX has built-in security that is incredible at preventing different unauthorized manipulation attacks. The benefits far outweigh the drawbacks, but there are some circumstances where it is necessary to…
APEXOracleTechnicalWish List of Improvements for Public-Facing Oracle APEX Sites
May 12, 2020

Wish List of Improvements for Public-Facing Oracle APEX Sites

The release of Oracle APEX 20.1 once again delivered a treasure trove of improvements for developers to make use of. I believe that the friendly URLs feature of 20.1 is…
Terminal Command LogoTechnicalAPEXOracle APEX Image Errors After an Upgrade
April 15, 2020

Oracle APEX Image Errors After an Upgrade

Common errors can occur when upgrading to a different Oracle APEX version.  Problems can range from JavaScript errors to images not loading properly.  There are guides from various sources to…
TechnicalAPEXOracle APEX Simple Login Page Theming
April 2, 2020

Oracle APEX Simple Login Page Theming

If somehow or someway, the job of theming content has fallen to you. Theming content is generally reserved for the more creative types, but if you don’t have the luxury…
oracle consulting napkin mapAPEXTechnicalOracle APEX Version Control from SQL Developer
March 4, 2020

Oracle APEX Version Control from SQL Developer

Though APEX Export commands have existed for years, I feel that the more recent added options have gone somewhat unnoticed.  If you’ve never attempted to do standard version control in…
APEXOracleTechnicalOracle APEX – Quick SQL Primary Key Generator
February 4, 2020

Oracle APEX – Quick SQL Primary Key Generator

Quick SQL in Oracle APEX is a wonderful tool that helps to generate SQL with shorthand syntax.  This blog highlights one minor change to the option of generating primary keys…
brainstorming oracle reports traust consultingAPEXFood for thoughtIt’s Good to Get Your Hands Dirty: The Power of Hands-on-Labs
January 28, 2020

It’s Good to Get Your Hands Dirty: The Power of Hands-on-Labs

In the fast-paced world we live in, it’s rather overbearing to read about all of the different products available for our consumption. Not only is there much of the same, but frequently…
traust twin cities round table meetingAPEXITOracleTechnicalCreate Dynamic Links for Interactive Reports in Oracle APEX
January 7, 2020

Create Dynamic Links for Interactive Reports in Oracle APEX

For the moment, Dynamic Actions aren’t directly integrated with Interactive Reports or Interactive Grids.  That can be problematic when you want to display dynamic content that will: Hide/Show depending on…
people meeting project oracleAPEXBusinessEnterprise MobilityTechnicalUniversal Buy-In with Data Visualization in Oracle APEX
December 3, 2019

Universal Buy-In with Data Visualization in Oracle APEX

One of the many reasons that spreadsheets are still heavily used in organizations across the spectrum is that it is a technology that allows end users to remain in control. …
brainstorming oracle reports traust consultingAPEXEnterprise MobilityHow Oracle APEX Can Help You Replace Old Spreadsheets
November 26, 2019

How Oracle APEX Can Help You Replace Old Spreadsheets

If you’ve been following our blog recently, you’ve noticed how passionate we are about Oracle APEX and all of its robust qualities and features. While it can serve in several domains, it’s easiest application of use is…
pen and paper oracleAPEXBusinessEnterprise MobilityGetting Started with APEX – Part II
November 12, 2019

Getting Started with APEX – Part II

Welcome to Part II of Traust’s ‘Getting Started with APEX’ series. After reading part one of this series, we assume you’ve completed some follow-up research and you’ve decided that APEX…
typing on computer Oracle EBS consultingAPEXTechnicalManaging the First Schema Provisioned in APEX
November 5, 2019

Managing the First Schema Provisioned in APEX

If you just wanted to create/assign a different schema to a workspace in APEX, that is easy to do, and there are plenty of resources to find that answer. However,…
traust mn data visualizationAPEXEnterprise MobilityITTaking the First Step(s) to Adopting Oracle APEX
October 30, 2019

Taking the First Step(s) to Adopting Oracle APEX

The buzzword has been flying around in the Twin Cities, especially, about the APEX technology that is included with every Oracle Enterprise Database. You’re in either one of two camps:…
pen and paper oracleAPEXTechnicalWorking with Checkbox Lists and Lookup Tables in Oracle APEX
October 1, 2019

Working with Checkbox Lists and Lookup Tables in Oracle APEX

For this example, I will show you how to work with colon separated lists created from using checkboxes in Oracle APEX. This is a solution for when your checkbox can…
oracle rlm tech in hardhatTechnicalAPEXITUser Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme
September 24, 2019

User Self-Registration in Oracle APEX: Using the Application Express Accounts Authentication Scheme

Self-Registration in Oracle APEX is not terribly common because most use cases involve users being managed by LDAP, database accounts, or single sign-on. When the above are not the case,…
traust mn data visualizationAPEXBusinessEnterprise MobilityITOracle Forms: Expectations vs Reality
September 18, 2019

Oracle Forms: Expectations vs Reality

For those of us who live and breathe ERP, talking about Oracle can bring up many pain points and PTSD around the laborious hours it took to get it up…
oracle forms network cablesBusinessAPEXEnterprise MobilityITAPEX + Autonomous
September 13, 2019

APEX + Autonomous

In Oracle’s June 2019 announcement, the company revealed that its flagship IaaS product, Autonomous Database, would now include APEX. As Oracle competes with Microsoft Azure, AWS, and industry-focused solutions for…

Are you passionate about APEX?

If you love Oracle APEX as much as we do and want to contribute to our blog, please reach out! We’re always looking to spread the love with the #orclapex community.