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 Item Planning
• 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
  • Item Planning Installation
    • Custom Domain Build
    • Item Planning Taskflow for the RPAS Fusion Client
  • Handling Common Hierarchy Files
• Files Needed to Build the IP Domain
  • Standard RPAS Hierarchy Files
    • Calendar Hierarchy File
    • Product Hierarchy File
    • Location Hierarchy File
  • IP Specific Hierarchy Files
    • Seasonality Hierarchy File
    • Price Tier Hierarchy File
    • Size Hierarchy File
    • Curve Library Hierarchy File
    • Measure_Status Hierarchy File
    • Measure Details Hierarchy File
    • Promotion Hierarchy File
    • Clearance Cadence Hierarchy File
    • Week of Year Hierarchy File
• Building the Item Planning Domain
  • Batch Designs
    • Building an Item Planning configured for COE Domain
    • Building an Item Planning (without COE configuration) Domain
    • Patching a Domain
• Creating Users and User Groups
• Loading and Extracting Data

4 Data Flow

• Overview of the Item Planning Data Flow
  • Integration Interface Data Flow Description
    • From a Merchandising Application to Item Planning
    • From a Data Warehouse Application to Item Planning

5 Fashion Planning 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 Scripts
  • Batch Designs
    • Load Actuals Data
    • Export to MFP

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 AP Data
  • Load MFP Data
    • MFP Retail Measure List
    • MFP Cost Measure List
  • Process Actuals Data
  • Run Batch Forecast
  • Refresh Workbooks
  • Auto Build Workbooks
  • Load Mapping Measures

8 Item Planning Configured for COE

• Integration Methods and Communication Flow
  • Data Exported from COE to Item Planning Configured for COE
    • Markdown Recommendations
    • Forecast Summaries
    • Forecast Activities
    • Pricing Group Mapping
  • Data Exported from Item Planning on RPAS to COE
    • Business Rules
    • Format of the Export File
• Data Flow Between COE and IP COE
  • Data Flow Description
• RPAS Special Expression for COE
  • Overview on Evaluation of the Expression by RPAS
• Environment Requirements
  • Configuration of the MDO_URL Measure
  • Security Features
    • Setup for Secure Calls to the Oracle WebLogic Server
  • COE Expression Runtime Environment
    • Structure of the Special Expression
• Batch Structure Overview
• Transformation Scripts
• Batch Scheduling
  • Daily Batch Scripts
  • Weekly Batch Scripts
  • Unscheduled Administration Script
  • Batch Environment Scripts
• Batch Designs
  • Load COE Batch
• Troubleshooting Issues with Accessing the What-If Engine Service
  • ERROR: Cannot process MenuEvent - WorkbookException: java.lang.NoClassDefFoundError: weblogic.wsee.jaxrpc.ServiceImpl
  • ERROR: Cannot process MenuEvent - WorkbookException: InvalidArgumentException: SalePrice must be below Mask
  • ERROR: Cannot process MenuEvent - WorkbookException: java.lang.ArrayIndexOutOfBoundsException: Array index out of range: 4