Skip Headers
Oracle® Retail Allocation Operations Guide
Release 14.1
E57847-01
Index
Next
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