Registering and Scheduling Custom Batch Scripts in RMS
How to register custom shell scripts and PL/SQL procedures into the Oracle RMS batch framework and schedule them via POM.
The Foundation Data Layer (FDL) in Oracle RMS: Extract Types, Downstream Consumers & ODI Integration
A comprehensive guide to the RMS Foundation Data Layer (FDL). Learn how FDL extracts transform OLTP data into flat files for downstream systems, the difference between full and delta extracts, FDL_ITEM and FDL_ITEM_LOC table schemas, ODI integration patterns, and BDI in cloud deployments.
RMS Batch Architecture: Understanding the Oracle Retail Batch Engine
A comprehensive guide to the Oracle RMS batch architecture. Learn how Pro*C batch programs work, the threading model, batch error handling patterns, RESTART_CONTROL table, parallel vs serial execution, the batch scheduling flow, and common batch troubleshooting techniques.
Replenishment Batches in Oracle RMS
A technical guide to the Oracle RMS replenishment batch architecture. Understand how reqext.pc extracts needs, rplbld.pc builds orders, and rplapprv.pc approves them.
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.
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 →