KPKPI Partnersinkpipartners.hashnode.dev·1d ago · 7 min readBuilding Oracle EBS Procurement Analytics Without Creating Another Reporting SiloOracle EBS Procurement Analytics requires more than connecting a visualization tool to transactional tables. A reliable solution needs an ingestion layer, a procurement-aware analytical model, governe00
LDLakshay Dhoundiyalinlakshaydhoundiyal.hashnode.dev·2d ago · 8 min readWhy Do Banks Use Oracle Database? The Technology Behind Modern BankingYou open your banking app. You enter ₹10,000. You tap Send. A few seconds later: “Transaction Successful.” ✅ Simple, right? Not really. Behind that tiny confirmation message, several systems have alre20
UAUptime Architectinuptimearchitect.hashnode.dev·2d ago · 13 min readOracle Unified Auditing Without the NoiseMost Oracle audit trails are useless, and they fail in one of two ways. Either nobody ever enabled anything, so when a breach investigation asks "who altered that account," the answer is a shrug. Or s00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·5d ago · 7 min readOne Application, Multiple User Experiences: Building a Role-Based Authorization Framework in Oracle APEX👋 Introduction When I started building one of my Oracle APEX applications, my initial focus was straightforward: create the pages, connect the database, and make sure every feature worked correctly. 00
RMRob Moayedzadehinblog.dbadispatch.tech·5d ago · 7 min readMigrating Oracle LOBs from BasicFile to SecureFiles: A Field GuideNotes from a real production migration on Oracle Standard Edition 2, ahead of a 12c → 19c upgrade. BasicFile is Oracle's original LOB storage mechanism, predating 11g. SecureFiles has been the default00
RMRob Moayedzadehinblog.dbadispatch.tech·5d ago · 5 min readCloning a Pluggable Database (PDB) Across CDBs via Database LinkApplies to: Oracle Database 19c (Standard/Enterprise Edition), multitenant architecture Status: Draft / Verified in test Overview This runbook documents cloning a source PDB into a new target PDB usi00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·Aug 4 · 4 min readBuilding an Enterprise Email Framework in Oracle APEXReusable Templates || Dynamic Placeholders || Professional Notifications How I built a reusable HTML email framework in Oracle APEX that sends professional business emails using dynamic placeholders i00
SJSushama Jangleinoracleapexsessionstate.hashnode.dev·Aug 3 · 4 min readViewing PDF Files in Oracle APEX: Creating a Seamless Document Experience for Business UsersIntroduction As Oracle APEX developers, we often build applications that manage business-critical information—employee records, invoices, purchase orders, customer requests, audit reports, and much mo00
RKRavi Kumar Yadavingenerate-absolute-urls-in-oracle-apex.hashnode.dev·Aug 3 · 5 min readMastering Advanced Interactive Grid Customizations in Oracle APEX with JavaScript & PL/SQLOracle APEX Interactive Grids (IG) provide out-of-the-box reporting and editing capabilities. However, enterprise applications frequently require advanced user interactions—such as conditional cell ed00
RKRavi Kumar Yadavingenerate-absolute-urls-in-oracle-apex.hashnode.dev·Aug 2 · 4 min readEnterprise REST APIs in Oracle Database: Building High-Performance JSON Services with ORDS & PL/SQLExecutive Summary As modern enterprise architectures shift toward decoupled microservices and reactive front-end frameworks, expose-and-consume patterns inside Oracle Database are essential. Oracle RE00