Contents

List of Figures

List of Tables

Title and Copyright Information

Send Us Your Comments

Preface

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

1 Understanding the Oracle Retail Financial Integration for Oracle Retail Merchandise Operations Management and Financials (E-Business Suite / PeopleSoft / Cloud Financials)

• Overview
• Key Benefits
• Participating Applications Overview
  • Oracle Retail Merchandising System
  • Oracle Retail Sales Audit
  • Oracle Retail Invoice Matching
  • Oracle Payables
  • Oracle General Ledger
• Retail Sales Financial Business Process Flow
• Retail Inventory Financial Business Process Flow
• Retail Merchandise Procure to Pay Business Process Flow
• Solution Assumptions and Constraints

2 Reviewing Life Cycle Management for Reference Data

• Currency Exchange Rate Integration
  • Overview
    • Prerequisites
    • Solution Assumptions and Constraints
  • EBS: - Currency Exchange Rate Integration Details
    • Incremental Loading of Currency Exchange Rates
  • PeopleSoft: - Currency Exchange Rate Integration Details
    • Incremental Loading of Currency Exchange Rates
• Initial Loading of Currency Exchange Rates
  • How to Start or Run Initial Load of Exchange Rates
  • Data Requirements
  • Currency Exchange Rate Integration Extension
• Suppliers Information Integration
  • Supplier Integration Overview
    • Prerequisites
    • Solution Assumptions and Constraints
  • EBS:-Supplier Integration Details
    • Supplier Sequence Incremental Load
  • PeopleSoft:-Supplier Integration Details
    • Supplier Sequence Incremental Load
  • Financials Cloud:-Supplier Integration Details
  • Data Requirements (EBS/PSFT/CFIN)
    • Supplier Filter
    • Supplier Error Handling
    • EBS and CFIN: - Class Diagram
    • PeopleSoft: - Class Diagram
    • Retail: - Class Diagram
  • How to Start or Run Initial Load of Supplier Parties from EBS and Peoplesoft
  • Start or Run Initial Load of Supplier Parties from CFIN
  • Supplier Information Integration Extension
• Payment Terms Integration
  • Overview
    • Prerequisites
    • Solution Assumptions and Constraints
  • Payment Terms Integration Details
    • Incremental Loading of Payment Terms Rates
• Initial Loading of Payment Terms
  • How to Start or Run Initial Load of Payment Terms
  • Data Requirements
• Drill Back and Drill Forward Integration
  • Overview
    • Pre-requisites
    • Solution Assumptions and Constraints
  • Drill Back and Drill Forward Integration Details
    • Drill Back Details
    • Drill Forward Details
  • Service Solution Components
  • Service Solution Component Details
  • Data Requirements

3 Requesting Chart of Accounts Validation

• Requesting Chart of Accounts Combination Validation
  • Prerequisites
  • Solution Assumptions and Constraints
  • EBS: Chart of Accounts Combination Validation Integration Flow
  • PeopleSoft:- Chart of Accounts Combination Validation Integration Flow
  • Financials Cloud:- Chart of Accounts CombinationValidation Integration Flow
• Oracle Retail Interfaces
  • Data Requirements

4 Reviewing Process Integration for Inventory Valuation and Revenue Recognition Accounting Entries

• Process Integration for Inventory Valuation and Revenue Recognition Accounting Entries Overview
  • Business Process Flow for the Integration of Accounting Entries
  • Prerequisites
  • Facts and Constraints
• Performing Setup Tasks
  • Setup Tasks Specific to Oracle Financials (General Ledger)
• Configuring and Generating Data in Oracle Retail
  • Configuring the Data in Oracle Retail
  • Generating the Data in Oracle Retail
• Picking Up and Transforming the Data
• Configuring and Running the Process Integration for Accounting Entries
• Configuring the Process Integration for Accounting Entries
  • Setting Up a Schedule
    • Part I: Set Up Master Repository and Work Repository
    • Part II: Set Up Domain Value Maps
    • Part III: Set up EBS source data
    • Part IV: Scenario test
  • Running the Process Integration for Accounting Entries
  • Running the Process Integration for Accounting Entries (CFIN)

5 Reviewing Process Integration for Retail Merchandise Procure to Pay

• Process Integration for Retail Merchandise Procure to Pay Overview
• Prerequisites
  • Assumptions and Constraints
  • Performing Setup Tasks
  • Setup Tasks Specific to ReIM
  • Setup Tasks Specific to Oracle Payables
• Configuring and Generating Data in Oracle Retail
  • Configuring the Data in Oracle Retail
    • Generating the Data in Oracle Retail
  • Configuring and Running the Process Integration for Retail Merchandise Procure to Pay
    • Configuring the Process Integration for Retail Merchandise Procure to Pay
    • Running the Process Integration for Accounting Entries (EBS and PSFT)
    • Running the Process Integration for Accounting Entries (CFIN)
• Data Requirements

6 Implementing Oracle Retail Merchandise Integration Pack for Oracle Financials (EBS /PeopleSoft / CFIN Financials)

• Setting Up Oracle Retail Applications
• Setting Up Oracle General Ledger (GL)
  • Setting Up Oracle Payables
• RFI Database Schema Topology
• Setting Up Cross-References for Oracle Retail IDs and Oracle Entities
• Setting Up Oracle Domain Value Maps
• Synchronizing Freight Terms Manually
• Synchronizing Currency Exchange Rate Types Manually
• Synchronizing Currency Codes Manually
• Synchronizing Chart of Accounts Segments Manually
• Synchronizing Financial Calendar Manually
• Working with Cross-References
• Working with Domain Value Maps (DVM)
• RFI - Manage DVM Graphical User Interface
• Handling Errors
  • Currency Exchange Rate, Supplier Information, GL Account Validation Integration Flows
  • Payment Terms - In case of PeopleSoft integration
  • ODI Interfaces
  • Bulk Adapters Interfaces
    • RMS Account Entry
    • ReIM Account Entry
    • ReIM Invoice Entry
    • Logs
  • Global Logs
  • RFI Logs
• Understanding the RFI Administration User Interface
  • Scheduling Adapters
  • Global Logs

7 Retail Hybrid Integration with EBS using BDI Applications

• Hybrid Cloud Integration
• Implementation Details
  • BDI Job Admin Application Implementation
  • BDI Process Flow Application Implementation
  • BDI Scheduler Application Implementation

8 Configuring Web Service Security