Technical Deep Dives
Production-ready code, architecture breakdowns, and performance tuning strategies for enterprise retail systems.
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.
Previous Articles
Oracle RMS Purchase Orders
The complete developer guide to Oracle RMS Purchase Orders. Covers all PO types, the full status lifecycle from Worksheet to Closed, ORDHEAD and ORDSKU and ORDLOC table structures, the approval and transmission workflow, Open to Buy integration, partial receipt handling, 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 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.
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 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.
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.
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.
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.
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
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
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
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.
PL/SQL Complete Guide: From Basics to Advanced
The definitive PL/SQL reference for Oracle developers — covering PL/SQL block structure, variables and data types (%TYPE, %ROWTYPE), conditional statements (IF/CASE), all loop types, implicit and explicit cursors, exception handling (predefined & user-defined), stored procedures vs functions, packages (spec & body), triggers (BEFORE/AFTER/INSTEAD OF), BULK COLLECT & FORALL for performance, and EXECUTE IMMEDIATE dynamic SQL. Real-world Oracle Retail examples throughout.
SQL Advanced: Window Functions, Ranking, Running Totals & CTEs
Master advanced SQL analytics — Window Functions (OVER, PARTITION BY), ranking functions (ROW_NUMBER, RANK, DENSE_RANK, NTILE), LAG/LEAD for period comparisons, running totals and moving averages with SUM/AVG OVER, and Common Table Expressions (CTE & Recursive CTE) with real-world Oracle and PostgreSQL examples.
SQL Intermediate: Joins, Aggregates, Subqueries, Functions, Views & Indexes
Master intermediate SQL concepts in one comprehensive guide — covering all JOIN types, aggregate functions (COUNT/SUM/AVG/MIN/MAX), GROUP BY, HAVING, subqueries, UNION/INTERSECT/EXCEPT, CASE statements, COALESCE/NULLIF/NVL, string/date/math functions, SQL Views, and Indexes. Packed with Oracle, MySQL, and PostgreSQL examples.
SQL Foundations: The Complete Beginner's Guide
Master SQL from zero — covering What is SQL, data types, DDL (CREATE/ALTER/DROP), DML (INSERT/UPDATE/DELETE), SELECT, WHERE, ORDER BY, DISTINCT, LIKE/IN/BETWEEN, NULL handling, operators, LIMIT, aliases, comments, and essential functions. Oracle, MySQL, and PostgreSQL examples throughout.
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 →