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.
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.
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.
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.
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.
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.
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 →