Oracle Retail
Comprehensive engineering guides for Oracle Retail Merchandising System (RMS), Oracle Retail Price Management (RPM), Oracle Retail Integration Bus (RIB), and other enterprise retail modules. Discover in-depth architecture diagrams, master data strategies, batch processing optimization, integration payloads, and production-ready PL/SQL implementations for high-volume retail supply chains.
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.
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.
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.
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.
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.
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.
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.
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.
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.
Explore Other Hubs
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 →