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 About Advanced Inventory Planning

• AIP Architecture
• RPAS Platform
  • AIP RPAS Platform
• AIP Java/Oracle Platform
  • Data Management (DM) Module
  • Order Management (OM) Module
  • AIP Java/Oracle Platform

2 AIP Integration

• External Integration
• Internal Integration
  • Internal Integration Architecture
  • Exporting
  • Importing
• RETL Configuration

3 AIP Interfaces and Transformation Scripts

• RMS to AIP Interfaces and Transformation Scripts
  • Transform Interface Scripts
    • RMS 14.0 Transform Interface Scripts
    • RMS 13.2 Transform Interface Scripts
    • RMS 13.1/13.0 Transform Interface Scripts
    • RMS 11 Transform Interface Scripts
    • RMS 10 Transform Interface Scripts
  • Input Schema Files
    • RMS 14.0, 13.2, 13.1/13.0, and RMS 11 Input Schema Files
    • RMS 10 Input Schema Files
  • Output Schema Files
  • RETL Extracts (Data Files from RMS)
    • RMS 14.0, 13.2, and 13.1/13.0 RETL Extracts
    • RMS 11 RETL Extracts
    • RMS 10 RETL Extracts
  • Running the Transform Scripts
    • File Transformation and Transfer (AIP RPAS)
    • File Transfer for Order Management (AIP Oracle Database)
• RDF to AIP Interfaces
  • RDF Extracts
• AIP to RMS Interface
  • Message Types
  • RIB Order Publication
  • AIP Message Flow
  • Purchase Order Message
    • XORDERCRE
    • XORDERDTLCRE
    • XORDERMOD
    • XORDERDTLMOD
  • Transfer Message
    • XTSFCRE
  • Contingency Overnight Order Processing
    • Purchase Order and Transfer Files
• Contingency Steps for Overnight Orders
  • Failure Point 1: No Orders Imported from AIP RPAS
  • Failure Point 2: Loading strsplrord.dat
  • Failure Point 3: Loading strwhord.dat
  • Failure Point 4: Loading vendor_to_wh_order.dat into warehouse_purchase_order table
  • Failure Point 5: Loading wh_to_wh_transfer.dat into i_non_contents_transfer table
  • Failure Point 6: Merging Warehouse Purchase Orders into non_contents_transfer table

4 AIP RPAS Batch Processing

• The AIP RPAS Batch Control Script (aip_batch.sh)
  • Usage
  • The aip_batch.sh Steps
    • Execution Sequence of the AIP RPAS Batch Scripts
    • Example Script Calls

5 AIP RPAS Daily Batch Scripts

• Set Implementation Parameters
• External Integration Data Processing
  • Verify and Process Foundation Data from External System
  • Create Empty Hierarchy Files
• Internal Integration Data Processing
  • Prepare Data from AIP Online Platform
• Process Merchandising System and AIP Online Hierarchies
  • Merge Hierarchies
  • Convert Hierarchies for Loading
  • Reconfigure AIP Domain Partitions
• Load Hierarchy and Non-Inventory Measure Data into AIP RPAS
  • Load All Hierarchies
  • Load AIP Online Measure Data
  • Load External Non-Inventory Measure Data
• Generate and Load New Item Alert Measures
  • Create Empty Archive Files
  • Generate Batch and Online Alerts
• Load External System Measure Data into AIP RPAS
  • Load Non-RMS External Files
• Commit Workbooks before Batch Run
  • Auto Commit Workbooks
• Perform and Export Data Management Calculations
  • Run Initial Load DM Batch
  • Run DM Batch
  • Export DM Data
  • Import Schedules from AIP-O into AIP-R
  • Run Post Schedule Import DM batch
• External Integration Forecast Data Processing and Load into AIP RPAS
  • Check and Load Forecast Data
• Prepare Replenishment Data and Maintain History
  • Purge and Advance Low-Variability Data
  • Purge Truncate History
  • Copy Sister Stores and Warehouses
• External Integration Inventory Data Processing and Load into AIP RPAS
  • Verify and Process Inventory Data from External System
  • Load Replenishment Inventory Data
• Calculate and Export Replenishment Plan
  • Run Replenishment
  • Export Supply Chain Replenishment Data
  • Package Supply Chain Replenishment Data
  • Import Cross Dock Constraint Receipt Plan (DCRP) Output from AIP-O into AIP-R
• Load the Scaled Replenishment Plan
  • Run Post Supplier and Container Scaling Import
• Perform Post-Replenishment Calculations
  • Run Replenishment Post-Processing
• Calculate and Export Data Management Alerts
  • Run Non-critical Data Management Alerts
  • Export DM Alerts
• Compute Replenishment Alerts
  • Run SRP Item Alerts
  • Run WRP Item Alerts
  • Run WRP Network Alerts
  • Replenishment Alerts Post Processing
• Building Workbooks after Batch Run
  • Auto Build Workbooks
• Run Calculations for OBIEE Reports
  • Calculate Data for OBIEE Reports
• Run Dashboard
  • Calculate AIP Dashboard Data

6 AIP Java/Oracle Batch Process Flow

• Execution Frequency of AIP Java/Oracle Batch Scripts
• Directory Structure
• Prerequisites for AIP Java/ Oracle Platform
• AIP Java/Oracle Batch Process Flow
  • Batch Process Description
• Export from AIP Online to RPAS
• Import from RPAS and External System into AIP Online
• Smooth and Scale Purchase Orders
• Purchase Order/Transfer Release from AIP Online to Merchandising System

7 AIP Java/Oracle Daily Batch Process Details

• Locking and Unlocking Users
• Virtual Date Maintenance
• Pre-Export Batch
  • Export Planning Horizon
  • Walking Order Cycles
  • Build Scalable and Smoothable Assignments
  • Script Call
• Export DM and OM Data (cron_export)
• Import Data into AIP Oracle Database
  • Load Data
  • DM Post-Load Batch
    • Demand Group and SKU Group Maintenance
    • Range SKU-pack sizes
    • Order Group Assignment
    • Reset Store Format Pack Size (WH and Direct to Store Format)
    • Reset Store Pack Size (WH and Direct to Store)
    • Set Missing Store Format Pack Size (WH and Direct to Store Format)
    • Reset Warehouse Orderable Unit
    • Set Missing Warehouse Orderable Unit
    • Set Order Multiple
    • Set Stacking Flag
    • Set Case Weight
    • Set Pallet Multiple
    • Create Time Balanced Source Splits
    • Copy Sister Store
    • Copy Sister Warehouse
  • Prepare for Intra-day Order Load and Release
  • Import Orders
• Smooth and Scale Purchase Orders
  • Pre-Scaling
  • Order Smoothing
  • Supplier and Container Scaling
  • Partial Pallet Rounding
  • Post-Scaling
  • Merge Purchase Orders
• Release Orders to RMS
  • Order Release Overview
  • Release Orders
  • Post Release
• Purge Closed Orders in AIP Online
  • Purge Store Orders
  • Purge Warehouse Orders
  • Purge PLSQL Logs

8 AIP Interval Batch Scripts

• Integration with Replenishment Optimization
  • AIP Import From RO
  • AIP Export to RO
• AIP Data Purge
  • AIP Oracle Data Purge
  • AIP RPAS Data Purge
    • Steps for Purging_aip_batch.sh
    • Prepare Purging Data from AIP Oracle Platform
    • Process AIP Oracle Purged Hierarchies
    • Load All Purged Hierarchies
    • Process AIP RPAS Positional Measures
• AIP Warehouse Feedback

9 AIP Batch Environment Maintenance

• Notes on AIP Domain Builds
• Domain Relocation
  • Moving a Local Domain or a Master Domain
  • Consolidating the Master and Local Domains
    • Other Uses of copyDomain
• User Administration
• Position Reclassification Process
• Oracle Order Table Partitions
  • Partition Format
  • New Range Partitions
  • Upgrading
  • Removal

10 AIP Daily Process

• AIP Online Day
• AIP Batch Process
  • Initial Batch Run
  • Daily Batch Run
    • Pre AIP Batch
    • AIP Batch
    • Post AIP Batch
• Environment Variables

11 AIP RPAS Intra-day Batch Processing

• The AIP RPAS Intra-day Batch Control Script (intraday_batch.sh)
  • Usage
  • Steps for intraday_batch.sh
    • Execution Sequence of the AIP RPAS Intra-day Batch Scripts
    • Example Script Calls

12 AIP RPAS Intra-day Batch Scripts

• Intra-day External Integration Inventory Data Processing and Load into AIP RPAS
  • Verify and Process Intra-day Inventory Data from External System
    • Script Call
    • Parameters
    • Functional Overview
    • Technical Details
  • Load Intra-day Inventory Data
• Run Intra-day Replenishment Process for Global Domain
• Prepare Intra-day Local Domain List
• Calculate and Export the Intra-day Replenishment Plans for Local Domains
  • Calculate Intra-day Replenishment Plans for Local Domains
  • Export Intra-day Replenishment Data for Local Domains
• Send Intra-day Replenishment Data from AIP RPAS to AIP Oracle
• Update Intra-day Alert Indicator
• Build Intra-day Workbooks after Intra-day Batch Run
  • Auto Build Intra-day Global Workbooks
  • Auto Build Intra-day Local Workbooks