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 Overview

2 Pre-implementation Considerations

• Considerations Prior to Implementation

3 Building a Production AIP-RPAS Domain

• AIP Installer
  • Hierarchy Data Overview
  • Production AIP-RPAS Domain Build Overview
  • Manipulate the Hierarchy Data, Part One
  • Run the AIP-RPAS Installer
  • How to Configure the AIP Solution
  • Insert External System Data into the AIP-RPAS Domain
  • Generate Load-Ready AIP Hierarchy Data
  • Create the AIP-RPAS Global Domain Configuration XML File
  • Manipulate the Hierarchy Data, Part Two
  • Build the AIP-RPAS Global Domain
  • AIP-RPAS Domain Build Completion Summary
  • Move the RPAS Domain (Optional)
  • Configure the RPAS Client to Use the Domain
• Post-Installation Instructions

4 System Configuration

• Setting Environment Variables
  • Configuring AIP-RPAS Environment Variables
    • Setting RPAS Position Level Security
    • aip_env_rpas.sh
    • aip_ro_common.sh
    • RPAS_TODAY
    • Number of Available File Handles (ULIMIT)
  • Configuring AIP Online Environment Variables
    • aip_env_online.sh
    • RETL
    • User Path
• Using the Scheduler to Run AIP Overnight Batch Processes
  • Pre-Critical Path Tasks
  • Critical Path Tasks
  • Post Critical Path Tasks
  • Interval Batch Tasks
    • Example 1: Interval Batch Tasks
    • Example 2: Interval Batch Tasks
    • Export to RO
    • Import from RO
    • Purging

5 AIP Online Configurations

• AIP Online UNIX Environment
  • config.xml
    • Configuration Field Descriptions
  • Integration Directories
  • Shared Files
  • Importing Configuration Files
• Export Configuration Files
• Oracle Database
  • SYSTEM_PARAMETERS
  • RESTART_CONTROL
  • ORDER_NUMBER
  • ORDER_PURGE_PERIOD
  • ORDER_DEFINITION
  • ORDER CYCLES
    • Store Order Cycles
    • Warehouse Order Cycles
  • DATA_PURGE_PARAMETERS
  • WH_TYPE_INITIAL_PACK_TYPE
  • SUPPLIER
  • STOCKING_POINT
  • SHIP_TO_WH_TYPE_SOURCE
  • SHIP_TO_WH_TYPE_DEST
  • ALERT_DEFINITION
  • ALERT_DEFINITION_DESC
  • ALERT_STATUS_DESC
    • Adding a Status
• AIP Application Server
  • main.properties
    • Publishing Purchase Orders and Transfer Data to RMS
    • main.properties Publication Properties
  • rcapps.properties
  • security.properties
  • strings.properties
• Config.properties
  • Order Management Settings

6 AIP-RPAS Configurations

• shortfallStorePriorityMatrix.xml
  • Default Shortfall Store Priority Matrix
• shortfallWarehousePriorityMatrix.xml
  • Default Shortfall Warehouse Priority Matrix
• surplusStorePriorityMatrix.xml
• Measures
  • aip_env_rpas.sh
  • IpRoLocTypeI
• Modifying Measure Base Intersections Using Configuration Tools
• Import Configuration Files
  • Moving Integration Data Source from RMS to a Non-RMS External System
    • Prerequisites for Moving the Source Application of an RMS Data Feed
    • Setup
    • Process

7 AIP Calendar Hierarchy

• AIP Calendar Data - clnd.dat or clnd.csv.dat
  • Setting Compatible Cycles
  • Notes on Manual Construction

8 Integration

• Overview of the Integrated Inventory Planning Suite
  • Integrated Inventory Planning Suite Data Flow
  • Data Flow Description
    • From a Demand Forecasting Application to APC RO
    • From a Demand Forecasting Application to a Replenishment System
    • From APC RO to RO
    • From a Replenishment System to RO
    • From a Demand Forecasting Application to RO
    • From RO to a Replenishment System
    • From ORSE to a Replenishment System

9 RMS Integration and Data Mapping

• RMS to AIP Data
  • Hierarchy Data
    • File Format
    • Mapping Table
  • Measure Data
    • Note on File Formats
    • File Formats
    • File Format Including Mapping to AIP-RPAS Measure Format
• RMS RETL Extract and RMS-AIP Transformation Overview
  • Mapping Overview
    • RMS-AIP Transform Scripts
  • Technical Details of Load Process

10 RMS Intra-day Integration and Data Mapping

• Measure Data

11 RDF Integration

• RDF to AIP Data
  • Measure Data
    • Note on File Formats
    • Technical Details of Load Process
  • iprdfdtdaltv.txt
  • sr0_rdfdtdmsk.txt
  • sr0_rdfdtdcnt.txt
  • sr0_fcterrlvl1.txti
  • sr0_fcterrlvl2.txt
  • isr0_frclvl1_[1..n].txt
  • sr0_frclvl2.txt

12 External System Integration

• External System to AIP Data
  • Hierarchy Data
  • Measure Data
  • External DM Data Loads
    • About External DM Data Loads
    • Regular/Conventional Method of Loading Data
    • Quick/Direct Method of Loading Data
    • Order of Load
    • Nightly Automation and External Data Load
    • System Parameters for Performance
    • Logging, Tracking and Reporting
• Hierarchy Data File Details
  • had.txt
  • intv.txt
• Measure Data Details
  • default_wh.txt
  • direct_store_format_pack_size.txt
  • direct_store_pack_size.txt
  • dmx_shpto_.txt
  • ipadrltntsi.txt
  • ipadendi.txt
  • ipadstai.txt
  • ipavgrtslsi.txt
  • ipfctwkprfd.txt
  • ipfctwkprfe.txt
  • iphldbckqtyi.txt
  • ipiavgrtslsi.txt
  • ipibcpcco.txt
  • ipldssi.txt
  • ipobcpcco.txt
  • ipodcmti.txt
  • iprplstcdi.txt
  • iprpltcdi.txt
  • ipslsi.txt
  • ipttlhlstki.txt
  • ipwhhldcpci.txt
  • item_attribute.txt
  • item_attribute_type.txt
  • rmse_order_purge.dat
  • sister_store.txt
  • sister_wh.txt
  • sr0_ad_.txt
  • sr0_ad_go_.txt
  • sr0_ad_irt.txt
  • sr0_ad_oth.txt
  • sr0_ad_rop.txt
  • sr0_adjsls.txt
  • sr0_avgrosld_.txt
  • sr0_co_.txt
  • sr0_dyscsls.txt
  • sr0_expwrtoff.txt
  • sr0_hstls_.txt
  • sr0_invadj.txt
  • sr0_knowndemand.txt
  • sr0_ovrstkflg.txt
  • sr0_rplcde.txt
  • sr0_rplsubcde.txt
  • sr0_ss_ld_.txt
  • sr0_tdgday.txt
  • sr0_wkbsf_ld.txt
  • sr0_wstadj.txt
  • srx_poidst.txt
  • srx_prdrpr.txt
  • store_format_pack_size.txt
  • store_pack_size.txt
  • sku_cost.dat
    • SKU Cost - Online Load Process
  • sku_weight_volume.dat
    • SKU Weight and Volume - Online Load Process
• External DM Data Load Files
  • ext_last_day_of_week.dat
  • ext_order_cycle.dat
  • ext_profile.dat
  • ext_receiving_calendar.dat and ext_receiving_cal_exc.dat
  • ext_order_group_assignment.dat
  • ext_order_multiple.dat
  • ext_pallet_multiple.dat
  • ext_warehouse_orderable_unit.dat
  • ext_wh_ranging.dat
  • ext_direct_store_format_pack_size.dat
  • ext_direct_store_pack_size.dat
  • ext_store_format_pack_size.dat
  • ext_store_pack_size.dat
  • ext_store_source.dat
  • ext_sku_promotion.dat

13 External System Intra-day Integration

• Measure Data Overview
  • Intra-day Measure Files Used by Daily Batch Only
  • Intra-day Measures Used by Intra-day Batch Only
  • Intra-day Measures Used by Both Daily and Intra-day Batches
• Details for Intra-day Measures Used by Daily Batch Only
  • idrplnflgl1i.txt
  • idrplnflgl2i.txt
  • idrplnflgl3i.txt
  • idrplnflgl4i.txt
  • idrwal1i.txt
  • idrwal2i.txt
  • idrwal3i.txt
  • idrwal4i.txt
• Details for Intra-day Measures Used by Intra-day Batch Only
  • idsnpshttiml1i.txt
  • idsnpshttiml2i.txt
• Details for Intra-day Measures Used by Both Daily and Intra-day Batches
  • ipddpl1i.txt
  • ipddpl2i.txt
  • ipddpl3i.txt
  • ipddpl4i.txt
  • ipddpl5i.txt
  • ipddpl6i.txt
  • iphrslsprofi.txt
  • iponshelfl1i.txt
  • iponshelfl2i.txt
  • iponshelfl3i.txt

14 RO Integration

• Store Measure Data
  • File and Measure Summary
  • STR_MINMAX
  • STR_DYNAMIC
  • STR_TIMESUPPLY
  • STR_HYBRID
  • STR_POISSON
  • STR_MINSS
  • STR_ROUpdate
• Warehouse Data Interfaces
  • File and Measure Summary
  • WH_MINMAX
  • WH_DYNAMIC
  • WH_TIMESUPPLY
  • WH_HYBRID
  • WH_MINSS
  • WH_ROUpdate

15 ORASE Integration

• ORASE to AIP Data
  • Measure Data
  • ipdmdtfrpcti.txt

16 AIP to RMS Interfaces and Data Mapping

• RIB Publications
• AIP Message Flow
• Purchase Order Messages
  • XORDERCRE
  • XORDERDTLCRE
  • XORDERMOD
  • XORDERDTLMOD
• Transfer Messages
  • XTSFCRE
• Allocation Messages
  • XALLOCCRE
• AIP to RMS Data
  • Messages Layout Tables
  • Purchase Orders and Transfers Message Flow in AIP
  • Store - Purchase Orders and Transfers Message Flow
• Warehouse - Purchase Orders and Transfers Message Flow
  • Data Formats for Creating Order - XORDERCRE
    • Filtering Conditions
  • Create Order Layout - XORDERDTLCRE
    • Filtering Conditions
  • Modify Order Header Layout - XORDERMOD
    • Filtering Conditions
  • Modify Order Layout - XORDERDTLMOD
    • Filtering Conditions
  • Create Transfer Layout - XTSFCRE
    • Filtering Conditions
  • AIP Purchase Order Messages - RMS Load Process
  • AIP Transfer Messages - RMS Load Process
  • XORDER Header - RMS ORDHEAD Mapping
    • Filtering Conditions
  • XORDER Detail - ORDSKU and ORDLOC Mapping
    • Filtering Conditions
  • XTSF Header - RMS TSFHEAD Mapping
    • Filtering Conditions
  • XTSF DTL - RMS TSFDETAIL Mapping
    • Filtering Conditions

17 AIP to External System Interfaces

• Text Files
  • purchase_order.dat.1
  • transfer_order.dat.1
  • allocation.dat.1

18 AIP to RO Interfaces

• Measures
  • STR_AIP_DATA
  • WH_AIP_DATA

19 First Day of AIP

• Overview
• The First Day of AIP Explained
  • Load Data
    • Impact to AIP on RPAS
    • Impact to AIP on Oracle
  • Enable Automated Data Maintenance
• The First Day of AIP Execution
• Step 1: Virtual Date (Vdate)
  • Step Details
  • Step Execution
• Step 2: Build the SRP Implementation Parameters Workbook
  • Step Details
  • Step Execution
• Step 3: First Day of AIP on RPAS Batch
  • Step Details
    • Hierarchy Files
    • Hierarchy Alerts
    • Attributes
    • Supply Chain Logical Links
  • Step Execution
• Step 4: First Day of AIP on Oracle Import
  • Step Details
    • Hierarchy Import
    • Data Management Import
  • Step Execution
• Step 5: First Day of AIP on Oracle Manual Setup
  • Step Details
  • Step Execution
• Step 6: First Day of AIP on Oracle Automation
  • Step Details
  • Step Execution
• Step 7: First Day of AIP on Oracle Import of Non-critical Alerts
  • Step Details
  • Step Execution
• Step 8: Manual Setup of AIP
  • Step Details
  • Step Execution

20 Internationalization

• Translation
  • Custom AIP Strings