Retail Merchandising System (RMS) Technical Essentials

RMS Technical Essentials includes hands-on practice exercises, which reinforce the material covered in the presentations. The course begins with a lesson breakdown by technical area and then dives into a number of functional areas covering batch processing, forms, and data models for each. The course also covers what’s new in RMS 13.

Learn To:

• Run batch processing
• Identify forms
• Identify the Physical Architecture and Application Architecture
• Review configuration and system administration
• Review integration, localization, and reports
• Identify data models

Audience

• Application Developers
• Database Designers
• Developer
• Support Engineer
• System Analysts
• Technical Administrator
• Data Warehouse Administrator
• Technical Consultant

Course Topics Application Overview

• Define RMS
• Explain the Oracle Retail solution footprint
• Describe the application functional overview

Physical Architecture and Application Architecture

• Define hardware requirements
• Describe the physical architecture
• Describe the application architecture
• Explain the RMS software requirements

Installation

• Describe at a high level the installation of key components
• Describe where key components are installed

Batch Processing, Configuration, and System Administration

• Describe the purpose of batch programs in RMS
• Describe how to configure RMS
• Describe logging in RMS
• Describe the system options table

Integration, Localization, and Data Conversion

• Describe integration with other Oracle Retail applications
• Describe the process of localization
• Explain data conversion

Organizational Hierarchy

• Identify tables involved in the organizational hierarchy and understand the relationship between each table
• Identify online forms involved in the organizational hierarchy
• Explain the relationship between each form and its base table involved in the organizational hierarchy
• Identify batch programs involved in the organizational hierarchy
• Explain the relationship between each batch program and its driving table or file involved in the organizational hierarchy

Merchandising Hierarchy

• Identify tables involved in the merchandise hierarchy and the relationship between each table
• Identify online forms involved in the merchandise hierarchy
• Understand the relationship between each form and its base table involved in the merchandise hierarchy
• Identify batch programs involved in the merchandise hierarchy
• Understand the relationship between each batch program and its driving table or file involved in the merchandise hierarchy

Suppliers and Supplier Sites

• Describe setting up suppliers in RMS
• Identify tables involved in supplier maintenance and understand the relationship between each table
• Identify online forms involved in supplier maintenance
• Understand the relationship between each form and its base table involved in supplier maintenance
• Identify batch programs involved in supplier related processes
• Understand the relationship between each batch program and its driving table or file involved in supplier related processes
• Explain supplier sites

Item Maintenance

• Identify and explain the item online processes, batch processes and data flows
• Identify the high-level integration points associated with items
• Identify key tables and understand the relationship between each table in item maintenance
• Identify online forms and understand the relationship between each form and its base table involved in item maintenance
• Identify batch programs and understand the relationship between each batch program and its driving table or file involved in item maintenance related processes

Pack Item Maintenance

• Identify and explain the pack item online processes
• Name key tables associated with pack items
• Identify and explain the pack item batch processes
• Identify the data flow of the online and batch processes associated with pack items
• Identify the high-level integration points associated with pack items

Cost Maintenance

• Identify and explain the cost maintenance online processes and batch processes
• Identify high-level integration points, key tables, online forms, batch programs involved in cost maintenance related processes
• Understand the relationship between each table, online form, base table, and batch program involved in cost maintenance related process

Purchase Order

• Identify and explain the purchase order maintenance online processes
• Name key tables associated with purchase order maintenance
• Identify and explain the purchase order maintenance batch processes
• Identify the data flow of the online and batch processes associated with purchase order maintenance
• Identify the high-level integration points associated with purchase order maintenance

Replenishment

• Identify and explain the replenishment online processes
• Name key tables associated with replenishment
• Identify and explain the replenishment maintenance batch processes
• Identify the data flow of the online and batch processes associated with replenishment
• Identify the high-level integration points associated with replenishment

Transfer

• Identify and explain the transfer online processes
• Name key tables associated with transfers and understand the relationship between each table
• Identify online forms involved in the transfer process
• Understand the relationship between each form and its base table involved in transfer
• Identify batch programs involved in transfer processes
• Understand the relationship between each batch program and its driving table or file involved in transfer process

Stock Count

• Describe the stock count functionality in RMS
• Identify and explain the stock count online processes, batch processes, and online forms
• Name key tables associated with stock counts
• Understand the relationship between the tables, forms, and batch programs in stock counts

Stock Ledger

• Describe the stock ledger in RMS
• Explain the stock ledger online and batch processes
• Identify key tables, online forms, and batch programs involved in stock ledger process
• Describe the relationships between the key tables, online forms, and batch programs involved in the stock ledger process

Deals

• Identify and explain the deals online processes
• Name key tables associated with deals
• Identify and explain the deals batch processes
• Identify the data flow of the online and batch processes associated with deals
• Identify the high-level integration points associated with deals

RMS Standard Edition (SE)

• Explain why SE is needed
• Describe SE components

Multiple Set of Books (MSOB)

• Describe the enterprise structure of MSOB
• Describe the components of MSOB
• Explain various system options and table structures for MSOB
• Identify and explain the MSOB online processes
• Identify changes to batch processes to support MSOB

Wholesale / Franchise

• Define wholesale / franchise
• Describe wholesale / franchise changes in the database, forms, batch, and reports
• Explain wholesale / franchise’s impact on costing / pricing, ordering, and financials

BI Publisher Reporting

• Describe the architectural overview
• Describe post-installation administration
• Describe report creation
• Describe the reports conversion tool
• Explain report resizing for Oracle Retail Workspace (ORW)

Course Objectives

• Describe the basic functions of RMS
• Identify online forms
• Understand the layout and programs in the batch schedule and how they affect the functional side RMS
• Interpret the data flow and data models per RMS function
• Identify new functionality in RMS version 13
• Apply knowledge from this course to other RMS functional areas
• Explain Physical Architecture and Application Architecture
• Describe Installation
• Explain Configuration and System Administration
• Explain Integration, Localization, and Reports