Skip Headers
Oracle® Application Integration Architecture Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release Implementation Guide
Release 11.1
Part Number E22280-04
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
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 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.6
SyncBillOfMaterialsConfigurationListAgileProvABCSImpl
Part II Implementing the Delivered Process Integrations
10
Configuring Process Integration for Agile PLM Oracle E-Business Suite
10.1
Setting Up the Participating Applications
10.1.1
Setting Up Agile PLM
10.1.1.1
Create New Destinations
10.1.1.2
Create New Events for ECO, MCO, and SCO
10.1.1.3
Define Filters
10.1.1.4
Create New Subscribers for ECO, MCO, and SCO
10.1.1.5
Set Privileges
10.1.1.6
Create New Read Privileges for MCO
10.1.1.7
Set Up Agile Item Quantity Attributes
10.1.1.8
Create Auto Number Process Extensions for NPR
10.1.1.9
Create Action Menu Based Process Extensions for NPR
10.1.1.10
Create Action Menu Based Process Extensions for Sync Item
10.1.1.11
Set up Change_Status Table for Workflow
10.1.1.12
Set Up Agile Notifications
10.1.1.13
Variant Management: Enable Notification
10.1.1.14
Modify the Read Item Privilege:
10.1.1.15
Create New Privilege for Modify:
10.1.1.16
Update Read Users Privilege
10.1.1.17
Update or Modify Users Privilege
10.1.1.18
Create New Role for VM
10.1.1.19
Modify the Newly Created VM Role
10.1.2
Setting Up Oracle E-Business Suite
10.1.2.1
Profile Settings
10.1.2.2
Oracle Configurator Setup
10.1.2.3
Secured Access to APPS Schema
10.1.2.4
Performance Considerations
10.1.3
Concurrent Programs Setup and Scheduling
10.1.4
Setting Up Product Information Management Spoke Source System
10.1.5
SQL Script for Loading Cross-Reference Records
10.2
Identifying Cross-Reference Data
10.2.1
Creating Cross-Reference Data from Other Integrations
10.3
Populating Cross-References
10.4
Describing DVMs
10.5
Setting Configuration Properties
10.5.1
Configuration Parameters
10.5.2
Agile PLM Configurations
10.5.2.1
Provider ABCS
10.5.2.2
Requester ABCS
10.5.3
Oracle E-Business Suite Configurations
10.5.3.1
Provider ABCS
10.5.3.2
Requester ABCS
10.5.3.3
BPEL Service
10.6
Setting Up NLS
10.6.1
Requester Flows
10.6.2
Provider Flows
10.6.3
Setting Up NLS in Agile PLM
10.6.4
Setting Up NLS in FMW for Agile PLM
10.6.5
Setting Up NLS in FMW for Oracle E-Business Suite
10.6.6
Setting Up DVMs for NLS
10.7
Handling Errors
10.7.1
Error Handling in Pre-Built Integration Queue Manager
10.8
Viewing EBO EIMs
10.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.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