Tag: Retail Item Management
Browsing all engineering deep dives and architectural guides tagged with Retail Item Management.
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 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.
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.
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 →