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.
Oracle RMS Transformable Items & Rules
The complete developer guide to Oracle RMS item transformations. Covers ITEM_XFORM_IND, the ITEM_TRANSFORM table, input and output item setup, transformation ratios, cost allocation, the transformation transaction workflow, stock ledger impact, and production-ready SQL & PL/SQL examples.
Oracle RMS Pack Items
The definitive developer guide to Oracle RMS pack items. Covers the three pack types (simple, complex, buyer), PACK_IND and SIMPLE_PACK_IND flags, the PACKSKU component table, pack SOH vs component SOH, orderable and sellable indicators, pack breakdown logic, and production-ready SQL & PL/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.
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 →