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