Contents

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Customer Support
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Help Center (docs.oracle.com)
• Conventions

1 Introduction

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

2 Backend System Administration and Configuration

• System Assumptions
• reim.properties File
• ReIMResources.properties
• batch.properties

3 Integration

• Integration Overview
  • From the Supplier (to EDI) to Invoice Matching
  • From Invoice Matching (to EDI) to the Supplier
  • From Invoice Matching to the Staging Table for Financial Systems Interface
  • From the Merchandising System to Invoice Matching (Directly and Through EDI)
  • From Invoice Matching to Receiver Unit and Cost Staging Tables to Merchandising
  • From Invoice Matching 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

4 Technical Design

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

5 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 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
    • Merchandising
• 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