Oracle Solutions We believe in delivering tangible results for our customers in a cost-effective manner
Part I — Understanding Hire to Retire (H2R) 1.1 What Is H2R? Hire to Retire (H2R) is the standard ERP/HCM name for the complete employee lifecycle process from the moment a …
Read More »Building a Hire-to-Retire (H2R) Solution in Oracle APEX
Yearly Archives: 2026
Dynamic SQL in Oracle Apex
In most Oracle APEX applications, static SQL is enough for reports, LOVs, validations, and database operations. But sometimes the SQL statement itself needs to change based on user input or …
Read More »PL/SQL in Oracle Apex
Oracle APEX makes it possible to build applications with little code, but when an application needs business logic, database processing, validations, or complex operations, PL/SQL becomes an essential part of …
Read More »Oracle VirtualBox Guide: Setting Up a Windows Server Guest VM for Oracle Database 19c
Oracle VirtualBox for Windows Windows Server Guest VM Part I — Understanding This Approach 1.1 Why Build a Windows Server Guest VM? The ORDS and APEX guides in this series are …
Read More »Three Decades of Oracle Forms: Survival, Architecture, and Modernization
The Oracle Forms Journey (From Version 5.0 to Forms 14c) Three Decades of Architecture, Survival, and Modernization Part I — The Client/Server Era A note on the screens below — …
Read More »HTML & CSS in Oracle Apex
Oracle APEX provides many declarative components for building applications, but sometimes the standard options are not enough to achieve the exact look and feel we want. This is where HTML …
Read More »Pakistan Independence Day 2026: The Growth of the Oracle ACE Community Through Mentorship
Celebrating Pakistan’s Independence Day: Growing the Oracle ACE Community Through Knowledge and Mentorship Published on: As on 14th August 2026 Every year on 14 August, we celebrate the Independence of …
Read More »Working with JSON in Oracle Apex
Modern applications exchange data in many different formats, and JSON (JavaScript Object Notation) has become one of the most common. Oracle APEX applications frequently work with JSON when consuming REST …
Read More »ORA-00600 [17287] During UTLRP
ORA-00600 [17287] During UTLRP in Oracle 19c EBS PDB After 19.31 Patch — Issue and Resolution Overview Recently, while working on an Oracle E-Business Suite database running on Oracle Database …
Read More »Dynamic actions in Oracle Apex
One of the features I use frequently in Oracle APEX is Dynamic Actions. They make it possible to respond to user interactions without writing JavaScript for every small requirement. A …
Read More »