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.

Miniature figures make construction repairs to a keyboard.APEXBusiness
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 DirectorAPEXBusiness
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 APEXAPEX
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.
APEXTechnical
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.”ITOracleTechnical
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.APEXBusinessIT
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-CodeAPEXBusiness
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.APEXBusiness
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.APEXBusinessTechnical
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 formAPEX
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 formAPEX
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.APEX
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 testsBusinessTechnical
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 menuAPEXTechnical
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 thoughtOracle
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 stampAPEXOracleTechnical
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…
APEXOracleTechnical
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 IE11BusinessIT SecurityOracle
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-blurredAPEXITOracleTechnical
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 ContributorInterviews
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXGuest ContributorITTechnical
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…
APEXITTechnical
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…
APEXITTechnical
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…
APEXTechnical
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…
AnnouncementsAPEXBusinessCase StudiesCase StudiesIT
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 StudiesTechnical
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 thoughtInterviews
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 thoughtInterviews
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…
APEXITTechnical
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…
APEXCommunicationInterviewsITTechnical
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…
APEXCommunicationInterviewsITTechnical
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…
APEXTechnical
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…
APEXCommunicationInterviewsITTechnical
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…
APEXTechnical
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,…
APEXITIT SecurityTechnicalTechnical
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…
APEXOracleTechnical
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 LogoAPEXTechnical
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…
APEXTechnical
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 mapAPEXTechnical
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…
APEXOracleTechnical
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 thought
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 meetingAPEXITOracleTechnical
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 MobilityTechnical
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 Mobility
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 Mobility
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 consultingAPEXTechnical
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 MobilityIT
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 oracleAPEXTechnical
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 hardhatAPEXITTechnical
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 MobilityIT
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 cablesAPEXBusinessEnterprise MobilityIT
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.