Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Related Documents
• Customer Support
• Review Patch Documentation
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Introduction

• What is Retail Invoice Matching?
• Oracle Retail-Based Enterprises
• Technical Architecture Overview

2 Backend System Administration and Configuration

• System Assumptions
• reim.properties File
  • Data Source Configuration Settings
  • Data Source Connection Pool Configuration Settings
  • Document Settings
  • Date Setting
  • Array Process Size Settings
  • EDI Properties
  • Lookout Timeout Variables
  • Credit Note AutoMatch Batch Multi-threading Options
  • Credit Note AutoMatch Workspace Cleanup Setting
  • Invoice AutoMatch Specific Properties
  • Generic Threading Options (EdiUpload and AutoMatch)
  • Translation Caching Timeouts
  • Logging Configuration Settings
  • Authentication Settings
  • Online Help
  • Security Settings
• system.properties File
  • Dynamic / Non-Dynamic GL Options
  • Mapping of Document Types to Action Codes
  • Labeling Child Invoices
  • Setting the Audit Period
  • Data Translation Options
  • Set of Books Option
  • Duplicate Items Option
  • Maximum Segments Supported
  • Application Name
  • Maximum Line Segments
• Logging Configuration
  • Log4J Conventions
  • Log4J Properties
• Internationalization
  • Translation
  • Language Configuration
  • Supported Date Formats
  • Cache Sizes for Translation Service
  • ReIMResources.properties

3 Technical Architecture

• Overview
• The Layering Model
  • Presentation Layer
  • Middle Tier
    • Service Layer Responsible for Business Logic
    • Business Objects
  • Data Access Layer (DAL)
  • Database Layer
  • Technical Services
    • Application Parameter Service
    • System Parameter Service
    • Transaction Service
    • Error Logging Service
    • Log4J
    • Internationalization Service
    • Currency Service
    • Time/Date Service
    • Security Service
  • Third Party Libraries
• ReIM-Related Java Terms and Standards

4 Functional Design

• Invoice and Credit Note Matching Process Flow
• The Auto-Match Process
  • TAX on Header Level Only Invoices
  • Cost Pre-Matching
  • PO/Location Summary Group Matching
  • One-to-One Invoice Matching
  • Elibigility for Line-Level Matching
  • Line-Level Matching
  • Recycling and Overall Flow
  • Partially Matched Receipts
  • Matching Tolerances
  • History and Metrics
• Best Terms Calculations
  • Terms Ranking Overview
  • Supplier Options
  • Terms Date
  • Assumptions and Dependencies
• Credit Note Auto-Matching
  • Configurable Keys (Flexible Pool Keys)
    • Summary Group Matching Algorithm
    • One-to-One Invoice Matching Algorithm
    • Line Level Matching Algorithm
    • Discrepancy Creation and Resolution in Line Level Matching
  • Role of Reason Code Action Rollup Batch in Credit Note Matching
  • Currencies
  • TAX Matching
  • History and Record Keeping
  • Data Purge

5 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
  • Integrating ReIM with Oracle Retail Workspace
• Electronic Data Interchange (EDI) Tables and Files
  • The EDI Reject Table
  • The EDI Reject File
  • EDI Invoice Upload File Layout (Based on EDI 810)
    • All Files Layouts Input and Output
    • Notes
  • EDI Invoice Download File Layout (Based on EDI 812)
• 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

6 Technical Design

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

7 PeopleSoft Enterprise Financials Integration

• Participating Applications
• Assumptions and Dependencies
• Data Constraints
• Data Setup
  • RMS Data Setup and Configuration
    • RMS System Options
    • Organization Units
    • Currency Exchange Rates
    • Supplier Address Types
    • Country Codes
    • Financial Calendar
    • Freight Terms
    • Payment Terms and Currency Exchange Rates
    • PeopleSoft Enterprise Financials Org Units and Site IDs
    • Store and Warehouse Maintenance
    • RMS General Ledger Setup
    • RMS General Ledger Cross Reference
    • ReSA General Ledger Cross Reference
    • Configuring Drill Back and Forward Web Services
  • ReIM Data Setup and Configuration
    • System Options
    • IM_CURRENCY_LOCALE
    • Chart of Accounts Setup
    • Segment Mapping
    • Running the Initial Load from PeopleSoft Enterprise Financials
    • integration.properties File Setup
    • Reporting
• ReIM Transactional Maintenance
  • Calculation of TRANS_AMOUNT
  • Generation of Outgoing Data
  • Validation of Accounts When Posting Financial Entries
  • Maintenance of Valid Accounts
  • Building and Posting Reference IDs
• Drilling Back to RMS, ReSA and ReIM - Overview
  • Drilling Back to RMS and ReSA - Detail
  • Drilling Back From ReIM - Detail
• Drilling Forward
  • Drilling Forward From RMS/ReSA to PeopleSoft Enterprise Financials
  • Drilling Forward From ReIM to PeopleSoft Enterprise Financials
    • AIA DVM Mapping Examples

8 Oracle E-Business Suite Financials Integration using Oracle Retail Financial Integration

• Participating Applications
• Assumptions and Dependencies
• Data Setup
  • RMS Data Setup and Configuration
    • RMS System Options
    • Organization Units
    • Currency Exchange Rates
    • Supplier Address Types
    • Country Codes
    • Financial Calendar
    • Freight Terms
    • Payment Terms and Currency Exchange Rates
    • Oracle E-Business Suite Financials Units and Site IDs
    • Store and Warehouse Maintenance
    • RMS General Ledger Setup
    • RMS General Ledger Cross Reference
    • ReSA General Ledger Cross Reference
  • ReIM Data Setup and Configuration
    • System Options
    • Chart of Accounts Setup
    • Segment Mapping
    • Running the Initial Load from Oracle E-Business Suite Financials
    • integration.properties File Setup
• ReIM Transactional Maintenance
  • Calculation of TRANS_AMOUNT
  • Generation of Outgoing Data
  • Validation of Accounts When Posting Financial Entries
  • Maintenance of Valid Accounts

9 Batch Processes

• Batch Architectural Overview
  • 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 Invoice Upload (EdiUploadBatch)
    • Auto-Match (AutoMatchBatch)
  • A Note about Restart and Recovery
• Executing Batch Processes
• Tables Purge Batch Design
  • Usage
  • SQL Queries
  • Manual Propagation (Cascade) of Deletes to Child Tables
    • Cascade Relationships
  • Assumptions and Scheduling Notes
  • Major Modules
    • TablesPurgeBatch
  • Primary Tables Involved
• Accounts Purge Batch Design
  • Usage
  • Major Modules
  • Major Tables
• Discrepancy Purge Batch Design
  • Usage
  • Major Modules
  • Major Tables
• EDI Invoice Upload Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Restart and Recovery
  • Primary Tables Involved
• Invoice Auto-Match Batch Design
  • Usage
  • Algorithms
  • Assumptions and Scheduling Notes
  • Post Processing
  • 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
• Disputed Credit Memo Action Rollup Batch Design
  • Assumptions and Scheduling Notes
  • 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
• EDI Invoice Download Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Primary Tables Involved
  • Restart and Recovery
• Complex Deal Upload Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Primary Tables Involved
  • Multi-Threading
  • BlockSize
  • PartitionNo
  • Generation of Debit Memo (or Credit Note Requests) for Deals
• Fixed Deal Upload Batch Design
  • Usage
  • Assumptions and Scheduling Notes
  • Primary Tables Involved
  • Multi-Threading
  • BlockSize
  • PartitionNo
  • Generation of Debit Memo (or Credit Note Requests) for Deals