RetailCoder Logo
← All Articles

Tag: Oracle Retail

15 articles found

Oracle Retail Xstore Point-of-Service: Architecture, Offline Resilience & Integration Deep Dive
Phase 1
22 min read

Oracle Retail Xstore Point-of-Service: Architecture, Offline Resilience & Integration Deep Dive

A comprehensive architectural deep dive into Oracle Retail Xstore POS. Learn how the thick-client architecture enables offline resilience, how TLOGs flow from registers to headquarters, the Apache Derby local database schema, payment integration patterns, and Xcenter corporate synchronization.

Read Article→
Oracle RMS Suppliers & Partners
Phase 2
15 min read

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.

Read Article→
Currencies, Exchange Rates & VAT Regions
Phase 2
11 min read

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.

Read Article→
The Retail Calendar in Oracle RMS
Phase 2
10 min read

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.

Read Article→
Oracle RMS Merchandise Hierarchy
Phase 2
12 min read

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.

Read Article→
The Oracle Retail Product Family Explained
Phase 1
15 min read

The Oracle Retail Product Family Explained

Oracle RMS is just one piece of the puzzle. Discover how RMS connects to SIM, ReSA, RPM, RPAS, and Xstore to form a complete enterprise retail technology ecosystem.

Read Article→
RetailCoder
All systems operational
v1.0 Live

RC:OMS

Multi-channel order management with double-entry inventory ledger. Amazon, Flipkart, Shopify, WooCommerce — one source of truth.

Launch demo →
v1.0 Live

RC:Storefront

Self-hosted headless e-commerce. Your server, your data, zero transaction fees. Native RC:OMS inventory sync.

Visit Storefront →
Pipeline

RC:Pulse

AI-powered retail analytics and demand forecasting — built natively on top of your RC:OMS and Storefront data.

Request early access →
Built in India 🇮🇳  ·  Architected by Priyanshu PandeyTalk to an engineer →