Oracle Retail
RMS, RPM, ReIM, RIB, ReSA, SIM, Allocation, RPAS, and Retail Insights — the complete Oracle Retail engineering library.
Published Guides
Oracle Retail Xstore Point-of-Service: Architecture, Offline Resilience & Integration Deep Dive
A comprehensive architectural deep dive into Oracle Retail Xstore POS. Learn how the thick-client architecture enables offline resilience, how TLOGs flow from registers to headquarters, the Apache Derby local database schema, payment integration patterns, and Xcenter corporate synchronization.
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.
The RMS Data Model for Reporting
A guide to the most critical Oracle RMS tables every BI developer and data analyst needs to know for operational reporting.
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 →