Contents

List of Examples

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
• Master Notes
• Additional Resources

Part I Understanding the Delivered Process Integrations

1 Agile Product Lifecycle Management Integration for Oracle E-Business Suite

• 1.1 Overview
  • 1.1.1 Functionalities
• 1.2 Solution Design Assumptions and Constraints
• 1.3 Architecture of Agile PLM Integration
• 1.4 Agile PLM to Oracle E-Business Suite Process Flows
  • 1.4.1 Process Integration for New Part Request
  • 1.4.2 Process Integration for Item Synchronization
  • 1.4.3 Process Integration for Change Order Validation
  • 1.4.4 Process Integration for Change Order Release
• 1.5 Oracle E-Business Suite to Agile PLM Process Flows
  • 1.5.1 Process Integration for Item Attribute Update
  • 1.5.2 Process Integration for Item Balance Update
  • 1.5.3 Process Integration for Change Order Update
• 1.6 Components of Agile PLM Integration Pack for Oracle E-Business Suite Integration
  • 1.6.1 ACS
  • 1.6.2 SDK
  • 1.6.3 Oracle Application Integration Architecture Foundation Pack
  • 1.6.4 Oracle E-Business Suite
    • 1.6.4.1 Oracle Integration Repository
    • 1.6.4.2 Business Event System
    • 1.6.4.3 Concurrent Programs/Manager
    • 1.6.4.4 Oracle Generic Configurator User Interface

2 Process Integration for Item Attribute Update

• 2.1 Overview
• 2.2 Item Attribute Update Process Integration
  • 2.2.1 Exceptions
  • 2.2.2 Item Attribute Update Integration Services Orchestration
• 2.3 Solution Assumptions and Constraints
• 2.4 Agile PLM Interfaces
• 2.5 Oracle E-Business Suite Interfaces
• 2.6 Core AIA Components
  • 2.6.1 Oracle E-Business Suite and Agile PLM Components
• 2.7 Integration Services
  • 2.7.1 ItemEBSV2
  • 2.7.2 UpdateItemListEbizReqABCSImpl
  • 2.7.3 UpdateItemListAgileProvABCSImpl

3 Process Integration for Item Balance Update

• 3.1 Overview
• 3.2 Item Balance Update Process Integration
  • 3.2.1 Exceptions
  • 3.2.2 Item Balance Update Integration Services Orchestration
• 3.3 Solution Assumptions and Constraints
• 3.4 Agile PLM Interfaces
• 3.5 Oracle E-Business Suite Interfaces
• 3.6 Core AIA Components
  • 3.6.1 Oracle E-Business Suite and Agile PLM Components for Item Balance Update
• 3.7 Integration Service
  • 3.7.1 ItemBalanceEBS
  • 3.7.2 UpdateItemBalanceListEbizReqABCSImpl
  • 3.7.3 UpdateItemBalanceListAgileProvABCSImpl

4 Process Integration for New Part Request

• 4.1 Overview
• 4.2 NPR Process Integration
  • 4.2.1 Exceptions
  • 4.2.2 NPR Integration Services Orchestration
• 4.3 Solution Assumptions and Constraints
• 4.4 Agile PLM Interfaces
• 4.5 Oracle E-Business Suite Interfaces
• 4.6 Core AIA Components
  • 4.6.1 Agile PLM and Oracle E-Business Suite Components
• 4.7 Integration Services
  • 4.7.1 ItemEBSV2
  • 4.7.2 SyncItemListAgileReqABCSImpl
  • 4.7.3 SyncItemListEbizProvABCSImpl

5 Process Integration for Item Synchronization

• 5.1 Overview
• 5.2 Item Synchronization Process Integration
  • 5.2.1 Exceptions
  • 5.2.2 Item Synchronization Integration Services Orchestration
• 5.3 Solution Assumptions and Constraints
• 5.4 Agile PLM Interfaces
• 5.5 Oracle E-Business Suite Interfaces
• 5.6 Core AIA Components
  • 5.6.1 Agile PLM and Oracle E-Business Suite Components for Item Synchronization
• 5.7 Integration Services
  • 5.7.1 ItemEBSV2
  • 5.7.2 SyncItemListAgileReqABCSImpl
  • 5.7.3 SyncItemListEbizProvABCSImpl

6 Process Integration for Change Order Validation

• 6.1 Overview
• 6.2 Change Order Validation Process Integration
  • 6.2.1 Exceptions
  • 6.2.2 Change Order Validation Integration Services Orchestration
• 6.3 Solution Assumptions and Constraints
• 6.4 Agile PLM Interfaces
• 6.5 Oracle E-Business Suite Interfaces
• 6.6 Core AIA Components
  • 6.6.1 Agile PLM and Oracle E-Business Suite Components for Change Order Validation
• 6.7 Integration Services
  • 6.7.1 EngineeringChangeOrderEBS
  • 6.7.2 ValidateEngineeringChangeOrderListAgileReqABCSImpl
  • 6.7.3 ValidateEngineeringChangeOrderListEbizProvABCSImpl

7 Process Integration for Change Order Release

• 7.1 Overview
• 7.2 Change Order Release Process Integration
  • 7.2.1 Releasing a Change Order in Agile PLM
  • 7.2.2 Generating an aXML by ACS
  • 7.2.3 Parsing and Transformation of aXML Data
  • 7.2.4 Posting Change Order Data to Oracle E-Business Suite
  • 7.2.5 Communicating Change Order Implementation Status to Agile PLM
  • 7.2.6 Exceptions
  • 7.2.7 Change Order Release Integration Services Orchestration
• 7.3 Solution Assumptions and Constraints
  • 7.3.1 Using Inactive or Obsolete Lifecycle Status
• 7.4 Agile PLM Interfaces
• 7.5 Oracle E-Business Suite Interfaces
• 7.6 Core AIA Components
  • 7.6.1 Agile PLM and Oracle E-Business Suite Components for Change Order Release
• 7.7 Integration Services
  • 7.7.1 EngineeringChangeOrderEBS
  • 7.7.2 ProcessEngineeringChangeOrderAgileReqABCSImpl
  • 7.7.3 CreateEngineeringChangeOrderListEbizProvABCSImpl

8 Process Integration for Change Order Update

• 8.1 Overview
• 8.2 Change Order Update Process Integration
  • 8.2.1 Change Order Update Process Inputs
  • 8.2.2 Change Order Update Processing
  • 8.2.3 Change Order Update Sample Use Case
  • 8.2.4 Exceptions
  • 8.2.5 Change Order Update Integration Services Orchestration
• 8.3 Solution Assumptions and Constraints
• 8.4 Agile PLM Interfaces
• 8.5 Oracle E-Business Suite Interfaces
• 8.6 Core AIA Components
  • 8.6.1 Oracle E-Business Suite and Agile PLM Components for Change Order Update
• 8.7 Integration Services
  • 8.7.1 EngineeringChangeOrderEBS
  • 8.7.2 UpdateEngineeringChangeOrderListEbizReqABCSImpl
  • 8.7.3 UpdateEngineeringChangeOrderListAgileProvABCSImpl

9 Process Integration for Variant Management

• 9.1 Overview
• 9.2 Variant Management Process Integration
  • 9.2.1 Exceptions
  • 9.2.2 Variant Management Integration Services Orchestration
• 9.3 Solution Assumptions and Constraints
• 9.4 Agile PLM Interfaces
• 9.5 Oracle E-Business Suite Interfaces
• 9.6 Core AIA Components
  • 9.6.1 Oracle E-Business Suite and Agile PLM Components for Change Order Update
• 9.7 Integration Services
  • 9.7.1 ConfiguratorURLEBS
  • 9.7.2 BillOfMaterialsConfigurationEBS
  • 9.7.3 GetConfiguratorURLAgileReqABCSImpl
  • 9.7.4 GetConfiguratorURLEbizProvABCSImpl
  • 9.7.5 SyncBillOfMaterialsConfigurationListEbizReqABCSImpl
    • 9.7.5.1 Message Resubmission Utility
      • 9.7.5.1.1 How to Use Message Resubmission Utility
  • 9.7.6 SyncBillOfMaterialsConfigurationListAgileProvABCSImpl

10 Process Integration for Initial Load of Items

• 10.1 Overview
• 10.2 Solution Assumptions and Constraints
• 10.3 Integration Flow for Initial Load of Items
  • 10.3.1 Extracting Item Data Using PL/SQL Script
    • 10.3.1.1 GENERATE_EVENTS
    • 10.3.1.2 PURGE_ EVENTLOG
• 10.4 Understanding the Item Batch Load Extract Process
• 10.5 Understanding the Item Batch Load Process
  • 10.5.1 File Management for Initial Item Batch Loading
• 10.6 Oracle E-Business Suite Interfaces
• 10.7 Agile Product Lifecycle Management (PLM) Interfaces
• 10.8 Integration Services
  • 10.8.1 ProcessEbizItemBatchLoadEventConsumer
    • 10.8.1.1 Web Services Definition Language (WSDL) Files
    • 10.8.1.2 Schema Definition (XSD) Files
  • 10.8.2 ProcessItemListInitialLoadEbizABF
    • 10.8.2.1 Web Services Definition Language (WSDL) Files
    • 10.8.2.2 Schema Definition (XSD) Files
    • 10.8.2.3 Transformations
    • 10.8.2.4 AIA Service Configuration Properties
  • 10.8.3 ProcessItemListIntitalLoadAgileABF
    • 10.8.3.1 Web Services Definition Language (WSDL) Files
    • 10.8.3.2 Schema Definition (XSD) Files
    • 10.8.3.3 Transformations
    • 10.8.3.4 AIA Service Configuration Properties

Part II Implementing the Delivered Process Integrations

11 Configuring Process Integration for Agile PLM Oracle E-Business Suite

• 11.1 Setting Up the Participating Applications
  • 11.1.1 Setting Up Agile PLM
    • 11.1.1.1 Create New Destinations
    • 11.1.1.2 Create New Events for ECO, MCO, and SCO
    • 11.1.1.3 Define Filters
    • 11.1.1.4 Create New Subscribers for ECO, MCO, and SCO
    • 11.1.1.5 Set Privileges
    • 11.1.1.6 Create New Read Privileges for MCO
    • 11.1.1.7 Set Up Agile Item Quantity Attributes
    • 11.1.1.8 Create Auto Number Process Extensions for NPR
    • 11.1.1.9 Create Action Menu Based Process Extensions for NPR
    • 11.1.1.10 Create Action Menu Based Process Extensions for Sync Item
    • 11.1.1.11 Add a Value to Change Category List
    • 11.1.1.12 Set up Change_Status Table for Workflow
    • 11.1.1.13 Set Up Agile Notifications
    • 11.1.1.14 Variant Management: Enable Notification
    • 11.1.1.15 Modify the Read Item Privilege:
    • 11.1.1.16 Create New Privilege for Modify:
    • 11.1.1.17 Update Read Users Privilege
    • 11.1.1.18 Update or Modify Users Privilege
    • 11.1.1.19 Create New Role for VM
    • 11.1.1.20 Modify the Newly Created VM Role
  • 11.1.2 Setting Up Oracle E-Business Suite
    • 11.1.2.1 Profile Settings
    • 11.1.2.2 Oracle Configurator Setup
    • 11.1.2.3 Secured Access to APPS Schema
    • 11.1.2.4 Performance Considerations
  • 11.1.3 Concurrent Programs Setup and Scheduling
  • 11.1.4 Setting Up Product Information Management Spoke Source System
  • 11.1.5 SQL Script for Loading Cross-Reference Records
• 11.2 Identifying Cross-Reference Data
  • 11.2.1 Creating Cross-Reference Data from Other Integrations
• 11.3 Populating Cross-References
• 11.4 Describing DVMs
• 11.5 Setting Configuration Properties
  • 11.5.1 Configuration Parameters
  • 11.5.2 Agile PLM Configurations
    • 11.5.2.1 Provider ABCS
    • 11.5.2.2 Requester ABCS
  • 11.5.3 Oracle E-Business Suite Configurations
    • 11.5.3.1 Provider ABCS
    • 11.5.3.2 Requester ABCS
    • 11.5.3.3 BPEL Service
• 11.6 Setting Up NLS
  • 11.6.1 Oracle E-business Suite Initiated Flows
  • 11.6.2 Agile PLM Initiated flows
  • 11.6.3 Setting Up NLS in Agile PLM
  • 11.6.4 Setting Up NLS in FMW for Agile PLM
  • 11.6.5 Setting Up NLS in FMW for Oracle E-Business Suite
  • 11.6.6 Setting Up DVMs for NLS
• 11.7 Handling Errors
  • 11.7.1 Error Handling in Pre-Built Integration Queue Manager
  • 11.7.2 Error Handling and Recovery Options in Initial Load of Items
    • 11.7.2.1 Overview
    • 11.7.2.2 Transaction Handling
    • 11.7.2.3 Recovery Options
• 11.8 Viewing EBO EIMs
• 11.9 Setting Up for Change Order Creation in Released Status in EBS

A Functionalities Available

B Queue Management

• B.1 Managing the Process Queues
  • B.1.1 Queuing
  • B.1.2 Change Order Process Flow
  • B.1.3 The Process Queue Manager
• B.2 User Interface
  • B.2.1 Accessing the Process Queue Monitor
  • B.2.2 Fields and Attributes
    • B.2.2.1 Change Order Queue Monitor
    • B.2.2.2 Queue Operators
  • B.2.3 Filters
    • B.2.3.1 Filter 1: All Change Orders
    • B.2.3.2 Filter 2: Errored Change Orders Only
    • B.2.3.3 Filter 3: Pending Changes Only
    • B.2.3.4 Filter 4: Completed Change Orders Only
    • B.2.3.5 Filter 5: Changes Errored Within Last Week
    • B.2.3.6 Filter 6: Unprocessed Change Orders
    • B.2.3.7 Filter 7: All Delete Flags
    • B.2.3.8 Advance Query Abilities
  • B.2.4 Queue User Interface Application
    • B.2.4.1 Easy Access EM Console Link to SOA Composite Instances for Change Orders
    • B.2.4.2 User Role-Based Access in Queue UI Application
    • B.2.4.3 Add New Users into User Roles in Queue UI Application
• B.3 Functions
• B.4 Queue Management Solution
  • B.4.1 Queue Schema
  • B.4.2 Queue Controller
  • B.4.3 Queue Monitor
• B.5 Queue Manager Services
  • B.5.1 CreateQueueService
  • B.5.2 CreateQueueControlService
  • B.5.3 QueueProcessorService
  • B.5.4 QueueProcessorServiceImpl
  • B.5.5 Transformations
  • B.5.6 Implementation Details
  • B.5.7 Error Management

C Troubleshooting

• C.1 Queue Issues
  • C.1.1 Oracle E-Business Suite Issues

D Security Policies Validation

E Managing Upgrade and Downgrade of Agile PLM Versions

• E.1 Switching Agile PLM Versions

F Frequently Asked Questions