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
• Business Process Workflow
• Key Features of SPO
• Skills Needed for Implementation
  • Applications
  • Technical Concepts

2 Implementation Considerations

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

3 Build Script

• Installation Dependencies
  • Environment Setup
  • RPAS Installation
    • RPAS Client Installation
  • SPO Installation
    • Custom Domain Build
  • Handling Common Hierarchy Files in the Fashion Planning Bundle Applications
• Environment Variables
  • Optional Environment Variable
    • RPAS_JAVA_MAXHEAPSIZE
• Files Needed to Build the SPO Domain
  • Standard RPAS Hierarchy Files
    • Calendar Hierarchy File
    • Product Hierarchy File
    • Location Hierarchy File
  • SPO-Specific Hierarchy Files
    • Attribute Hierarchy File
    • Size Hierarchy File
    • Size Range Hierarchy File
    • Generation ID Hierarchy File
    • Escalation Level Hierarchy File
    • Cluster Hierarchy File
    • Pack Hierarchy File
  • Data Files
    • Sales Data File
    • Fashion Item Flag Data File
    • Inventory Data File
    • Size Rank Data File
    • SKU to Attribute Code Map Data File
    • SKU to Master Size Map Data File
    • Sub Size Range Assignment Data File
    • Escalation Level Label File
    • Escalation Level Normalize Intersection File
    • Escalation Order File
    • Escalation Level Intersection in Approval Workbook File
    • Fashion Item SKUs
• Prepack Specific Hierarchy Files
  • Complex Pack Hierarchy File
  • Prepack ID Hierarchy File
  • Prepack Type Hierarchy File
  • Optimization Level Hierarchy File
  • Profile Hierarchy File
  • Data Source Hierarchy File
  • Delivery Hierarchy File
• Building the SPO Domain
  • Batch Design
    • Building a Domain
• Descriptions of SPO GA Build Script
  • Step 1: Generate Internal Hierarchy and Measure Data Files
  • Step 2: -patchinstall Mode (used if patching)
  • Step 3: Call rpasinstall to Build Domain
  • Step 4: -fullinstall Mode: remove styles from "sizeoptapprove" workbook
  • Step 5: Load Measures
  • Step 6: Run the data processing rule groups
• Configuration Files for the RPAS Fusion Client
• Creating Users and User Groups
• Loading and Extracting Data

4 Data Flow

• Overview of the SPO Data Flow
  • Integration Interface Data Flow Description
    • From a Data Warehouse Application to Size Profile Optimization
    • From Size Profile Optimization to Assortment Planning
    • From Size Profile Optimization to Allocation
• Layout of the Size Profile

5 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 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

6 Script Integration

• Integration Script
  • Batch Design
    • Export to AP
    • Export to Allocation

7 Configuration Considerations

• Calendar (CLND) Hierarchy
• Product (PROD) Hierarchy
• Location (LOC) Hierarchy
• Attribute Code (ATTR) Hierarchy
• Sizes (SIZ) Hierarchy
• Size Ranges (SIZR) Hierarchy
• Generation ID (GIDH) Hierarchy
• Escalation Levels (ELH) Hierarchy
• Cluster (CLSH) Hierarchy
• Prepack Optimization
  • Pack (PCC) Hierarchy
  • Complex Pack (CPCK) Hierarchy
  • Prepack ID (PRPK) Hierarchy
  • Prepack Type (PCKT) Hierarchy
  • Optimization Level (OPTL) Hierarchy
  • Profile (PROF) Hierarchy
  • Data Source (DSRC) Hierarchy
  • Delivery (DLVY) Hierarchy

8 Batch Processing

• Batch Script Summary
  • Batch Script Summary Table
• Batch Design
  • Load SPO Data
  • Generate Size Profile
    • Running the SPO Batch
  • Run Size Profile Generation in a Local Domain Only
    • Running the SPO Generation in a Local Domain
• Before Running the SPO Batch for the First Time
• Prepack Optimization Batches
  • Prepack Optimization Batch
  • Prepack Optimization Export Batch
  • Prepack Optimization SPO Patch Batch
  • Prepack Optimization AP Patch Batch
• SPO Batch Report
  • Preprocessing Filter Report
    • Item/Store Filter Statistics
    • Style-Color/Store Filter Statistics
  • Postprocessing Filter Report

9 Configuring the SPO Solution

• SizeOpt Params Window
• Configuring the SPO Solution
  • Configuring the Point-of-Sale (POS) Intersection
  • Configuring Preprocessing Filtering
  • Configuring the Escalation Levels
  • Configuring the Generation IDs
  • Configuring the Maximum Number of Clusters
  • Configuring the Escalation Path Override Level
  • Configuring the Clustering Workbook Intersection
• Generating Intersections, Measures, Rules, and Workbooks
  • Generate Task Flows for Fusion Client

10 Configuring the Prepack Optimization Module

• PrepackOpt Params Window
• Configuring the Prepack Optimization Solution
  • Configuring the Optimization Intersection
  • Configuring the Demand Intersection
  • Configuring the Prepack Definition Intersection
  • Configuring the Receipt Intersection
  • Configuring the Default Parameter Intersection
  • Configuring the Optimization Levels
  • Configuring the Number of Prepack Types
  • Configuring the Maximum Number of Complex Packs
  • Configuring the Maximum Number of Delivery IDs
  • Configuring the Data Source Measures
• Generating Intersections, Measures, Rules, and Workbooks

11 Internationalization

• Translation