Skip Headers
Oracle® Application Integration Architecture Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release Implementation Guide
Release 11.2
Part Number E36185-05
Home
Book List
Contact Us
Next
PDF
·
Mobi
·
ePub
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