2026 - Ontoor blogs

When to Use PL/SQL Process vs Dynamic Action (Oracle APEX)

Introduction Oracle APEX gives you two powerful ways to add logic to your applications: Dynamic Actions: client-side (browser) behavior and UI-driven rules (show/hide, set values, validations, etc.). PL/SQL Processes: server-side…

Vibhor Srivastava May 3, 2026

APEX

How to Create and Manage Workflows in Oracle APEX.

Introduction In this blog, we will learn how to create and manage workflows in Oracle APEX in a simple and step-by-step way. Whether you are a beginner or already working…

Vibhor Srivastava May 3, 2026

APEX

Merging and Refreshing Working Copies in Oracle APEX

Creating a Working Copy is only half the story. The real discipline comes when you bring changes back to the main application or align your copy with updates done by…

Ashish Sahay March 2, 2026

APEX

Understanding Working Copy in Oracle APEX

If you are working in a team on Oracle APEX applications, you already know one common problem. Someone changes a page. Someone else overwrites it. And suddenly things stop working.…

Ashish Sahay February 26, 2026

APEX

Oracle APEX: Generate Realistic Test Data Faster with APEX_DG_DATA_GEN

In almost every Oracle APEX project, developers face the same early challenge: The application UI is ready, but tables are empty QA teams ask for realistic data to test reports…

Vikas Pandey February 13, 2026

APEX PLUGINS

APEX Region Printer Plugin: How to Print Any Oracle APEX Region Cleanly

Printing in Oracle APEX has always been a tricky area. Most applications end up printing the entire page, including navigation menus, headers, buttons, and unwanted UI elements. This becomes a…

Vikas Pandey February 8, 2026

APEX

2 Ways to Restrict File Upload by File Type in Oracle APEX 24.2

In ORACLE APEX 24.2, restricting file uploads is more structured and declarative than in earlier versions. You now have two clean approaches to control allowed file formats. Let’s understand both…

Vikas Pandey February 5, 2026

APEX

Oracle APEX – CSS + Template Directive Pattern Library

Previous Blog. Below is a ready-to-use CSS + Template Directive pattern library you can drop into any Oracle APEX application. This is meant to be practical, consistent, and team-friendly. No…

Ashish Sahay February 2, 2026

APEX

Generating QR Codes and Barcodes in Oracle APEX Using APEX_BARCODE

Modern enterprise applications frequently require QR codes and barcodes—whether for invoices, inventory tracking, secure navigation, or reporting. Oracle APEX provides a built-in package called APEX_BARCODE, which allows developers to generate…

Vikas Pandey January 31, 2026

APEX Fusion

Designing a Robust Fusion-to-ATP Data Sync Framework for Oracle APEX

A complete, real-world, file-based integration architecture Introduction Oracle Fusion Applications store very important and sensitive business data. However, they are not meant to be accessed directly by custom applications or…

Vikas Pandey January 29, 2026