Oracle APEX 26.1 UI/UX: Build Modern Enterprise Web Apps

In this episode we cover what UI/UX actually means in the context

of Oracle APEX enterprise development. You will learn the difference

between functional apps and professional apps, and why UI/UX is the

missing piece in most APEX projects. We walk through real examples

of bad vs good APEX UI and set the foundation for the entire course.

We install the Vendix POS application from scratch on Oracle APEX 26.1

on Autonomous Database. This is the real-world project we use throughout

the course to apply every UI/UX concept. You will get the complete APEX

export file and DB scripts to set up your own instance and follow along.

Learn how to build a professional CSS architecture inside Oracle APEX

using :root CSS variables as design tokens. We create the

Vendix_Design_File.css from scratch — defining color tokens, spacing,

typography, border radius and shadow variables that power the entire

app UI consistently.

We go deep into styling Oracle APEX native components — the navigation

header, side menu, buttons, form items, and page regions. You will

learn how to override Universal Theme defaults cleanly using CSS

class selectors without breaking APEX functionality or future upgrades.

In this episode we build fully custom UI components inside Oracle APEX

using Static Content regions with HTML and CSS. We create cards,

badges, status indicators, modals and sidebar panels — all wired to

live APEX data. Every component is reusable across any APEX project.

The final episode covers PL/SQL-driven dynamic UI regions, responsive

design testing across devices, and how to use AI tools to accelerate

APEX UI design decisions. We also do a full app review of the

completed Vendix POS UI and discuss next steps for production deployment.

Congratulations on completing the course

Everything you need is right here — download the complete

Vendix POS Package from the Resources section of this lecture:

✅ Vendix_POS_App_Export_File — the full Oracle APEX application export

✅ Vendix_Seed_Data — sample data to load the app with realistic records

✅ Vendix_Import_Template — the Excel template for the Bulk Import module

✅ Vendix_API_Test_Data — test data for the API and AI Agent features

✅ Vendix_DB_Drop_All — clean uninstall script to reset your schema

✅ AI Agent Configuration Screenshot — reference for the bonus AI setup

✅ Razorpay Payment Gateway Configuration Screenshot — reference for payment setup

------------------------------------------------

How to install:

Follow Episode 2 step by step — import the app export into your

Oracle APEX workspace, run the database scripts, load the seed

data, and log in. The whole setup takes under 15 minutes.

You can also try the latest upgraded app live here:

https://oracleapex.com/ords/r/thapliyalravi80/vendix-pos-app/login

Thank you for learning with me — now go build something amazing! ?

------------------------------------------------

Ravindra Thapliyal

Oracle ACE Associate | Senior Software Developer

In this episode we configure Web Credentials and the Generative AI

Service in Oracle APEX 26.1 — the foundation every AI feature needs.

We securely store the API key with Bearer token format, set up an

OpenAI-compatible AI provider, select the model, and test the

connection. We also cover the two most common setup errors and

why Max AI Tokens must stay blank.

In this episode we configure OpenRouter as the AI gateway for Oracle

APEX 26.1 — one API key giving access to 400+ AI models. We create

the OpenRouter account, generate the API key, connect it to our

Generative AI Service, choose the right Gemini model, and switch

between models by changing only the model name. We also cover

pricing and how far free credits actually go.

In this episode we build a complete AI Agent in Oracle APEX 26.1

from scratch using the Vendix POS application. We configure the

System Prompt and Welcome Message, build a Retrieve Data tool to

check stock by category, and an Execute Server-side Code tool that

updates inventory with user approval before any change. We also

cover APEX_AI.SET_TOOL_RESULT, why it is mandatory, and how to

fix common errors like ORA-20962 and duplicate parameters.

In this episode we build a complete approval workflow in Oracle

APEX 26.1 using the native Workflow engine. We create the Task

Definition, configure the Human Task activity, pass page values

using Workflow Parameters, and build the submit form and monitoring

pages. We run the workflow end to end — from submission to approval

to automatic inventory update — and cover the Workflow Console

setup and common configuration mistakes.

In this episode we integrate Razorpay payment gateway into

Oracle APEX 26.1 — real online payments inside your enterprise

application. We configure the POS_PAYMENT_TXN table and

POS_PKG_PAYMENT package, set up the Web Credential for Razorpay

keys, wire the Payment Checkout page, and implement the Ajax

callbacks for order creation, payment verification, and

transaction status updates. We also cover signature verification,

test card usage, and common integration errors.

Please refer to the attached resource document —

Vendix_Razorpay_Build_Guide_SOP.docx — for detailed, step-by-step

documentation of every piece of code and section covered in this

video, clearly explained and organized for easy reference.

In this episode we go through the complete Oracle APEX career

journey — from preparing for your first interview to resigning

professionally when you get the job. This is not a question-answer

video. This is the real roadmap — resume building, ATS optimisation,

communication skills, interview technique, offer negotiation, and

resignation done right — all specific to Oracle APEX developers.