Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Related Documents
• Supplemental Documentation on My Oracle Support
• Customer Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• Allocation Overview

2 Technical Architecture

• Overview
  • Oracle Application Development Framework (ADF)
  • Retail Fusion Platform
  • Java Back-end Components
  • Data Access Patterns
  • Data Storage

3 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
    • ASN-Based Allocation Assumptions
    • Item-location Assumptions
    • Store 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
    • 'Stop Ship'
    • Net Need at Store Level Calculation
  • Closing Allocations

4 Back-end System Administration and Configuration

• Managing Asynchronous Processes
  • Overview of Asynchronous Processes in Retail Applications
  • Configuring JMS Resources for Asynchronous Processing
  • Monitoring Asynchronous Tasks Via the RAF_ASYNC_TASK Table
  • Purging the Asynchronous Tasks Table
• Managing the Notifications Feature
  • Overview of Notifications in Retail Applications
  • Purging the Notifications Table
• Managing Functional Security
  • Introduction to Retail Roles
    • Security Policy Stripe
    • Abstract Roles
    • Job Roles
    • Duty Roles
    • Privilege Roles
  • Retail Role Hierarchy
  • Default Security Reference Implementation
    • Privileges
    • Duties
    • Role Mapping
  • Extend the Default Security Reference Implementation
    • Using The Retail Application Security Role Manager

5 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 SPO to Oracle Retail Allocation
  • From RDF/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)
• 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

6 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
  • RETL for Receipt and Plan
  • RETL for SPO Data
  • Limitations of RETL Programs

7 Java Batch Process

• Batch Processing Overview
  • Java Batch Names and Java Packages
  • Running a Java-based Batch Process
  • Scheduler and Command Line
    • Running the Schedule Allocation Batch
    • Running the Daily Cleanup Batch
    • Running the Purge Batches
    • Running the RLOH 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:
• RLOH Pre-Aggregation Inventory Snapshot Batch Design
  • Usage
  • Detail
  • Package Details
  • Implementation

8 Allocation ReSTful Web Service Implementation

• Introduction
• Common Characteristics of Retail Application ReSTful Web Services
  • Deployment
  • Security
  • Standard Request and Response Headers
  • Standard Error Response
  • URL Path
  • Web Service APIs Process Flow
• List of ReSTful Web Services
  • Allocations
    • Approve
    • Load Recent Allocations by User
    • Load by Query
    • Load by Allocation Id
    • Load Item Location Information
    • Lookup Allocation Status
    • Lookup Process Status
    • Reserve
    • Submit
    • Withdraw
  • MerchHierarchies
    • Lookup Classes by Department
    • Lookup Class
    • Lookup All Deparments
    • Lookup Department
    • Lookup Subclasses by Department and Class
    • Lookup Subclass

9 In-Context Launching Task Flows In Retail Applications

• Limitations of an In-Context Launch Via URLs
• List of In-Context Launch Task Flows

10 Customizing Retail Applications

• Using Custom Shared Library for Adding Custom Content
  • Creating and Deploying a Custom Shared Library
    • Download JDeveloper
    • Create the Custom Shared Library Workspace through JDeveloper
    • Generate and Deploy the Custom Shared Library WAR
    • Reference the Custom Shared Library from the Retail Application
  • Adding Custom Content into the Custom Shared Library
• Customizing the Retail Application User Interface
  • Overview of a Retail Application User Interface Shell
  • Adding a Dashboard
  • Preparing the Custom Shared Library for Adding Dashboards
  • Adding a Dashboard into a User Interface Shell Sidebar
  • Securing Dashboard Access to Specific Roles
  • Adding Contextual Reports
  • List of Contextual Business Events and Payloads
  • Preparing the Custom Shared Library for Adding Contextual Reports
  • Adding a Contextual Report To A Task Flow

11 Implementing Functional Security

• Introduction to Retail Roles
  • Security Policy Stripe
  • Abstract Roles
  • Job Roles
  • Duty Roles
  • Privilege Roles
• Retail Role Hierarchy
• Default Security Reference Implementation
  • Privileges
  • Duties
  • Role Mapping
  • Extend the Default Security Reference Implementation
• Access Oracle Enterprise Manager Fusion Middleware Control
  • Display the Security Menu in Fusion Middleware Control
• Manage Role Hierarchy
  • Add or Remove Members from an Application Role
• Create Job Roles
• Create Duty Roles
  • Create a New Application Role
  • Create an Application Role from an Existing Role
• Security in Retail Applications
  • Displaying External Application Contents in Non-SSO Environments

12 Internationalization

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

Index