Oracle Application Integration Architecture Oracle Value Chain Planning Integration Base Pack Implementation Guide

Contents

Title and Copyright Information

Send Us Your Comments

Preface

Understanding Oracle Value Chain Planning Integration Base Pack

Direct Integration for JD Edwards EnterpriseOne, PeopleSoft with Demantra, and Value Chain Planning
Prerequisites
Setup Overview
Integration Architecture
Business Processes
Solution Assumptions and Constraints

Overview of JDE E1 or PeopleSoft to VCP Integration

Overview

Understanding Batch Integration

Overview
Collecting Planning Data
Publishing Planning Results
Collecting Sales History
Collecting Price List and UOM
Publishing Forecast to Source System
Collecting PTP Data
Publishing PTP Results
Collect Deductions Settlement Management Data
Publish Deductions Settlement Management Results

Understanding Real-time Integration

Understanding the Global Order Promising Business Infrastructure
Understanding the Global Order Promising User Experience

Alternate Integration Scenarios

Information Sharing Options
Combining Extracts and Collections Across Systems
Multiple JDE E1 Instances
User Security

Configuring JD Edwards EnterpriseOne

Designating a Master Branch
Setting Up Costing Method 07
Setting Up Customer and Supplier Calendars
Customer, Branch and Item Category Codes
Extracting Customer, Branch and Item Category Codes
Setting Up Integration Constants
Defining Item Number Identifiers
Defining the Unit of Measure Type
Setting Up the Mapping Lot Status
Mapping the Sales Order and Purchase Order Status
Mapping the Work Order Priority Status
Mapping the Work Order Routing Status
Mapping the Work Order Status
Mapping the Forecast Consumption
Defining the Scaling Options (34A/SC)
Defining the Availability Calendar (34A/AC)
Defining the Number of Vehicles (34A/VC)
Synchronizing ODI Variables, Parameters and JDE E1 Constants

Configuring JD Edwards EnterpriseOne UBEs

Understanding EnterpriseOne UBEs
Understanding Versions
Parent and Child UBE Versions
Defining the Data Selections
Defining File Locations
Setting Up Unicode Encoding for XML Extracts
Setting Up JDE E1 UBEs
Creating Runubexml Template Files
Reviewing XML Batch Data Transfer
Setting Up the JDE to VCP Processor (R34A1000)
Setting Up the VCP to JDE Processor (R34A1500)
Setting up the Demantra to EnterpriseOne Imports (R34A410)
Reviewing Data Transfer

Configuring PeopleSoft Integration with Oracle Demantra Demand Management

Understanding PeopleSoft to Demantra Integration
Setting Up Calendar and Weight Profiles
Mapping PeopleSoft Fields To Demantra Fields
Exporting Data from PeopleSoft to Demantra
Importing Data from Demantra to PeopleSoft
Running the PeopleSoft to Demantra Integration
Step 1: Maintain User Data
Step 2: Build and Review the Demand History Process
Step 3: Export the Demand History Process
Step 4: Collect Planning Data
Step 5: Collect Sales History
Step 6: Collect Price List and UOM
Step 7: Forecast Management
Step 8: Publish to Source System
Step 9: Import the Forecast into PeopleSoft

Configuring Oracle Demantra

Setting Up Database Directories
Running Concurrent Programs for EBS to Demantra Integration
Updating Profiles
Updating the Demantra Data Model
Oracle Demantra Hierarchies
Adding Demantra Levels
Custom Hook Functionality
Custom Hooks Examples

Configuring VCP

Setting Up the Oracle EBS Planning Server
Profile Parameters

Adding Installation Steps for ODI 12.2.1

Certified Components
Installing the Middle Tier Components
Setting Up the JDE Shared Folders
Creating Database Schema's
Setting Up Property Files
Creating and Importing ODI Repositories
Testing ODI Topology Connections
Setting up the ODI Domain/Agent
Updating ODI Variables
Deploying the VCP Web Service
Configuring the VCP Web Service
Testing the VCP Web Service
Updating VCP Profiles
Setting Up the VCP Timeout Value in ODI

Configuring GOP

Configuring the GOP Web Service Data Source
Deploying the GOP Web Service
Setting Up GOP in EnterpriseOne

Configuring ODI for GOP

Setting Up ODI Web Service for GOP

Defining User Maintained Data

User-Maintained Data
Publishing User-Maintained Data
Manage Integration Parameters User Interface

Running JDE or PeopleSoft VCP Integration

Collections and Publish Options
Accessing the Collections Menu
Optional User-Defined Customizations

User Maintained Data Parameters

Integration Parameters

Error Handling and Troubleshooting

JD Edwards EnterpriseOne UBE Extracts
The Concurrent Program
File Transfers Between ODI and VCP or Demantra Directories
Downstream Concurrent Programs
Demantra Workflows
Web Service for GOP Deployment