Oracle Retail
Browsing all engineering deep dives and architectural guides related to Oracle Retail.
Oracle RMS UDAs — User Defined Attributes: Types, Creation & Querying
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 Item Creation Workflow — From Scratch to Ranging
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.
Oracle RMS Item Supplier Setup — Primary Supplier, Cost, Lead Times & Pack Sizes
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.
Currencies, Exchange Rates & VAT Regions in Oracle RMS
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.
Oracle RMS Item Master Deep Dive — Item Types, Levels & the ITEM_MASTER Table
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.
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.
Oracle RMS Suppliers & Partners: Supplier Master, Sites and Partner Types Explained
Complete developer reference for Oracle RMS Suppliers and Partners. Covers the SUPS table, ADDR supplier sites, all PARTNER_TYPE codes, ITEM_SUPPLIER cost and lead-time setup, ITEM_SUPP_COUNTRY FOB costing, the primary supplier pattern, and 5 production-ready SQL examples.
Oracle RMS Merchandise Hierarchy Explained: Company to Subclass
The definitive developer guide to the Oracle RMS Merchandise Hierarchy. Covers all six levels — COMPHEAD, DIVISION, GROUPS, DEPS, CLASS, SUBCLASS — composite primary keys, the ITEM_MASTER attachment pattern, and production-ready SQL & PL/SQL examples.
The Oracle RMS Organizational Hierarchy — Stores, Warehouses & Locations
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 →