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 Introduction

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

2 Technical Architecture

• Overview
  • Oracle Application Development Framework (ADF)
    • Model-View-Controller (MVC) Architectural Pattern
    • ADF Security
    • ADF View (ADFv)
    • ADF Controller (ADFc)
    • ADF Business Components (ADFbc)
    • ADF Model (ADFm)
    • Oracle Metadata Services (MDS)
  • Retail Fusion Platform
  • ReIM Backend Service
  • Data Access Patterns
    • Database Access Using ADFbc
    • Connection Pooling
  • Data Storage
    • Accessing Merchandising System Data in Real Time

3 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
• Managing the Asynchronous Processes
  • Overview of Asynchronous Processes in Retail Applications
  • Configuring JMS Resources for Asynchronous Processing
  • Monitoring Asynchronous Tasks via the RAF_ASYNC_TASK Table
  • Purging the Asynchronous Tasks Table
• Managing the Notifications Feature
  • Overview of Notifications in Retail Applications
  • Purging the Notifications Table
  • Notification ReST Services
  • Enabling Mobile Push Notifications
    • Prerequisite: Android Google Cloud Messaging Registration
    • Server Configuration
• Managing Application Navigator
• Managing Functional Security
  • Introduction to Retail Roles
    • Security Policy Stripe
    • Abstract Roles
    • Job Roles
    • Duty Roles
    • Privilege Roles
  • Retail Role Hierarchy
  • Default Security Reference Implementation
    • Privileges
    • Duties
    • Role Mapping
  • Extending the Default Security Reference Implementation
    • Managing Roles in Retail Application Administration Console
  • Disabling Content
    • Safe Mode
    • Disabling Links in the Sidebar
  • Managing Oracle Metadata Services (MDS)
    • Overview of Oracle Metadata Services
    • Using the System MBean Browser and the MDSAppRuntime MBean
    • Exporting All Metadata Services Customizations
    • Exporting Metadata Services Customization for a Specific User
    • Deleting All Metadata Services Customizations for a User
    • Deleting a Customization for a Specific Page for All the Users
    • Deleting a Customization for a Specific Page for a Particular User
    • Importing All Metadata Services Customizations
    • Importing a Specific Page Customization for a User
    • Creating Metadata Labels
    • Promoting Metadata Labels
    • Listing Metadata Labels
    • Deleting Metadata Labels

4 Security in Retail Applications

• SSO Setup for Retail Fusion Platform Applications
• Displaying External Application Contents in Non-SSO Environments

5 Web Services in Retail Applications

• Common Characteristics of Retail Application ReSTful Web Services
  • Deployment
  • Security
  • Standard Request and Response Headers
  • Standard Error Response
• List of ReSTful Web Services
  • Platform ReSTful Web Services
    • Notification ReST Services
    • Access Control ReST Service
    • Favorites ReST Services
  • REIM ReSTful Web Services

6 In-Context Launching Task Flows in Retail Applications

• Limitations of In-Context Launch via URLs
• List of In-Context Launch Task Flows

7 Customizing Retail Applications

• Prerequisite Concepts
  • Understanding the Deployment of Retail Applications
  • Understanding the Retail Application User Interface
• Supported Customization Scenarios
  • Adding a Custom Shared Library
    • Downloading JDeveloper
    • Creating the Custom Shared Library Workspace through JDeveloper
    • Generating and Deploying the Custom Shared Library WAR
    • Referencing the Custom Shared Library from the Retail Application
  • Creating New ADF Contents
    • Custom Shared Library Must Be Regenerated
    • New Components Should Have Security Grants
    • Applying ADF Best Practices
    • Task Flow and Page Configuration Must Be Supported
    • The Same Data Source Must Be Used
  • Adding or Modifying an Item in the Reports Menu
    • Reports Menu Model XML Items
  • Adding or Modifying an Item in the Tasks Menu
  • Dashboard Customization Scenarios
    • Understanding Dashboards in Retail Applications
    • Adding a New ADF-based Dashboard in the Reports Menu
    • Adding a New External Dashboard into the Reports Menu
    • Retail Application Included Dashboard Customization Scenarios
  • Adding Contextual Reports
    • List of Contextual Business Events and Payloads
    • Preparing the Custom Shared Library for Adding Contextual Reports
    • Adding a URL based Contextual Report
    • Adding a DVT Taskflow based Contextual Report
  • Enabling Dynamic Task Items in the Retail Application
    • The DynamicContentHandler Interface
    • DynamicContent Type
    • Example Implementation of the DynamicContentHandler Interface
    • TaskMenuItem class
    • Default Dynamic Task Items
    • In-Context Launch of Dynamic Task Items
    • Report Adapters

8 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

9 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

10 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
    • IM_SYSTEM_OPTIONS Table Setup
    • Configuring WebService Credentials in Weblogic Server Enterprise Manager
• ReIM Transactional Maintenance
  • Calculation of TRANS_AMOUNT
  • Generation of Outgoing Data
  • Validation of Accounts When Posting Financial Entries
  • Validation of Accounts When Prepaying a Merchandise Invoice
  • Maintenance of Valid Accounts

11 PeopleSoft Financials Integration using Oracle Retail Financial Integration

• Participating Applications
• Assumptions and Dependencies
• Data Constraints
• Data Setup
  • RMS Data Setup and Configuration
    • Organization Units
    • Currency Exchange Rates
    • Supplier Address Types
    • Country Codes
    • Financial Calendar
    • Freight Terms
    • Payment Terms and Currency Exchange Rates
    • PeopleSoft Financials 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
  • CURRENCY PRECISION
    • Chart of Accounts Setup
    • Segment Mapping
    • Running the Initial Load from PeopleSoft Financials
    • IM_SYSTEM_OPTIONS Table 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
  • Drilling Back to RMS and ReSA from PeopleSoft Enterprise Financials
  • Drilling Back to ReIM from PeopleSoft Enterprise Financials
• Drilling Forward
  • Drilling Forward From RMS/ReSA to PeopleSoft Enterprise Financials
  • Drilling Forward From ReIM to PeopleSoft Enterprise Financials

12 System Configuration

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

13 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
• 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