Oracle Retail Merchandising System (RMS)
Deep dives into RMS schemas, PO lifecycle, stock ledger, and batch processing.
Published Guides
Oracle APEX: The Modern Low-Code Database Platform for Retail Applications
A comprehensive guide to Oracle APEX — the low-code development platform for building scalable enterprise web apps directly on Oracle Database. Learn the ORDS architecture, page types, Interactive Reports, application builder, Universal Theme, REST modules, and APEX as the Oracle Forms replacement.
Oracle Forms: The Legacy Platform That Built Enterprise Retail Applications
A comprehensive guide to Oracle Forms — the legacy UI platform that powered Oracle Retail for decades. Learn the trigger execution order, form module architecture (.fmb/.fmx), key table references, the Forms-to-APEX migration path, Java applet deprecation, and modernization strategies.
Oracle RMS: Cross-Version Differences (v14 vs v16 vs v19+ Cloud)
A comprehensive historical and technical comparison of Oracle RMS versions — from v14 Oracle Forms to v16 ADF to v19+ Cloud (MFCS). Includes feature comparison matrix, deprecated API list, new REST endpoints, Extension Model enforcement timeline, and migration considerations.
The Oracle RMS Security Model: Roles, Data-Level Security & VPD Policies
A comprehensive guide to the Oracle RMS security architecture. Learn how role-based access control works through SEC_USER_ROLE and SEC_PRIV tables, data-level security filtering, VPD (Virtual Private Database) policies, LDAP integration, and the ADMIN_USER_PRIV setup process.
Oracle RMS Upgrade Patterns & Downtime Management
A comprehensive guide to Oracle RMS upgrade strategies. Learn the difference between in-place upgrades and Lift-and-Shift migrations, the Data Conversion Application (DCA), cutover weekend orchestration, rollback strategies, and integration testing for major version transitions.
Oracle Retail Cloud Services: The Move to SaaS — Architecture, POM, BDI & Extension Model
A comprehensive guide to Oracle Retail Cloud Services (MFCS). Learn the SaaS architecture, what you lose when moving to cloud, new tools (POM, BDI, APEX, ORDS), custom schema provisioning, and strategies for operating in a locked-down cloud environment.
Performance Tuning Oracle RMS: Indexes, Statistics, Partitioning & Query Optimization
A comprehensive guide to Oracle RMS performance tuning. Learn index analysis for high-volume RMS tables, DBMS_STATS gathering strategies, partition pruning for TRAN_DATA, bind variable best practices, SQL profile creation, AWR report analysis, and batch performance optimization.
Debugging and Tracing Issues in Oracle RMS
A survival guide for Oracle RMS developers and support engineers. Learn how to trace PL/SQL executions, read RIB logs, and decipher batch error files.
Building Custom APIs on Top of Oracle RMS
Patterns and anti-patterns for exposing Oracle RMS data to modern web and mobile applications using REST APIs and ORDS.
RC:OMS
Multi-channel order management with double-entry inventory ledger. Amazon, Flipkart, Shopify, WooCommerce — one source of truth.
Launch demo →RC:Storefront
Self-hosted headless e-commerce. Your server, your data, zero transaction fees. Native RC:OMS inventory sync.
Visit Storefront →RC:Pulse
AI-powered retail analytics and demand forecasting — built natively on top of your RC:OMS and Storefront data.
Request early access →