Oracle Retail Merchandising System (RMS)
Deep dives into RMS schemas, PO lifecycle, stock ledger, and batch processing.
Published Guides
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.
Writing PL/SQL Packages for RMS Business Logic
Best practices for writing efficient, robust PL/SQL packages that interact with Oracle RMS data structures.
The Oracle Retail Extension Model: Custom Tables, Flex Attributes & Upgrade-Safe Customization
A comprehensive guide to the Oracle RMS Extension Model. Learn how to create CUST_ extension tables, use flex attributes for custom fields, implement custom PL/SQL hooks, build upgrade-safe integrations via ORDS REST APIs, and avoid the technical debt of base code modifications.
Registering and Scheduling Custom Batch Scripts in RMS
How to register custom shell scripts and PL/SQL procedures into the Oracle RMS batch framework and schedule them via POM.
Writing Custom Validation Frameworks in PL/SQL
How to build robust validation engines for your RMS staging tables using PL/SQL bulk processing and FORALL loops.
RIB Architecture: The Retail Integration Bus That Connects Every Oracle Retail Module
A comprehensive guide to the Oracle Retail Integration Bus (RIB). Learn how JMS-based pub/sub messaging connects RMS to Xstore, RPCS, ReIM, and SIOCS, the RIB adapter architecture, message families, error hospital, RIHA monitoring, and real-time vs batch integration patterns.
RMS Staging Tables: Interface Tables for External System Integration
A comprehensive guide to RMS staging tables. Learn how IF_TRAN_DATA, IF_ITEM, and IF_PO staging tables act as the gateway between external systems and RMS, the staging-to-production promotion flow, error handling via rejection tables, and best practices for high-volume data loading.
The Foundation Data Layer (FDL) in Oracle RMS: Extract Types, Downstream Consumers & ODI Integration
A comprehensive guide to the RMS Foundation Data Layer (FDL). Learn how FDL extracts transform OLTP data into flat files for downstream systems, the difference between full and delta extracts, FDL_ITEM and FDL_ITEM_LOC table schemas, ODI integration patterns, and BDI in cloud deployments.
RMS Foundation Batches: VDATE, Currency Rates & Business Date Management
A comprehensive guide to RMS foundation batch programs. Learn how VDATE_JOB advances the business date, CURRRATE_LOAD processes exchange rates, fiscal calendar batches update period boundaries, and how foundation programs must complete before all other batches can start.
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 →