Go to primary content
Oracle® Retail Financial Integration for Oracle Retail Merchandise Operations Management and Oracle Financials Oracle® Retail Financial Integration for Oracle Retail MOM and Oracle Financials
Release 16.0.2
F12910-03
Next
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 Retail Documentation on the Oracle Technology Network
Conventions
1
Understanding the Oracle Retail Financial Integration for Oracle Retail Merchandise Operations Management and Financials (E-Business Suite / PeopleSoft/CFIN)
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
Pre-requisites
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
Supplier Sequence Incremental Load
Data Requirements
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
How to Start or Run Initial Load of Supplier Parties from CFIN
Supplier Information Integration Extension
Payment Terms Integration
Overview
Pre-requisites
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 Combination Validation 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
Pre-requisites
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 and CFIN source data
Part IV: Scenario test
Running the Process Integration for Accounting Entries
5
Reviewing Process Integration for Retail Merchandise Procure to Pay
Process Integration for Retail Merchandise Procure to Pay Overview
Pre-requisites
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
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 - Domain Data Cross Reference Graphical User Interface
Handling Errors
Currency Exchange Rate, Supplier Information, GL Account Validation Integration Flows
Payment Terms - In case of PeopleSoft integration
ODI Interfaces
Global 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