Skip Headers
Oracle® Retail Item Planning Operations Guide
Release 14.1
E55313-01
Next
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 a 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