Contents

List of Examples

List of Figures

List of Tables

Title and Copyright Information

Preface

• Common Oracle AIA Pre-Built Integration Guides
• Documentation Accessibility
• Additional Resources

Part I Understanding the Delivered Integrations

1 Oracle Financial Operations Control Integration Pack Overview

• 1.1 Understanding the Oracle Financial Operations Control Integration Pack
• 1.2 Key Benefits
• 1.3 Participating Applications
  • 1.3.1 Oracle RMS Overview
  • 1.3.2 Oracle ReSA Overview
  • 1.3.3 Oracle ReIM Overview
  • 1.3.4 PeopleSoft Payables Overview
  • 1.3.5 PeopleSoft GL Overview
• 1.4 Retail Sales Financial Business Process Flow
• 1.5 Retail Inventory Financial Business Process Flow
• 1.6 Retail Merchandise Procure to Pay Business Process Flow
• 1.7 Solution Assumptions and Constraints

2 Life Cycle Management for Reference Data

• 2.1 Currency Exchange Rate Integration
  • 2.1.1 Currency Exchange Rate Integration Overview
    • 2.1.1.1 Solution Assumptions and Constraints
  • 2.1.2 Currency Exchange Rate Integration Details
    • 2.1.2.1 Sequence Diagram
  • 2.1.3 PeopleSoft GL Interfaces
  • 2.1.4 Oracle RIB Interfaces
  • 2.1.5 Core AIA Components
  • 2.1.6 Integration Services
    • 2.1.6.1 CurrencyExchangePeopleSoftJMSConsumer
    • 2.1.6.2 SyncCurrencyExchangeListPeopleSoftReqABCSImpl
    • 2.1.6.3 CurrencyExchangeEBS
    • 2.1.6.4 SyncCurrencyExchangeListRetailProvABCSImpl
    • 2.1.6.5 SyncCurrencyExchangeListRetailProvJMSProducer
• 2.2 Payment Term Integration
  • 2.2.1 Payment Term Integration Overview
    • 2.2.1.1 Solution Assumptions and Constraints
  • 2.2.2 Payment Term Integration Details
    • 2.2.2.1 Sequence Diagram
    • 2.2.2.2 Multiple Language Support
  • 2.2.3 PeopleSoft Payables Interfaces
  • 2.2.4 Oracle RMS Interfaces
  • 2.2.5 Core AIA Components
  • 2.2.6 Integration Services
    • 2.2.6.1 PaymentTermPeopleSoftJMSConsumer
    • 2.2.6.2 SyncPaymentTermListPeopleSoftReqABCSImpl
    • 2.2.6.3 CreatePaymentTermPeopleSoftReqABCSImpl
    • 2.2.6.4 UpdatePaymentTermPeopleSoftReqABCSImpl
    • 2.2.6.5 PaymentTermEBS
    • 2.2.6.6 SyncPaymentTermListRetailProvABCSImpl
    • 2.2.6.7 CreatePaymentTermRetailProvABCSImpl
    • 2.2.6.8 UpdatePaymentTermRetailProvABCSImpl
    • 2.2.6.9 PayTermService
• 2.3 Suppliers Information Integration
  • 2.3.1 Supplier Integration Overview
    • 2.3.1.1 Solution Assumptions and Constraints
  • 2.3.2 Supplier Integration Details
    • 2.3.2.1 Sequence Diagram
    • 2.3.2.2 Multiple Language Support
  • 2.3.3 PeopleSoft Payables Interfaces
  • 2.3.4 Oracle RMS Interfaces
  • 2.3.5 Core AIA Components
  • 2.3.6 Integration Services
    • 2.3.6.1 SupplierPartyPeopleSoftJMSConsumer
    • 2.3.6.2 SyncSupplierPartyListPeopleSoftReqABCSImpl
    • 2.3.6.3 CreateSupplierPartyPeopleSoftReqABCSImpl
    • 2.3.6.4 UpdateSupplierPartyPeopleSoftReqABCSImpl
    • 2.3.6.5 SupplierPartyEBS
    • 2.3.6.6 SyncSupplierPartyListRetailProvABCSImpl
    • 2.3.6.7 CreateSupplierPartyRetailProvABCSImpl
    • 2.3.6.8 UpdateSupplierPartyRetailProvABCSImpl

3 Chart of Accounts Validation Integration Flow

• 3.1 Requesting Chart of Accounts Combination Validation
  • 3.1.1 Solution Assumptions and Constraints
  • 3.1.2 Chart of Accounts Combination Validation Integration Flow
• 3.2 Oracle Retail Interfaces
• 3.3 PeopleSoft GL Interfaces
• 3.4 Core AIA Components
• 3.5 Integration Services
  • 3.5.1 ProcessGLAccountValidationRetailReqABCSImpl
  • 3.5.2 ChartOfAccountsEBS
  • 3.5.3 ProcessGLAccountValidationPeopleSoftProvABCSImpl

4 Process Integration for Inventory Valuation and Revenue Recognition Accounting Entries

• 4.1 Process Integration for Inventory Valuation and Revenue Recognition Accounting Entries Overview
  • 4.1.1 Business Process Flow for the Integration of Accounting Entries
  • 4.1.2 Facts and Constraints
• 4.2 Performing Setup Tasks
• 4.3 Configuring and Generating Data in Oracle Retail
  • 4.3.1 Configuring the Data in Oracle Retail
  • 4.3.2 Generating the Data in Oracle Retail
• 4.4 Picking Up and Transforming the Data
• 4.5 Configuring and Running the Process Integration for Accounting Entries
  • 4.5.1 Configuring the Process Integration for Accounting Entries
    • 4.5.1.1 SettingUpAIAConfigurationProperties.XML
    • 4.5.1.2 Setting Up and Exporting DVMs
    • 4.5.1.3 Creating Views in Retail Database
  • 4.5.2 Setting Up a Schedule
  • 4.5.3 Running the Process Integration for Accounting Entries

5 Process Integration for Retail Merchandise Procure to Pay

• 5.1 Process Integration for Retail Merchandise Procure to Pay Overview
  • 5.1.1 Business Process Flow for Integration of Retail Merchandise Procure to Pay
  • 5.1.2 Solution Assumptions and Constraints
• 5.2 Performing Setup Tasks
  • 5.2.1 Setup Tasks Specific to Oracle ReIM
  • 5.2.2 Setup Tasks Specific to PeopleSoft Payables
  • 5.2.3 Setup Tasks Specific to the Integration Layer
• 5.3 Configuring and Generating Data in Oracle Retail
  • 5.3.1 Configuring the Data in Oracle Retail
  • 5.3.2 Generating the Data in Oracle Retail
• 5.4 Picking Up and Transforming the Data
• 5.5 Configuring and Running the Process Integration for Retail Merchandise Procure to Pay
  • 5.5.1 Configuring the Process Integration for Retail Merchandise Procure to Pay
    • 5.5.1.1 Setting Up AIAConfigurationProperties.XML
    • 5.5.1.2 Setting Up and Exporting DVMs
    • 5.5.1.3 Creating Views in Retail Database
  • 5.5.2 Setting Up a Schedule
  • 5.5.3 Running the Process Integration for Retail Merchandise Procure to Pay

6 Drill Back and Drill Forward

• 6.1 Drill Back and Drill Forward Overview
  • 6.1.1 Setup Activities
  • 6.1.2 Solution Assumptions and Constraints
• 6.2 Drill Back and Drill Forward Details
  • 6.2.1 Drill Back Details
  • 6.2.2 Drill Forward Details
  • 6.2.3 Overall Flow
• 6.3 Service Solution Components
  • 6.3.1 Service Solution Component Details

Part II Implementing the Delivered Integrations

7 Configuring the Oracle Financial Operations Control Integration Pack

• 7.1 Prerequisites
  • 7.1.1 Currency Exchange Rate Prerequisites
  • 7.1.2 Payment Term Prerequisites
  • 7.1.3 Supplier Information Prerequisites
  • 7.1.4 Inventory Valuation and Revenue Recognition Accounting Entries Prerequisites
  • 7.1.5 Retail Merchandise Procure to Pay Prerequisites
  • 7.1.6 Drill Back and Drill Forward Prerequisites
• 7.2 Data Requirements
  • 7.2.1 Currency Exchange Rate Data Requirements
  • 7.2.2 Payment Term Data Requirements
    • 7.2.2.1 Class Diagram
  • 7.2.3 Supplier Information Data Requirements
    • 7.2.3.1 Class Diagram
  • 7.2.4 Chart of Accounts Validation Data Requirements
  • 7.2.5 Inventory Valuation and Revenue Recognition Accounting Entries Data Requirements
  • 7.2.6 Retail Merchandise Procure to Pay Data Requirements
  • 7.2.7 Drill Back and Drill Forward Data Requirements
• 7.3 Setting Up Oracle Retail Applications
• 7.4 Setting Up PeopleSoft GL
• 7.5 Setting Up PeopleSoft Payables
• 7.6 Setting Up Cross-References for Oracle Retail IDs and PeopleSoft Entities
  • 7.6.1 Populating Cross-References
  • 7.6.2 Validating Cross-References
  • 7.6.3 Viewing Cross-Reference Data
• 7.7 Setting Up PeopleSoft Domain Value Maps
• 7.8 Manually Synchronizing Freight Terms
• 7.9 Manually Synchronizing Currency Exchange Rate Types
• 7.10 Manually Synchronizing Currency Codes
• 7.11 Manually Synchronizing Chart of Accounts Values
• 7.12 Manually Synchronizing Financial Calendars
• 7.13 Mapping Business and Organization Units
• 7.14 Working with Cross-References
• 7.15 Working with DVMs
• 7.16 Handling Errors
• 7.17 Viewing EIMs
• 7.18 Setting Configuration Properties