Insights from Oracle consultants who ship
Technical writing across Fusion, EBS, APEX, cloud infrastructure, and culture from the same teams delivering client work. 5,000+ insights and articles.
Creating Workers Oracle Fusion HCM API
Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction…
Latest articles
SharePoint Parsing Tool
Automating SharePoint Data Extraction with Playwright and Python The Problem: Vendor Checks Scattered Across SharePoint Accounts-payable teams often store vendo…
Resolve Apply Receipts Using AutoMatch ESS Performance Issues in Oracle Fusion
Resolving Long-Running Apply Receipts Using AutoMatch ESS Process in Oracle Fusion Introduction / Issue The Apply Receipts Using AutoMatch ESS process in Oracle…
Simplify Oracle Fusion Role Reviews with AI Agent
Introduction / Issue Managing user access and role assignments is an important part of Oracle Fusion Cloud security administration. Administrators freque…
Stop Writing Fake INSERT Scripts in Oracle Apex during initial development: Generating Realistic Test Data in Oracle APEX with APEX_DG_DATA_GEN
Introduction / Issue Anyone who’s built in Oracle APEX for more than a few weeks knows this pain: the screens are done, the logic works, and every table is comp…
Application Development
Creating Workers Oracle Fusion HCM API
Creating Workers in Oracle Fusion HCM via REST API Creating and Managing Workers in Oracle Fusion HCM Using REST APIs Instead of the Guided UI Flow Introduction…
SharePoint Parsing Tool
Automating SharePoint Data Extraction with Playwright and Python The Problem: Vendor Checks Scattered Across SharePoint Accounts-payable teams often store vendo…
From 4 Minutes to 2: Building a Desktop HITL Assistant for SharePoint Vendor Validation
Introduction / Issue Anyone who has supported a Human-in-the-Loop (HITL) validation workflow knows the friction: an AI model extracts invoice data, a human vali…
Seeing Inside the Black Box: Building a Visualizer for RAG Chunks
Introduction / Issue Anyone who has worked with a Retrieval-Augmented Generation (RAG) pipeline has run into the same frustrating moment: the model returns an a…
Usage Metrics in Power BI
INTRODUCTION: Knowing how your content is being used helps you demonstrate your impact and prioritize your efforts. Your usage metrics may show that one of your…
Getting Started with ALM Toolkit for Power BI
Getting Started with ALM Toolkit for Power BI INTRODUCTION There are several ways to replace the flooring in your kitchen, but if you were on a budget and had t…
The Art of Visual Storytelling in UX Design
The Art of Visual Storytelling in UX Design Introduction Visual storytelling has become essential in UX design in today’s fast-paced digital world. It’s about u…
How to Create a Fine Poster: A Quick Guide
How to Create a Fine Poster: A Quick Guide Introduction Posters are a powerful way to grab attention and communicate messages quickly. Whether you’re promoting…
Database Blog
Query to Identify Initial and Latest Login Sessions in Oracle Database
Please use the query below to identify and provide the SID and Serial#. col first_seen for a30 col last_seen for a30 SELECT MIN(sample_time) AS first_see…
Steps to Renew Default OHS Keystore Wallet in Oracle Enterprise Manager (OEM)
Please follow the below steps. Prerequisites Take a backup of the existing wallet. Ensure you have appropriate Oracle user privileges. Verify OMS…
How to Unlock Locked SQL Server Logins
How to Unlock Locked SQL Server Logins Introduction / Issue During day-to-day SQL Server administration, users may report that they are unable to connect to the…
SQL Server Audit File Enabled for Both Failed and Successful Logins
SQL Server Audit File Enabled for Both Failed and Successful Logins Introduction During a routine SQL Server security review, it was observed that SQL Server Au…
Upgrading to PostgreSQL 16 Using pg_dump and pg_tresore
One of the safest and most reliable upgrade methods is to use pg_dump and pg_restore. This guide walks through the process of migrating your databases from an o…
Kafka Administration Commands
Kafka Administration Commands Introduction Apache Kafka is a distributed event-streaming platform used to build real-time data pipelines and streaming applicati…
Applying the October 2025 Critical Patch Update (CPU) in EBS R12.2
Oracle E-Business Suite Release 12.2 – Applying the October 2025 Critical Patch Update (CPU) Overview This article outlines the high-level procedure for applyin…
Oracle E-Business Suite R12.2 AD/TXK Delta 16 Upgrade – Practical Implementation Guide
Introduction Oracle E-Business Suite (EBS) Release 12.2 requires periodic updates to its Application DBA (AD) and Technology Stack (TXK) components to maintain…
Oracle Application Blog
WIP Job Close via Apex Application
Introduction / Issue Closing a WIP job in EBS normally means going through the Discrete Jobs form manually — checking if all transactions are done, confirming t…
Fixing Incomplete AP Open Balance on the Oracle ECC Supplier Balance Dashboard
Introduction/Issue: Even though supplier setup in Oracle Payables was correct, the “Supplier Balance” dashboard on the Oracle Enterprise Command Center (ECC) wa…
Adding Order Date Filter to the Order Management ECC Dashboard
Introduction / Issue Users of the Order Management – Enterprise Command Center dashboard needed a way to narrow down the Orders by Order Date directly from the…
Preventing Duplicate Form Submission in Oracle APEX
Introduction / Issue One of the common issues encountered while developing Oracle APEX applications is duplicate form submission. Users may unintentionally clic…
UI Mistakes Oracle APEX Developers Should Avoid
Introduction / Issue Many Oracle APEX applications successfully meet business requirements but often overlook one critical aspect—the User Interface (UI) and Us…
VBCS – Exporting Data as CSV File From Database
VBCS – Exporting Data as CSV File From Database Introduction: Oracle Visual Builder Cloud Service – Version: 26.04.2 Exporting data from the database table as a…
OIC – Retry Mechanism
OIC – Retry Mechanism Introduction: Oracle Integration Cloud – Version: 24.3.1 Implementing Retry Mechanism in an OIC Integration Why we need to do: OIC…
Implementing Mouse-Centered Screen Zoom Using the Shift Key with JavaScript in Oracle APEX
Introduction Oracle APEX applications often display large amounts of data in Interactive Reports, Interactive Grids, dashboards, and forms. When users need to i…
People and Culture Blog
Dataguard manual switchover
Introduction Oracle Data Guard plays a pivotal role in ensuring business continuity by maintaining synchronized standby databases that can seamlessly take over…
Troubleshooting Query Plan Optimization Using Query Store
Introduction SQL Server Query Store is enabled to assist in monitoring query performance and identifying query plan regressions. Query Store captures a history…
When tempdb Won’t Shrink
Introduction In SQL Server, the tempdb system database can grow significantly due to heavy workloads, temporary objects, or large queries. Sometimes, even after…
How I Grew in My Career at Doyensys
From a Fresher to Project Manager: My 12-Year Journey at Doyensys “Do your work and the rest will follow.”– These simple words reflect the career journey of Akh…
AR Invoice Created Through Autoinvoice Cannot Be Completed Due To Error
AR Invoice Created Through Autoinvoice: Cannot Be Completed Due To Error Error ORA-01407: cannot update (???) to NULL ORA-06512: at “FUSION.ARP_UTIL”, line 6272…
SLA Customization in Oracle Fusion.
What is Subledger Accounting? Oracle has provided standard accounting derivation for all the possible events of different aspects of business. However, there co…
Fixing Node Not Ready in Kubernetes
Fixing Node Not Ready in Kubernetes Introduction/Issue: One day, while working on our Kubernetes cluster, we noticed that one of the nodes went into a NotReady…
Read permission on secondary replica in always-on AG
How to give read permission on secondary replica in always-on AG Purpose of Log shipping: Always On availability groups feature is a high-availability and disas…