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 System Administration

• Radio Frequency Operations
  • Using Kiosk Mode
• Operating System Functions
  • Printer Queues
  • Operating System Scheduled Jobs
  • File Management (Directories)

3 DBA Administration Module

• Display Locks on Tables
• Display Table Information
• Display Rollback Information
• Display Index Information
• Display Sequences Information
• Display Error Log
• View Error Log Details
• Delete Error Log Records
• Manual Script Launch Editor

4 Batch Management

• Security
  • Passwords

5 Subsystem Interfaces

• Batch File Formats
• Unit Pick System Files
  • Allocation Data Download
  • Inbound Carton Download
  • Process UPS Upload
• Pick By Light Interface
  • Files and Directories
  • Download Transactions
    • Destination Container Download
    • Distribution Item Download
    • Inventory Adjustment Download
  • Upload Transactions
    • Ship Destination Upload
    • Distro Item Upload
    • Expected Source Container Upload
    • Source Container Upload
• Sortation Subsystem Interface
  • Files and Directories
  • Download Transactions
    • Container Divert Message
  • Upload Transactions
    • Container Divert Instruction Message
• Manifest Mailing System
  • Packages
    • sub_mms_manifest_status.pkg
    • sub_mms_manifest_close.pkg
    • ShippingManifestSelectionServi.pkg
  • MMS View
    • MMS Container View
• Rapistan Socket Interface
  • Triggers
    • create_sorter_instruction_trg
    • cont_dest.sql
  • Packages
    • process_diverts_a.sql
    • combine_wip_codes.osp
    • receive_container2.osp
  • Tables
    • Sorter_Intake
• Third Party Routing Interface
  • Packages
    • ship_cube_inquiry.pkg
    • route_data_upload.pkg
    • de_sort_picks.osp
    • route_data_upload.sh and route_data_upload.sql
  • Download Transactions
  • Upload Transactions
    • Distro Route Upload
    • Carrier Service Route Upload
    • Route Date Upload
    • Route Dest Upload

6 Appendix: Error Codes

• Detail of Procedures
• Appendix: Error Codes
  • Error Codes in Numerical Order
  • Error Codes in Alphabetical Order

Index