Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Allocation Overview

2 Functional Design

• Functional Features and Assumptions
  • Overview: What Does Oracle Retail Allocation Do?
    • Item Sources
    • How Need is Determined
    • 'What if' On Hand
    • Purchase Order Addition
    • Holdback Quantity
    • Allocation Approval Process
  • Functional Assumptions
    • Advanced Shipping Notice-Based Allocation Assumptions
    • Item-location Assumptions
    • Calculation Multiple Assumptions
    • What if
    • Weight and Date User Selection 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
    • Receipt Plan Data Sources
    • History and Plan Data Sources
    • Plan Re-project Data Sources
    • Corporate Rules
    • Quantity Limits
    • Net Need at Store Level Calculation
  • Closing Allocations

3 Functional and Technical Integration

• Integration Interface Allocation-Related Dataflow
  • From Oracle Retail Demand Forecasting System to Oracle Retail Allocation via Merchandising System
  • From Oracle Retail Planning Application to Oracle Retail Allocation
  • From Size Profile Optimization to Oracle Retail Allocation
  • From Retail Demand Forecasting/Curve to Oracle Retail Allocation
  • From Oracle Retail Warehouse Management System to Oracle Retail Allocation via Oracle Retail Merchandising System
  • From Oracle Retail Promotion Management to Oracle Retail Allocation
  • From Oracle Retail Merchandising System to Oracle Retail Allocation
  • From Oracle Retail Allocation to Oracle Retail Merchandising System
  • From Oracle Retail Merchandising System to Oracle Retail Warehouse Management System
  • From Oracle Retail Active Retail Intelligence to Oracle Retail Allocation
• Persistence Layer Integration
  • Persistence Layer Integration (Including Tables and Triggers)
• Oracle Retail Merchandising System Functional Dependencies and Assumptions
  • Oracle Retail Merchandising System Differentiator Setup
  • Staple Item
  • Pack Item
  • Summary of Items and How Oracle Retail Allocation Handles Them
  • Oracle Retail Allocation Functional Assumptions Related to Oracle Retail Merchandising System

4 Oracle Retail Extract, Transform, and Load (RETL) Batch Processing

• Functional Overview
• Oracle Retail Extract, Transform, and Load Batch Processing Architecture
  • Processing Stage 1
  • Processing Stage 2
  • Configuration
    • Oracle Retail Extract, Transform, and Load
    • Oracle Retail Extract, Transform, and Load 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 Oracle Retail Extract, Transform, and Load 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
  • Oracle Retail Extract, Transform, and Load for Receipt and Plan
  • Oracle Retail Extract, Transform, and Load for Size Profile Optimization Data
  • Limitations of Oracle Retail Extract, Transform, and Load Programs

5 Java Batch Process

• Batch Processing Overview
  • Java Batch Names and Java Packages
  • Running a Java-based Batch Process
  • Scheduler and Command Line
    • Running the Dashboard Refresh Batch
    • Running the Schedule Allocation Batch
    • Running the Daily Cleanup Batch
    • Running the Purge Batches
    • Running the Rule Level On Hand Batch
  • Summary of Executable Files
• AllocScheduleBatch Process Batch Design
  • Usage
  • Detail
  • Log File
  • Properties File
  • Configuration
  • Assumptions and Scheduling Notes
• AlcDailyCleanUp Process Batch Design
  • Usage
  • Detail
• AlcPurgeAlloc AlcPurgeWksht Batch Processes Design
  • Usage
  • Details:
• Rule Level On Hand Pre-Aggregation Inventory Snapshot Batch Design
  • Usage
  • Detail
  • Package Details
  • Implementation

6 Internationalization

• Translation
• Setting the User Language
• Setting Date, Time, and Number Formats
• Translations

7 Implementing Functional Security

• Access Oracle Enterprise Manager Fusion Middleware Control
  • Displaying the Security Menu
• Managing Role Hierarchy
  • Adding or Removing Members from an Application Role
• Creating Job Roles
• Creating Duty Roles
  • Creating a New Application Role
  • Creating an Application Role from an Existing Role
• Security in Retail Applications
  • Single Sign On (SSO) Setup for Retail Fusion Platform Applications
  • Displaying External Application Contents in Non-SSO Environments

Index