Oracle Retail Engineer
A structured curriculum covering Oracle Retail Merchandising System architecture, master data, purchasing, inventory, pricing, replenishment, integration, and enterprise operations — built from 58+ production engineering guides.
Follow the phases in order for the best learning experience. Each phase builds upon the technical foundations established in the previous section.
Foundations
RMS architecture, schema overview, and navigation.
What is Oracle RMS? Architecture & Modules Explained
An introduction to the Oracle Retail Merchandising System (RMS). Discover its core architecture, functional modules (purchasing, inventory, pricing), and exactly where it fits within the modern retail technology stack.
Setting up your RMS Development Environment
A complete guide to configuring your local workstation for Oracle RMS development. Learn how to set up SQL Developer, connect to the database, and configure your PL/SQL environment.
RMS Database Schema Overview: Tables & Naming Conventions
Mastering the Oracle RMS database requires understanding its naming conventions and key schema patterns. Learn how to quickly navigate the thousands of tables in RMS by decoding their prefixes and suffixes.
Navigating the RMS Application for the First Time
A beginner's guide to the Oracle RMS user interface. Learn how to navigate the folders, menus, and forms, and how to execute basic queries without writing SQL.
The Oracle Retail Product Family Explained
Oracle RMS is just one piece of the puzzle. Discover how RMS connects to SIM, ReSA, RPM, RPAS, and Xstore to form a complete enterprise retail technology ecosystem.
Foundation Data
Hierarchy, locations, suppliers, and calendar setup.
The Oracle RMS Organizational Hierarchy
The definitive developer guide to the Oracle RMS Organizational Hierarchy. Covers the CHAIN → AREA → REGION → DISTRICT → STORE store track, the WH table with Physical, Virtual and Finisher warehouses, the critical LOC + LOC_TYPE pattern, ITEM_LOC, and production-ready SQL & PL/SQL examples.
Oracle RMS Merchandise Hierarchy
The definitive developer guide to the Oracle RMS Merchandise Hierarchy. Covers all six levels — COMPHEAD, DIVISION, GROUPS, DEPS, CLASS, SUBCLASS — composite primary keys, the ITEM_MASTER attachment pattern, and production-ready SQL & PL/SQL examples.
Location Master in Oracle RMS: Stores, Warehouses & Virtual Warehouses
A definitive guide to the Oracle RMS Location Master. Learn how stores, physical warehouses, virtual warehouses, and external finishers are structured in the database, including the STORE, WH, and ADDR tables.
The Retail Calendar in Oracle RMS
The definitive developer guide to the Oracle RMS retail calendar. Covers 4-5-4 vs 4-4-5 vs Gregorian calendar types, the PERIOD table structure, fiscal week/month/quarter/year hierarchy, SYSTEM_OPTIONS.VDATE, the SYSDATE batch, period close and the stock ledger, and production-ready SQL examples.
Currencies, Exchange Rates & VAT Regions
The definitive developer guide to Oracle RMS multi-currency operations. Covers the CURRENCIES table, exchange rate types (Operational, Buying, Selling), CURRENCY_RATES date-effective patterns, VAT regions, VAT codes, the GST tax calculation chain, and production-ready SQL & PL/SQL examples.
Oracle RMS Suppliers & Partners
Complete developer reference for Oracle RMS Suppliers and Partners. Covers the SUPS table, ADDR supplier sites, all PARTNER_TYPE codes, ITEM_SUPPLIER cost and lead-time setup, ITEM_SUPP_COUNTRY FOB costing, the primary supplier pattern, and 5 production-ready SQL examples.
Item Management
Item master, locations, suppliers, and attributes.
RMS Item Master — Item Types & Levels
The definitive developer guide to the Oracle RMS Item Master. Covers the ITEM_MASTER table, item types (regular, pack, simple pack), item levels (transaction, style, SKU), ITEM_DESC multilingual storage, PARENT_ITEM and diff attributes, status codes, and production-ready SQL examples.
Oracle RMS Item Creation
A step-by-step developer guide to creating items in Oracle RMS from zero to fully ranged. Covers item number generation, ITEM_MASTER setup, ITEM_DESC, ITEM_SUPPLIER, UDA assignment, status activation, and ITEM_LOC ranging — with production-ready SQL and PL/SQL examples.
Oracle RMS Item Supplier Setup
The definitive developer guide to Oracle RMS item-supplier setup. Covers ITEM_SUPPLIER table structure, ITEM_SUPP_COUNTRY FOB costing, the primary supplier pattern, unit cost vs landed cost, lead time hierarchy, inner and outer pack sizes, rounding flags, and production-ready SQL & PL/SQL examples.
RMS Item Locations — De-ranging and Ranging
The complete developer guide to item locations in Oracle RMS. Covers the ITEM_LOC table structure, what happens when an item is ranged, ITEM_LOC status values, auto-ranging and ranging rules, de-ranging pre-conditions, cascading effects, ITEM_LOC_SOH initialisation, and production-ready SQL & PL/SQL examples.
Oracle RMS Item Images
The complete developer guide to Oracle RMS item images and extended attributes. Covers the ITEM_IMAGE table, image types, URL storage patterns, ITEM_SUPP_COUNTRY_DIM physical dimensions, ticketing attributes, the Oracle Retail extension model for custom columns and tables, and production-ready SQL examples.
Oracle RMS Pack Items
The definitive developer guide to Oracle RMS pack items. Covers the three pack types (simple, complex, buyer), PACK_IND and SIMPLE_PACK_IND flags, the PACKSKU component table, pack SOH vs component SOH, orderable and sellable indicators, pack breakdown logic, and production-ready SQL & PL/SQL examples.
Oracle RMS Transformable Items & Rules
The complete developer guide to Oracle RMS item transformations. Covers ITEM_XFORM_IND, the ITEM_TRANSFORM table, input and output item setup, transformation ratios, cost allocation, the transformation transaction workflow, stock ledger impact, and production-ready SQL & PL/SQL examples.
Oracle RMS UDAs
The definitive developer guide to Oracle RMS User Defined Attributes (UDAs). Covers all three UDA types (Date, List of Values, Free Form), the UDA master tables, department linkage, REQUIRED_IND activation gating, UDA_ITEM_LOV/DATE/FF querying patterns, and production-ready SQL & PL/SQL examples.
Purchasing
Purchase orders, EDI, and supplier deals.
Oracle RMS Purchase Orders
The complete developer guide to Oracle RMS Purchase Orders. Covers all PO types, the full status lifecycle from Worksheet to Closed, ORDHEAD and ORDSKU and ORDLOC table structures, the approval and transmission workflow, Open to Buy integration, partial receipt handling, and production-ready SQL & PL/SQL examples.
Order Management: Approval, Revision & Cancellation in RMS
A deep dive into the Oracle RMS Purchase Order lifecycle. Master the data model behind PO approvals (ORDHEAD, ORDLOC), the revision tracking mechanics (REV_NO), and the cascading ledger impact of cancelling lines vs closing orders.
EDI and Order Transmission Basics in RMS
Understand how Oracle RMS communicates with suppliers. A deep dive into EDI 850 (Purchase Orders), EDI 856 (ASNs), and EDI 810 (Invoices), and how RMS staging tables like EDI_ORD_DTT format data for external transmission.
RMS Cost Components and Landed Cost
A comprehensive guide to how Oracle Retail Merchandising System calculates the true cost of inventory. Understand the difference between Base Cost and Landed Cost, and how Expenses, Assessments, and ALC drive inventory valuation in ITEM_LOC_SOH.
Supplier Deals: Off-Invoice and Bill-Backs in RMS
Master Oracle RMS Deal Management. Learn how complex supplier negotiations—including Off-Invoice discounts and Bill-Back rebates—are modelled in the database via DEAL_HEAD and DEAL_DETAIL, and how they impact PO costs and the stock ledger.
Inventory Management
Stock ledger, transfers, counts, and WAC.
Inventory Positions in Oracle RMS
Master Oracle RMS inventory tracking. Understand the vital difference between Physical Stock on Hand (SOH) and the calculated Inventory Position, driven by ITEM_LOC_SOH columns like STOCK_ON_ORDER, IN_TRANSIT, and TSF_RESERVED.
The Stock Ledger: Core of RMS Accounting
Demystifying the Oracle RMS Stock Ledger. Learn how TRAN_DATA captures every inventory movement, how daily and month-end rollups feed the general ledger, and the difference between retail and cost accounting.
WAC (Weighted Average Cost) and Cost Accounting
Understand Weighted Average Cost (WAC) in Oracle RMS. Learn the mathematical formula behind WAC calculations, how ITEM_LOC_SOH.UNIT_COST is updated during receiving, and how Tran Code 70 (Cost Variance) keeps the ledger balanced.
Transfers: Moving Stock Across the Network
A deep dive into Oracle RMS Transfers. Learn how TSFHEAD and TSFDETAIL orchestrate the movement of inventory from Warehouse-to-Store (W2S) and Store-to-Store (S2S), including approval workflows, in-transit accounting, and receiving.
Return to Vendor (RTV): Workflow and Ledger Impact
A comprehensive guide to Return to Vendor (RTV) processes in Oracle RMS. Learn how RTV_HEAD orchestrates returning damaged or unsold goods to suppliers, how RTV_QTY locks inventory, and how Tran Code 24 impacts the stock ledger.
Stock Counts and Cycle Counting in RMS
A developer's guide to Stock Counts in Oracle RMS. Learn the difference between Unit counts and Unit & Dollar counts, how STAKE_HEAD manages the counting schedule, and how variances generate Tran Code 22 ledger adjustments.
Inventory Adjustments and Reason Codes
Master Oracle RMS inventory adjustments. Understand how TRAN_DATA Tran Code 22 works, how reason codes drive the financial mapping in FIF_GL_CROSS_REF, and the impact of shrink, damage, and adjustments on the stock ledger.
Pricing
Price zones, promotions, and competitive shopping.
Retail Pricing Fundamentals: Cost, Retail & IMU
Master the foundations of Oracle Retail Pricing. Learn the mathematical relationship between Cost and Retail, how Initial Markup (IMU) is calculated, and how the Oracle Retail Price Management (RPM) engine sets the baseline for profitability.
Price Zones and Zone Groups in Oracle RPM
Understand Oracle Retail Price Zones. Learn how retailers group hundreds of stores into localized clusters for regular and clearance pricing strategies, reducing data maintenance and ensuring competitive localized pricing.
Regular Price Changes and Markdowns
Master Oracle RPM price change workflows. Understand how regular price changes are created, the critical difference between Markups and Markdowns, and how conflict checking prevents margin erosion.
Clearance Pricing and Markdown Strategies
Master Oracle RPM Clearance Pricing. Learn how items transition from regular price to End-of-Life, how clearance zone groups drive aggressive markdowns, and why clearance events lock out regular price changes.
Promotions Framework in Oracle RPM
A comprehensive overview of the Oracle RPM Promotions Framework. Understand how temporary discounts, multi-buys (BOGO), and threshold promotions are designed, conflict-checked, and executed during the promotional lifecycle.
Competitive Shopping in RMS
Learn how Oracle RMS manages competitor pricing data. Understand the COMP_SHOP_LIST and COMP_PRICE tables, and how retailers use this data to execute price matches and maintain market share.
Replenishment
Replenishment fundamentals and batch processing.
Replenishment Fundamentals in Oracle RMS
A comprehensive guide to automated replenishment in Oracle RMS. Learn the core replenishment methods (Min/Max, Dynamic, Time Supply), how Net Inventory is calculated, and the architecture of the REPL_ITEM_LOC table.
Replenishment Attributes in Oracle RMS
A deep dive into the specific item/location attributes that govern replenishment logic in Oracle RMS. Learn how review cycles, delivery schedules, and lead times control the timing of automated orders.
Warehouse vs. Store Replenishment in Oracle RMS
Understand the critical differences between replenishing a store vs. a warehouse in Oracle RMS. Learn about cross-docking, flow-through allocation, and staple replenishment strategies.
Replenishment Batches in Oracle RMS
A technical guide to the Oracle RMS replenishment batch architecture. Understand how reqext.pc extracts needs, rplbld.pc builds orders, and rplapprv.pc approves them.
Integration & Batches
RIB, staging tables, FDL, and batch architecture.
RMS Batch Architecture: Understanding the Oracle Retail Batch Engine
A comprehensive guide to the Oracle RMS batch architecture. Learn how Pro*C batch programs work, the threading model, batch error handling patterns, RESTART_CONTROL table, parallel vs serial execution, the batch scheduling flow, and common batch troubleshooting techniques.
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.
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 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.
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.
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.
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.
Development & Customization
Extensions, PL/SQL logic, APIs, and reporting.
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.
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 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.
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.
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.
Administration & Operations
Security, performance, upgrades, and cloud.
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.
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.
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.
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: 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.
Retail Ecosystem
RPM, ReIM, ReSA, Allocation, RPAS, and Retail Insights.
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 Retail Pricing Cloud Service (RPCS / RPM): Price Events, Zone Pricing & Promotion Engine
A comprehensive guide to Oracle Retail Pricing Cloud Service (RPCS), formerly RPM. Learn the price event lifecycle, zone pricing architecture, future retail maintenance, clearance cascading, promotion engine, and how pricing flows from RPCS to Xstore POS via RIB.
Oracle Retail Sales Audit (ReSA): TLOG Processing, Audit Rules & Financial Firewall Deep Dive
A comprehensive guide to Oracle Retail Sales Audit (ReSA). Learn how TLOGs flow from POS to the General Ledger, the SA_TRAN_HEAD/SA_TRAN_ITEM data model, audit rule configuration, over/short balancing, totals posting, and integration with RMS and the stock ledger.
Oracle Retail Invoice Matching (ReIM): Invoice Processing, Tolerance Rules & Cost Reconciliation
A comprehensive guide to Oracle Retail Invoice Matching (ReIM). Learn how supplier invoices are matched against purchase orders and receipts, tolerance rule configuration, cost discrepancy resolution, debit/credit memo generation, and integration with RMS and Accounts Payable.
Store Inventory Operations Cloud Service (SIOCS / SIM): Mobile Inventory, Receiving & Stock Counts
A comprehensive guide to Oracle Retail SIOCS (formerly SIM). Learn how store associates manage inventory operations on mobile devices, the receiving workflow, stock count process, store-to-store transfers, RIB integration with RMS, and the real-time inventory accuracy pipeline.
Oracle Retail Allocation: Optimizing Inventory Distribution from Warehouse to Stores
A comprehensive guide to Oracle Retail Allocation. Learn how initial allocation distributes new merchandise to stores, the proportional and push allocation methods, ALLOC_HEADER/ALLOC_DETAIL tables, integration with RMS purchase orders, and strategies for maximizing sell-through rates.
Oracle RPAS: Retail Predictive Application Server — Demand Forecasting & Merchandise Planning
A comprehensive guide to Oracle RPAS. Learn how the Retail Predictive Application Server powers demand forecasting, Merchandise Financial Planning (MFP), assortment planning, the domain architecture, workbook templates, and integration with RMS and Allocation.
Oracle Retail Trade Management (RTM): Import Logistics, Letters of Credit & Customs Duties
A comprehensive guide to Oracle Retail Trade Management (RTM). Learn how international retailers manage import purchase orders, letters of credit, customs duties, transportation logistics, landed cost calculations, and trade compliance across global supply chains.
Oracle Retail Insights (RI): Enterprise Data Warehouse, Star Schema & Retail Analytics
A comprehensive guide to Oracle Retail Insights (RI). Learn how the enterprise data warehouse aggregates data from RMS, Xstore, and RPAS into a star schema, the ETL pipeline architecture, OAS/OBIEE reporting, subject areas, and the Retail Science AI/ML platform.
Reporting in Oracle Retail: BI Publisher, OBIEE & Oracle Analytics
A comprehensive guide to reporting in the Oracle Retail ecosystem. Learn the difference between BI Publisher (BIP) and OBIEE/OAS, data model setup, report types, RPD architecture, burst scheduling, custom report creation, and best practices for retail operational and strategic 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 →