Enterprise Merchandising

Oracle Retail

RMS, RPM, ReIM, RIB, ReSA, SIM, Allocation, RPAS, and Retail Insights — the complete Oracle Retail engineering library.

Published Guides

68 Articles
Retail Pricing Fundamentals: Cost, Retail & IMU
Phase 6
15 min read

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.

Read Article
Inventory Adjustments and Reason Codes
Phase 5
14 min read

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.

Read Article
Stock Counts and Cycle Counting in RMS
Phase 5
18 min read

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.

Read Article
Return to Vendor (RTV): Workflow and Ledger Impact
Phase 5
15 min read

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.

Read Article
Transfers: Moving Stock Across the Network
Phase 5
17 min read

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.

Read Article
WAC (Weighted Average Cost) and Cost Accounting
Phase 5
19 min read

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.

Read Article
The Stock Ledger: Core of RMS Accounting
Phase 5
24 min read

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.

Read Article
Inventory Positions in Oracle RMS
Phase 5
16 min read

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.

Read Article
Supplier Deals: Off-Invoice and Bill-Backs in RMS
Phase 4
20 min read

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.

Read Article
RetailCoder
All systems operational
v1.0 Live

RC:OMS

Multi-channel order management with double-entry inventory ledger. Amazon, Flipkart, Shopify, WooCommerce — one source of truth.

Launch demo →
v1.0 Live

RC:Storefront

Self-hosted headless e-commerce. Your server, your data, zero transaction fees. Native RC:OMS inventory sync.

Visit Storefront →
Pipeline

RC:Pulse

AI-powered retail analytics and demand forecasting — built natively on top of your RC:OMS and Storefront data.

Request early access →
Built in India 🇮🇳  ·  Architected by Priyanshu PandeyTalk to an engineer →