Contents

List of Figures

List of Tables

Title and Copyright Information

Preface

• What's New in this Guide
• Common Oracle AIA Pre-Built Integration Guides
• Documentation Accessibility
• Additional Resources

Part I Understanding the Delivered Integrations

1 Agile Product Lifecycle Management and JD Edwards EnterpriseOne

• 1.1 Overview
• 1.2 Solution Assumptions and Constraints
• 1.3 Architecture of Agile PLM Integration
• 1.4 Business Process Flows
  • 1.4.1 Agile PLM to JD Edwards EnterpriseOne Process Flow
    • 1.4.1.1 Agile PLM to JD Edwards EnterpriseOne Processes
  • 1.4.2 JD Edwards EnterpriseOne to Agile PLM Process Flow
    • 1.4.2.1 JD Edwards EnterpriseOne to Agile PLM Initial Load
    • 1.4.2.2 JD Edwards EnterpriseOne to Agile PLM Processes
    • 1.4.2.3 JD Edwards EnterpriseOne Item and Unit Cost Information to Agile PLM (Batch)
    • 1.4.2.4 JD Edwards EnterpriseOne Item Balance Information to Agile PLM (Batch)
• 1.5 Components of Agile PLM Integration Pack for JD Edwards EnterpriseOne Integration
  • 1.5.1 Oracle AIA Foundation Pack
  • 1.5.2 Agile PLM
  • 1.5.3 JD Edwards Enterprise One

2 Process Integration for Initial Load of Items and Bill of Materials

• 2.1 Overview
• 2.2 Item and Bill of Materials Initial Load Integration Flow
  • 2.2.1 Item Initial Load Flow
  • 2.2.2 BOM Initial Load Flow
  • 2.2.3 Initial Load Orchestration
• 2.3 Solution Assumptions and Constraints
• 2.4 JD Edwards EnterpriseOne Interfaces
• 2.5 Core AIA Components

3 Process Integration for Item Attributes and Cost Updates

• 3.1 Overview
• 3.2 Item Attributes and Cost Updates Process Integration
  • 3.2.1 Update Item Attribute Flow
  • 3.2.2 Update Item Attribute Orchestration
• 3.3 Solution Assumptions and Constraints
• 3.4 Agile PLM Interfaces
• 3.5 JD Edwards EnterpriseOne Interfaces
• 3.6 Core AIA Components
• 3.7 Agile PLM and JD Edwards EnterpriseOne Components for Update Item Attributes
• 3.8 Integration Services
  • 3.8.1 ItemEBSV2
  • 3.8.2 UpdateItemListJDEE1ReqABCSImpl
  • 3.8.3 UpdateItemListAgileProvABCSImpl

4 Process Integration for Item Balance Updates

• 4.1 Overview
• 4.2 Item Balance Updates Process Integration
  • 4.2.1 Item Balance Update Orchestration
• 4.3 Solution Assumptions and Constraints
• 4.4 Agile PLM Interfaces
• 4.5 JD Edwards EnterpriseOne Interfaces
• 4.6 Core AIA Components
  • 4.6.1 Agile PLM and JD Edwards EnterpriseOne Components for Update Item Balance
• 4.7 Integration Services
  • 4.7.1 ItemBalanceEBS
  • 4.7.2 UpdateItemBalanceListJDEE1ReqABCSImpl
  • 4.7.3 UpdateItemBalanceListAgileProvABCSImpl

5 Process Integration for Product Design Changes

• 5.1 Overview
• 5.2 Process Flow for Product Design Changes
  • 5.2.1 Creating ECO Flow
    • 5.2.1.1 Monitoring ECO Processes
  • 5.2.2 Orchestrating ECO Flow
• 5.3 Solution Assumptions and Constraints
• 5.4 Agile PLM Interfaces
• 5.5 JD Edwards EnterpriseOne Interfaces
• 5.6 Core AIA Components
  • 5.6.1 Agile PLM and JD Edwards EnterpriseOne Components for Creating ECO
• 5.7 Integration Services
  • 5.7.1 EngineeringChangeOrderEBS
  • 5.7.2 ProcessEngineeringChangeOrderAgileReqABCSImpl
  • 5.7.3 CreateEngineeringChangeOrderListJDEE1ProvABCSImpl

6 Process Integration Flow for ECO Implementation

• 6.1 Overview
• 6.2 ECO Implementation Process Integration
  • 6.2.1 Updating ECO Flow
  • 6.2.2 Changing Status Operation
  • 6.2.3 Updating ECO Orchestration
• 6.3 Solution Assumptions and Constraints
• 6.4 Agile PLM Interfaces
• 6.5 JD Edwards EnterpriseOne Interfaces
• 6.6 Core AIA Components
• 6.7 Agile PLM and JD Edwards EnterpriseOne Components for Update ECO
• 6.8 Integration Services
  • 6.8.1 EngineeringChangeOrderEBS
  • 6.8.2 UpdateEngineeringChangeOrderListJDEE1ReqABCSImpl
  • 6.8.3 UpdateEngineeringChangeOrderListAgileProvABCSImpl

Part II Implementing the Delivered Integrations

7 Configuring Design to Release: Agile PLM - JDE E1

• 7.1 Prerequisites
  • 7.1.1 Prerequisites for Initial Load of Items and BOM
  • 7.1.2 Prerequisites for Product Design Changes
  • 7.1.3 Prerequisites for ECO Implementation
  • 7.1.4 Prerequisites for Item Attributes and Cost Updates
  • 7.1.5 Prerequisites for Item Balance Updates
• 7.2 Setting Up Participating Applications
  • 7.2.1 Setting Up Agile Content Services
    • 7.2.1.1 Create New Destinations
    • 7.2.1.2 Create New Events for ECO and SCO
    • 7.2.1.3 Define Filters
    • 7.2.1.4 Create New Subscribers for ECO and SCO
    • 7.2.1.5 Set ECO and SCO Privileges
    • 7.2.1.6 Set up Agile Item Quantity Attributes
    • 7.2.1.7 Create a New Workflow for Initial Load Change Orders
    • 7.2.1.8 Set ECO Workflow Privileges
    • 7.2.1.9 Setup Change_Status Table for Workflow
    • 7.2.1.10 Set Up Agile Notifications
  • 7.2.2 Setting Up JD Edwards EnterpriseOne
    • 7.2.2.1 Setting Up Batch Programs
    • 7.2.2.2 Setting Up UDCs
    • 7.2.2.3 Setting Up JD Edwards EnterpriseOne Web Services
    • 7.2.2.4 Setting Up BSSVs
    • 7.2.2.5 Configuration Parameters for Creating ECO Flow
  • 7.2.3 Setting Up OWSM
    • 7.2.3.1 Creating Credential Maps and Credential Keys
  • 7.2.4 Setting Up AIA
• 7.3 Setting Up Batch Processing Information
  • 7.3.1 Setting Up FTP Adapter Information
  • 7.3.2 Setting Up Batch Consumer Properties
  • 7.3.3 Setting Up Resequencer for Batch Processing
  • 7.3.4 Adjusting Timeout Settings
    • 7.3.4.1 Setting SyncMaxWaitTime Value
    • 7.3.4.2 Setting Transaction Timeout Values
• 7.4 SQL Script for Loading Cross-Reference Records
• 7.5 Identifying Cross-References
• 7.6 Populating Cross-References
• 7.7 Describing DVMs
• 7.8 Viewing EIMs
• 7.9 Setting Configuration Properties
• 7.10 Handling Errors
  • 7.10.1 Resequencing and Error Handling
    • 7.10.1.1 Logic Used to Determine Notification Roles for an Error
  • 7.10.2 Error Handling in PIP Queue Manager
    • 7.10.2.1 Mechanism for Error Handling and Reporting
• 7.11 Viewing EIMs

A Queue Management

• A.1 Queue Management Solution
  • A.1.1 Queue Controller
  • A.1.2 Queue Schema
  • A.1.3 Queue Monitor
• A.2 User Interface
  • A.2.1 Accessing the Process Queue Monitor
  • A.2.2 Fields and Attributes
    • A.2.2.1 Change Order Queue Monitor
    • A.2.2.2 Queue Operators
  • A.2.3 Filters
    • A.2.3.1 Filter 1: All Change Orders
    • A.2.3.2 Filter 2: Errored Change Orders Only
    • A.2.3.3 Filter 3: Pending Changes Only
    • A.2.3.4 Filter 4: Completed Change Orders Only
    • A.2.3.5 Filter 5: Changes Errored Within Last Week
    • A.2.3.6 Filter 6: Unprocessed Change Orders
    • A.2.3.7 Filter 7: All Delete Flags
    • A.2.3.8 Advance Query Abilities
• A.3 Queue Manager Services
  • A.3.1 Transformations
  • A.3.2 Implementation Details
  • A.3.3 Error Management

B Mapping Page 2 and Page 3 Attributes

• B.1 Inserting Code to Map Page 2 and Page 3 Attributes

C Troubleshooting

• C.1 Resolving Common Issues