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