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

• What is Retail Invoice Matching?
• Oracle Retail-Based Enterprises

2 Backend System Administration and Configuration

• System Assumptions
• reim.properties File
• Logging Configuration
  • Log4J Conventions
  • Log4J Properties
• Internationalization
  • Translation
  • Setting the User Language
  • Setting Date, Time, and Number Formats
  • Translations
• ReIMResources.properties
• batch.properties

3 Integration

• Integration Overview
  • From the Supplier (to EDI) to ReIM
  • From ReIM (to EDI) to the Supplier
  • From ReIM to the Staging Table for Financial Systems Interface
  • From the Merchandising System to ReIM (Directly and Through EDI)
  • From ReIM to Receiver Unit and Cost Staging Tables to RMS
  • From ReIM to the Merchandising System
• Electronic Data Interchange (EDI) Tables and Files
  • The EDI Reject Table
  • The EDI Reject File
  • EDI Injector File Layout (Based on EDI 810)
    • All Files Layouts Input and Output
    • Notes
  • EDI Invoice Download File Layout (Based on EDI 812)
• Document Induction via UI
• Financial System Interface
  • Foundation Financial Data Overview
    • Location Account Segments
    • Department/Class Account Segments
  • Financial Transactions
    • Complex and Fixed Deal-Related Posting
    • Financial Posting
  • Tracking Receipt Posts
    • Tables Related to Tracking Receipt Posts
    • Multiple Lines for an Individual Receipt Item
• LDAP and Other User Interfaces
  • LDAP
    • Setup Steps within LDAP
    • Setup Steps within ReIM
    • Additional LDAP Resources

4 Technical Design

• Locking Design Summary
• Currency Design Summary
  • Merchandising System (such as RMS) and ReIM Assumptions
  • Currency Conversion Process for Amount Tolerances
  • Currency-Related System Validations
  • Currency Formatting

5 System Configuration

• Define System Options
• Define Supplier Options
• Define Matching Tolerance
• Define matching Strategies
• Define Reason Codes
• Define GL Mappings

6 Batch Processes

• Batch Architectural Overview
  • Batch Process Configuration
  • EDI-Related File-Based Batch Processes
  • Internal Batch Processes
  • Internal Batch Processes that Write to Staging Tables
  • Batch Processes that Extract from Merchandising System (RMS) Staging Tables
• Batch Names
• Functional Descriptions and Dependencies
• Features of the Batch Processes
  • Scheduler and the Command Line
  • Batch Return Values
  • Batch Log and Error File Paths
  • Multi-Threading Batch Processes
    • Complex Deal Upload (ComplexDealUploadBatch)
    • Fixed Deal Upload (FixedDealUploadBatch)
    • EDI Injector (EdiInjectorBatch)
    • Auto-Match (AutoMatchBatch)
  • A Note about Restart and Recovery
• Executing Batch Processes
• Tables Purge Batch Design
  • Usage
  • Purge Operational
  • Purge Workspace
  • Purge Workspace and Operational
  • Primary Tables Involved
    • Operational
    • Workspace
• Accounts Purge Batch Design
  • Usage
  • Major Modules
  • Major Tables
• EDI Invoice Injector Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Restart and Recovery
  • High-Level Flow Diagram
  • Primary Tables Involved
• Invoice Auto-Match Batch Design
  • Usage
  • Algorithms
  • Assumptions and Scheduling Notes
  • High-Level Flow Diagram
  • Primary Tables Involved
• Credit Note Auto-Match Batch Design
  • Usage
  • Algorithms
  • Assumptions and Scheduling Notes
  • Post Processing
  • High-Level Flow Diagram
  • Primary Tables Involved
• Receipt Write-Off Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • High-Level Flow Diagram
  • Primary Tables Involved
    • REIM
    • RMS
• Reason Code Action Rollup Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • High-Level Flow Diagram
  • Primary Tables Involved
• Financial Posting Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Primary Tables Involved
    • Lookup Tables that must be Populated
    • Tables to Which the Process Posts Data
  • Financial System Integration
• EDI Invoice Download Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Primary Tables Involved
  • Restart and Recovery
• Complex Deal Upload Batch Design
  • Usage
  • Primary Tables Involved
  • Multi-Threading
  • BlockSize
  • PartitionNo
  • Generation of Debit Memo (or Credit Note Requests) for Deals
• Fixed Deal Upload Batch Design
  • Usage
  • Primary Tables Involved
  • Multi-Threading
  • BlockSize
  • PartitionNo
  • Generation of Debit Memo (or Credit Note Requests) for Deals