Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• 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

• Introduction to Allocation
  • N-tier Technical Architecture Overview

2 Backend System Administration and Configuration

• Backend System Administration and Configuration
  • Supported Environments
  • Exception Handling
  • Item Source Default for Item Search Page
  • Allocation.properties file
    • Fashion Item Ranging
    • Version of Merchandising System
    • Logging
    • DEBUG Mode on off Switch
    • Minimum and Maximum Pool Size to Maintain
    • Calculation Settings
    • Language to be Loaded
    • Item Location Warning
    • Type of Allocation
    • Set End of Week Day for the System
    • Number of Days before Release Date
    • Bulk Warehouse Setting
    • Minutes Until a System Locks from Inactivity
    • Connection Inactivity Timeout
    • Abandoned Connection Timeout
    • Bayesian Sensitivity Factor
    • Flexible Column Definition
    • Automatic Group Updates
    • LOV Configuration
    • Respect the ordhead.include_on_order_ind
    • Enable Estimated Freight Cost
    • Staple Pack Range
    • Display Future Unit Retail Price Values
    • Default Promotions Associated
    • Crossing Legal Entities
    • Supply Chain Path Setting (distribution_level)
    • Include Lead Time
    • Presentation Minimums
    • Default Store Calculation /PO Multiple
    • Location Exception Reason-product Sourced
    • Location Exception Reason - 'what if'
    • Import Warehouses
    • Default 'what if' Import Warehouse
    • 'What if' Summary Default Action
    • 'What if' Future Fulfillment Enabled
    • Enable Connection Pool Monitor
    • Enable Size Profile
    • List of Values (LOV) Layout
    • RSL IBM Settings
    • ALC_SHIPPING_SCHEDULE Shipping Path Levels
    • Enable Sister Store Data if Need is zero
    • round_fashion_on_alloc_details_apply
    • ruleVisibility
    • Connection Cache
    • Send Valid User to RPM
    • schemaOwner
    • pool.sqltracelevel
    • locationInListThreshold
    • date_format
    • Secondary
    • what_if_item_source_tier_query_level
    • future_available_what_if_allocations_enabled
    • refreshConnOnIOException
    • size_profile_validation_levels
    • rsl_rms_ibm_server
    • mail.host
    • mail.fromAddress
    • sso_logout_url
    • copyQLgroup
    • description_length
    • context_root
    • isMockConnection
  • JNDI Configuration File Related to RSL
  • Internationalization
    • Translation
    • Language Display in Allocation
    • Date Format Preferences

3 Technical Architecture

• Overview
• Component descriptions and standards
• GUI Tier
  • Thin-Client Standard
  • Java Server Pages (JSP) and HTML
  • Screen Controller Servlet
  • JavaScript
  • JSP Tag Libraries
• Middle Tier
  • Service Layer
  • Business Object Tier
  • Data Access Tier
• Data Storage Tier
  • Accessing Merchandising System Data in Real Time
• Summation of n-tier Architecture's Advantages

4 Functional Design

• Functional Features and Assumptions
  • Overview - What Does Oracle Retail Allocation Do?
    • Item Sources
    • How Need is Determined
    • 'What if' Allocation
    • Multi-level Distribution (MLD)
    • Rush Flag and Freight Cost
    • Holdback Quantity
    • Allocation Approval Process
  • Functional Assumptions
    • MLD Assumptions
    • ASN-based Allocation Assumptions
    • Item-location Assumptions
    • Presentation Minimum Assumptions
    • Store Calculation Multiple Assumptions
    • 'What if'
    • Lead Time Need Assumptions
    • Weight and Date User Selection Assumptions
    • Rush Flag and Freight Cost Assumptions
    • Proportional Allocation Assumption
  • Scheduled Allocation Constraints
    • Batch Job Considerations for Scheduled Allocations
    • Additional Validations for Scheduled Allocation
  • Allocation Status
    • Allocation Process Status
  • Sources of Data Used by Rules to Determine Gross Need
    • History Data Sources
    • Forecast Data Sources
    • Plan Data Sources
    • History and Plan Data Sources
    • Plan re-project Data Sources
    • Corporate Rules
    • Quantity Limits
    • Stop Ship
    • Net Need at Store Level Calculation
  • Closing Allocations

5 Functional and Technical Integration

• Integration Interface Allocation-Related Dataflow
  • From Forecasting System to Oracle Retail Allocation via Merchandising System
  • From Planning Application to Oracle Retail Allocation
  • From SPO to Oracle Retail Allocation
  • From RDF/Curve to Oracle Retail Allocation
  • From RPM to Oracle Retail Allocation
  • From Warehouse Management System (such as RWMS) to Retail Allocation via Merchandising System
  • From External Supply Chain Management System to Oracle Retail Allocation
  • From Merchandising System to Oracle Retail Allocation
  • From Oracle Retail Allocation to Merchandising System
  • From Merchandising System to Warehouse Management System (such as RWMS)
  • From Active Retail Intelligence to Oracle Retail Allocation
• RSL and Persistence Layer Integration
  • Oracle Retail Allocation and RSL for RMS and RPM
  • Persistence Layer Integration (Including Tables and Triggers)
• RMS Functional Dependencies and Assumptions
  • RMS Differentiator Setup
  • Staple Item
  • Pack Item
  • Summary of Items and How Oracle Retail Allocation Handles Them
  • Oracle Retail Allocation Functional Assumptions Related to RMS
• Integration with Oracle Retail Workspace

6 Allocation Calculations

• Calculation Queue Processing
  • Calculation Queue Process Description
  • Queue Scripts
    • Start (queue.sh)
    • Stop (queue.sh)
    • Status (queue.sh)
    • Restart (queue.sh)
    • Batch Queue (queue_batch_mode.sh)
    • Plan Re-project Algorithm
    • Guidelines
• Satisfying Need Across Multiple Locations
• Rounding Conditions
• Store Calculation Multiple
• Size Profile Logic
  • Enforce Size Profile
• Allocation of Packs
  • Algorithm with Packs and Singles
• Cascade Allocations
  • Staple Cascade
    • Staple Cascade
    • Staple Items - Cascade with RLOH
    • Staple Items - Cascade without RLOH
  • Fashion Cascade
    • Fashion Items - Cascade with RLOH
    • Fashion Items - Cascade without RLOH
    • Cascade with Fashion Items belonging to different levels
  • Cascade Mode Calculations for Pack SKUs
• Pack Distribution Allocations
• Variance Percent Calculation
• MLD Calculation Flows
  • Staple MLD Calculation
  • Fashion and Cascade MLD
• Store Warehouse Relationship
• Scheduled Allocation
• Prepack Algorithm
• What if Future Fulfillment
  • Overview
  • Example Scenarios

7 RETL Batch Processing

• Functional Overview
• RETL Batch Processing Architecture
  • Processing Stage 1
  • Processing Stage 2
  • Configuration
    • RETL
    • RETL User and Permissions
    • Environment Variables
    • alc_config.env Settings
  • Running the Module
    • Schema File
    • Mandatory Multi-Threading and Command Line Parameters
    • Business Virtual Date
    • Program Return Code
    • Program Status Control Files
    • Oracle Retail Allocation RETL Restart and Recovery
    • Message Logging
    • Program Error File
    • Oracle Retail Allocation Reject Files
  • Typical Run and Debugging Situations
    • Example for running load batch
  • Oracle Retail Allocation Program Reference
  • Application Programming Interface (API) Specification
    • File Layout

8 Java Batch Process

• Batch Processing Overview
  • Java Batch Names and Java Packages
  • Functional Description
  • Running a Java-based Batch Process
  • Scheduler and Command Line
    • Running the AllocScheduleBatch
  • Summary of Executable Files

Glossary

Index