Go to primary content
Oracle® Retail Invoice Matching Operations Guide
Release 19.3.000
F44130-02
Next
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 through the User Interface
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