Oracle Retail
Comprehensive engineering guides for Oracle Retail Merchandising System (RMS), Oracle Retail Price Management (RPM), Oracle Retail Integration Bus (RIB), and other enterprise retail modules. Discover in-depth architecture diagrams, master data strategies, batch processing optimization, integration payloads, and production-ready PL/SQL implementations for high-volume retail supply chains.
RMS Cost Components and Landed Cost
A comprehensive guide to how Oracle Retail Merchandising System calculates the true cost of inventory. Understand the difference between Base Cost and Landed Cost, and how Expenses, Assessments, and ALC drive inventory valuation in ITEM_LOC_SOH.
EDI and Order Transmission Basics in RMS
Understand how Oracle RMS communicates with suppliers. A deep dive into EDI 850 (Purchase Orders), EDI 856 (ASNs), and EDI 810 (Invoices), and how RMS staging tables like EDI_ORD_DTT format data for external transmission.
Order Management: Approval, Revision & Cancellation in RMS
A deep dive into the Oracle RMS Purchase Order lifecycle. Master the data model behind PO approvals (ORDHEAD, ORDLOC), the revision tracking mechanics (REV_NO), and the cascading ledger impact of cancelling lines vs closing orders.
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.
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 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.
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.
Explore Other Hubs
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 →