Contents

Title and Copyright Information

Send Us Your Comments

Preface

• Audience
• Documentation Accessibility
• Customer Support
• Review Patch Documentation
• Improved Process for Oracle Retail Documentation Corrections
• Oracle Retail Documentation on the Oracle Technology Network
• Conventions

1 Preinstallation Tasks

• Requesting Infrastructure Software
• Check Supported Database Server Requirements
• Check Supported ODI Requirements
• Check Supported Application Server Requirements
• Check Supported Client PC and Web Browser Requirements
• Supported Oracle Retail Products
• UNIX User Account Privileges to Install the Software
• Supported Oracle Applications
• ORFI and Oracle WebLogic Server Cluster

2 ORFI Installation

3 ORFI Database Installation Tasks

• Expand the ORFI Installer Distribution
• Database Schema Topology
• Create Tablespaces
• Create the ORFI Database User
• Run the ORFI Database Schema Installer
• Verification

4 ORFI Application Installation Tasks

• Prerequisite
• Expand the ORFI Installer Distribution
• Configure the Deployment Info for JSON File
• Service Consumer Security
• Generate the EBS Component
• Verify that the EBS jar has been Created
• Deploy the ORFI Application for EBS
• Deploy the ORFI Application for PeopleSoft
• Verification

5 EBS Database Installation Tasks

• Prerequisite
• Copy EBS Specific Files
• Create Tablespaces
• Create the ODI Staging Database User
• Create Database Link
• Run the EBS Initial Database Setup
• Verification

6 EBS Event Subscription Tasks

• EBS Event Subscription Setup
• EBS Event Subscription Install

7 PeopleSoft Database Installation Tasks

• Prerequisite
• Copy PeopleSoft Specific Files
• Create Tablespaces
• Create the ODI Staging Database User
• Create Database Link
• Run the PeopleSoft Initial Database Setup
• Verification

8 PeopleSoft Setup Tasks

• Integration Broker Configuration
  • Prerequisites to configure IB
  • Default Node
  • ANONYMOUS Node - Default User ID
  • Activating Pub/Sub Server Domains
  • Integration Broker Configuration Activities
  • Verifying IB Configuration
• Importing PSFT Project
  • Configuring Services
    • Vendor
    • Payment Terms
• Providing Web Service - GL Account Validation
  • Prerequisite to Provide Web Service
    • Provide Web Service
  • Providing Web Service - Drill Forward Service
    • Provide Web Service

9 ODI Setup Tasks

• Prerequisite
• Copy ODI-Specific Files
• Create Tablespaces
• Create the ODI Master Repository Database User
• Create the ODI Work Repository Database User
• ODI - Set Up Master Repository and Work Repository
• Validation - Master Repository and Work Repository Schema creation
• Create Master Repository
• Create Work Repository
• Import ODI Interfaces
• Update Connection Information
• Scenario Test
  • Scenario
  • Run Agent Scheduler
  • Generate Scheduler
  • Update Schedule
  • Check

A Appendix: Troubleshooting PeopleSoft Services

• Error - Building the Project Objects

B Appendix: JSON in Tabular Format

C Appendix: Installation Order

• Enterprise Installation Order