Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Contents of this Guide
• Overview of the Fashion Planning Bundle
• Architecture of the Template Applications
• Business Process Flow
• Key Features of MFP
• Skills Needed for Implementation
  • Applications
  • Technical Concepts

2 Implementation Considerations

• Historical Data
• Hardware Space Impacts
• Partitioning
• Formatting
• Plug-ins
• Patch Considerations
• Batch Scheduling
• Security
• Internationalization

3 Build Scripts

• Installation Dependencies
  • Environment Setup
  • RPAS Installation
    • RPAS Client Installation
  • MFP Installation
    • Custom Domain Build
    • MFP Taskflow for the RPAS Fusion Client
  • Handling Common Hierarchy Files in the Fashion Planning Bundle Applications
• Building the MFP Domain
  • Batch Designs
    • Building a Domain
    • Patching a Domain
• Creating Users and User Groups
• Loading and Extracting Data

4 Fashion Planning Bundle and ODI Integration

• Overview of the Fashion Planning Bundle
  • Integration Interface Data Flow Description
    • From Size Profile Optimization to Assortment Planning
    • From Assortment Planning to Item Planning and an Allocation Application
    • From Item Planning to Merchandise Financial Planning
    • From Merchandise Financial Planning to Item Planning
    • From Merchandise Financial Planning to Assortment Planning
  • Execution Applications
  • Optimization Applications
  • Planning Applications
• ODI Enabled Integration
  • Measure Data Integration
  • SizeOpt to AP Package
    • Scripts Used By the SizeOpt to AP Package
    • Data Mapping for SizeOpt to AP Package
  • SizeOpt to AP with Prepack Package
    • Scripts Used By the SizeOpt to AP with Prepack Package
    • Data Mapping for SizeOpt to AP with Prepack Package
  • IP to MFP Retail Package
    • Scripts Used By the IP to MFP Retail Package
    • Data Mapping for IP to MFP Retail Package
  • IP to MFP Cost Package
    • Scripts Used By the IP to MFP Cost Package
    • Data Mapping for IP to MFP Cost Package
  • AP to IP Package
    • Scripts Used By the AP to IP Package
    • Data Mapping for AP to IP Package
  • MFP Cost to AP Package
    • Scripts Used By the MFP Cost to AP Package
    • Data Mapping for MFP Cost to AP Package
  • MFP Retail to AP Package
    • Scripts Used By the MFP Retail to AP Package
    • Data Mapping for MFP Retail to AP Package
  • MFP Cost to IP Package
    • Scripts Used By the MFP Cost to IP Package
    • Data Mapping for MFP Cost to IP Package
  • MFP Retail to IP Package
    • Scripts Used By the MFP Retail to IP Package
    • Data Mapping for MFP Retail to IP Package
  • MFP Finalize Exports Package
    • Script Used By the MFP Finalize Exports Package
• Hierarchy Integration with ODI
  • Adding New Products: PROD Hierarchy Integration
  • Adding New Stores: LOC Hierarchy Integration

5 Script Integration

• Integration Scripts
  • Batch Designs
    • Load Actuals
    • Export to IP
    • Export to AP
    • Reset Export Flags

6 RMS and Retail Analytics Integration

• Overview of the MFP Data Flow
  • Integration Interface Data Flow Description
    • From RMS to MFP
    • From a Data Warehouse Application to MFP
    • From MFP to a Markdown Optimization Engine
    • From MFP to RA
• RMS to MFP Transformation
  • Script Installation
  • Environment Setup
  • RMS Integration Script Details
• Markdown Optimization Integration
• RA Integration
  • Initial Setup
  • Measure Data Integration
    • Scripts Used By the MFP to RA Packages
    • Data Mappings for SDE_MFPCostFact Package
    • Data Mappings for SDE_MFPRetailFact Package
  • Configuring RPAS JDBC for ODI to Facilitate Retail Analytics Integration
• Configuring PO View
  • Installation and Setup of Fusion Client for MFP with POView
  • Overview of the PO View Dataflow

7 Batch Processing

• Batch Structure Overview
• Batch Scheduling
  • Daily Batch Scripts
  • Weekly Batch Scripts
  • Unscheduled Administration Script
  • Batch Environment Scripts
• Batch Designs
  • Calendar Hierarchy Load
  • Product Hierarchy Load
  • Location Hierarchy Load
  • Load On Order Data
  • Load Actuals Data
  • Load IP Data
  • Process Actuals Data
  • Run Batch Forecast
  • Refresh Workbooks
  • Auto Build Workbooks
  • Load Mapping Measures