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
  • Data Access Patterns
    • Database Access Using ADFbc
    • Connection Pooling
  • Data Storage
    • Accessing Merchandising System Data in Real Time
• RESTful Web Services
  • Layering Model
    • Client Program
    • Enterprise Java Beans (EJB)
    • Application Module (AM)
    • Business Service
    • Data Access Objects
    • Technical Services
    • Threading Provider

3 Backend System Administration and Configuration

• System Assumptions
• reim.properties File
  • Array Process Size Settings
  • EDI Injector Properties
  • Credit Note AutoMatch Workspace Cleanup Setting
• system.properties File
  • Application Name
• Logging Configuration
  • Log4J Conventions
  • Log4J Properties
• Internationalization
  • Translation
  • Setting the User Language
  • Setting Date, Time, and Number Formats
  • Translations
• ReIMResources.properties
• batch.properties
• 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

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

• Using Custom Shared Library for Adding Custom Content
  • Creating and Deploying a Custom Shared Library
    • Download JDeveloper
    • Create the Custom Shared Library Workspace through JDeveloper
    • Generate and Deploy the Custom Shared Library WAR
  • Adding Custom Content into the Custom Shared Library
• Customizing the Retail Application User Interface
  • Overview of a Retail Application User Interface
  • Adding a Dashboard
  • Preparing the Custom Shared Library for Adding Dashboards
  • Adding a Dashboard into the UI Sidebar
    • Adding an Oracle BI EE based Dashboard into the UI Sidebar
  • Securing Dashboard Access to Specific Roles
  • Adding Contextual Reports
  • List of Contextual Business Events and Payloads
  • Preparing the Custom Shared Library for Adding Contextual Reports
  • Adding a Contextual Report To A Task Flow

8 Oracle BI EE Integration in Retail Application

• Showing Oracle BI EE Reports and Dashboards in the Retail Application
  • Various Examples of the BIReportFlow Taskflow
• Modifying the BIConnection Attributes at Runtime
• Enabling In-Context Launch from the Oracle BI EE Content
  • Enabling the ADF Contextual Event Action in Oracle BI EE
    • Preparing the Custom Shared Library for Contextual Event Model File
  • Enabling the ADF Contextual Event Action on the Target Column
  • Modifying the Oracle BI EE Analysis to Enable In-Context Launch
  • Passing Parameters from the Oracle BI EE Analysis to the Taskflow
  • Different Tabs for Each Set of Data
  • Pre-Processing the Data Before Opening the Content
  • In-Context Launch from the Chart View of the Analysis
  • Opening Different Taskflows from the Same Analysis

9 Troubleshooting

• Oracle BI EE Integration
  • The Oracle BI EE Dashboard Displays an Error Message 'An error occurred retrieving the BI content. Please contact your System Administrator'
  • Troubleshooting In-Context Launch
  • Contextual Area Displays a White Screen

10 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)
• 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

11 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

12 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

13 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

14 System Configuration

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

15 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