Skip Headers
Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations
Release 11.1
Part Number E23118-04
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Feedback page
Contact Us
Go to previous page
Previous		 Go to next page
Next
PDF · Mobi · ePub

2 Software Requirements

This chapter specifies the software requirements for all the integrations included in the Oracle Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations. To make sure you meet the requirements before installation, see your integration-specific section in this chapter.

Note:

Install AIA Foundation Pack before you install the integrations. Search for Oracle Fusion Middleware Installation and Upgrade Guide for Oracle Application Integration Architecture Foundation Pack in My Oracle Support, download and install Foundation Pack 11.1.1.5.0, RUP patch 12636915 or later. This guide is constantly updated and bug fixed.

Note:

While this chapter lists a specific fix pack (FP) or patch set (PS) for a given supported participating application version, it is recommended that when you are ready to implement a pre-built integration you get the latest FP or PS for the respective applicable participating application version as specified in the AIA Certification Matrix (http://www.oracle.com/technetwork/middleware/ias/downloads/fusion-certification-100350.html).

Example A:

Example B:

This chapter includes the following sections:

2.1 Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration

The Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration requires:

2.2 Comms Revenue Accounting: BRM - EBS Pre-Built Integration

The Comms Revenue Accounting: BRM - EBS Pre-Built Integration requires either:

And this Pre-Built Integration requires:

2.3 Comms Order to Cash: SBL CRM, OSM, and BRM Pre-Built Integration

The Comms Order to Cash: SBL CRM, OSM, and BRM Pre-Built Integration requires:

2.4 Comms Order to Cash: SBL CRM and BRM Pre-Built Integration

The Comms Order to Cash: SBL CRM and BRM Pre-Built Integration requires:

2.5 Comms Order to Cash: SBL CRM and OSM Pre-Built Integration

The Comms Order to Cash: SBL CRM and OSM Pre-Built Integration requires:

2.6 Customer MDM Base Pack

The Customer MDM Base Pack requires Oracle Customer Hub (Siebel UCM) 8.1.1.x with ACR 437,ACR 475A, and ACR 475B.

Note:

See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.

2.7 Customer MDM: Siebel CRM

The Customer MDM: Siebel CRM requires Siebel CRM 8.1.1.x with ACR 474 or 8.0.0.x with ACR 437.

Note:

See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP or 8.0.0.x FP required for this release.

2.8 Customer MDM: EBS

The Customer MDM: EBS requires either Oracle E-Business Suite, version 12.1.1 or higher or Oracle E-Business Suite, version 11.5.10.CU2.

For more information on the patches you must apply for each version of Oracle E-Business Suite, see Table 2-1 or Table 2-2.

Table 2-1 Oracle E-Business Suite 12.1.1 Seed Data Patch

Product My Oracle Support Patch Number Description

TCA

8253604:R12.HZ.B

AIA: HZ_AIA_CUSTOM_PKG RAISES UNHANDLED EXP DUE TO QUERY MISSING ORG STRIPE

Note:

The patch listed in Table 2-1 is required for EBS version 12.1.1. Higher versions do not require patches.

Table 2-2 Oracle E-Busines Suite 11.5.10.CU2 Seed Data Patches

Product My Oracle Support Patch Number Description

Customer

3618299

Patch 11i.HZ.N

Customer

4280097

HZ.N ONEOFF: CHANGES TO DSS TO ADD RESTRICTION OPTION FOR PARTY MERGE ON SUBMISSION

Customer

5046954

BACKPORT INTEGRATION SERVICES TO 11i

Customer

6434556

HZ.N ONEOFF: ORDER 2 CASH PHASE 2 CDH CHANGES

Trading Community

7171816

BO API: GET_ORG_CUSTS_UPDATED RETURNS PL/SQL NUMERIC OR VALUE ERROR

Trading Community

7209179

TCA API ENHANCEMENT NEEDED FOR AIA MDM PROJECT (PERSON)

Trading Community

7510070

AIA MDM: SQL FILE TO CREATE SUSBCRIBERS TO PERSON CUSTBO EVENTS

2.9 Customer MDM: Comms BRM

The Customer MDM: Comms BRM requires BRM 7.4 PS10 (PS patch 12560436).

2.10 Customer MDM Routing Rules

The Customer MDM Routing Rules requires:

2.11 Customer MDM: Match Fetch Enterprise Composite Application

The Customer MDM: Match Fetch Enterprise Composite Application requires:

2.12 Product MDM: EBS

The Product MDM: EBS requires either Oracle E-Business Suite 11.5.10.2 or Oracle E-Business Suite 12.1.1.

For more information on the patches you must apply for each version of Oracle E-Business Suite, see Table 2-3 and Table 2-4.

Table 2-3 Oracle E-Business Suite 11.5.10.2 Seed Data Patches

Product My Oracle Support Patch Number Description

PLM

7563732

EBI: 11i EBIZ patch to support Agile PLM Integration Pack 2.5 for Oracle E-Business Suite: Design to Release

PLM

7450177

PATCH FOR BOM AIA BPEL OBJECTS

Table 2-4 Oracle E-Business Suite 12.1.1 Seed Data Patches

Product My Oracle Support Patch Number Description

PLM

8481493:R12.BOM.C

PATCH FOR BOM AIA BPEL OBJECTS

2.13 Product MDM Base Pack

The Product MDM Base Pack Pre-Built Integration requires Oracle Product Hub 12.1.3 or higher with the patch listed in Table 2-5.

Table 2-5 Oracle Product Hub 12.1.3 or Higher Patch

Product My Oracle Support Patch Number Description

Oracle Product Hub

10433145:R12.EGO.C

Post GA enhancements for AIA Product MDM 3.1

2.14 Product MDM: Comms BRM

The Product MDM: Comms BRM requires BRM 7.4 PS10 (PS patch 12560436).

2.15 Product MDM: Siebel CRM

The Product MDM: Siebel CRM requires Siebel CRM 8.1.1.x with ACR 474.

Note:

See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.

2.16 Product MDM Routing Rules

The Product MDM Routing Rules requires:

2.17 Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release

The Design to Release: Agile - EBS / PIM Pre-Built Integration requires:

2.18 Oracle Design to Release Integration Pack for Agile PLM and JD Edwards EnterpriseOne

The Design to Release: Agile PLM - JDE E1 Pre-Built Integration requires:

2.19 Agile Product Lifecycle Management Integration Pack for SAP

The Agile PLM Integration Pack for SAP requires:

2.20 Design to Release: Agile PLM for Process - OPM PIP

The Design to Release: Agile PLM for Process - OPM PIP requires:

2.21 Order to Cash: Siebel CRM - EBS PIP

The Order to Cash: Siebel CRM - EBS PIP requires:

Table 2-6 Seed Data Patches for Oracle E-Business Suite R12.1.1 or 12.1.2 or 12.1.3

Product My Oracle Support Patch Number Description

Advanced Product Catalog

8313714:R12.EGO.C

FP - CREATE LOAD EVENT AND SCRIPTS TO GENERATE LOAD EVENT FOR EGO ITEM

TCA (Customer)

8253604:R12.HZ.B

AIA: HZ_AIA_CUSTOM_PKG RAISES UNHANDLED EXP DUE TO QUERY MISSING ORG STRIPE

Install Base/ALM/Asset

7156553:R12.CSI.B

FP11.5.10-12.1 O2C2: EVENT GETTING RAISED FOR NON-CUSTOMER ITEM INSTANCE DURING

BOM (Bill of Materials)

8305535:R12.BOM.C

BUSINESS EVENT NOT RAISED WHILE CREATING CONFIGURATION ITEMS

Order Management

8459502:R12.ONT.B

A mandatory prerequisite. All customers should apply it before using Order to Cash: Siebel CRM - EBS PIP 2.4 on E-Business Suite release 12.1.

Order Management

9210633:R12.ONT.B

This is Oracle Order Management Roll-Up # 2 patch for AIA/O2C 2.5 PIP (on R12.1 code line)

Order Management

9924161:R12.ONT.B

oe_inbound_int.process_order should not "commit" if p_action_commit =false

Order Management

10171747:R12.ONT.B

Sales order lines being removed from ship set they were a part of, during UPDATE operation.

Order Management

10009062:R12.ONT.B

Outbound Event containing an incorrect value for order header level attribute: "orig_sys_document_ref" on sales order cancellation.

Shipping Execution

8590113:R12.WSH.B

Shipping api to provide all delivery detail attribute values for a sales order or a sales order line.

Trading Community

8745333:R12.HZ.B

CONTACT UPDATE USING HZ_AIA_CUSTOM_PKG.SYNC_ACCT_ORDER DOESN'T WORK W/O ADDRESS

Table 2-7 Seed Data Patches for Oracle E-Business Suite 11.5.10.2

Product My Oracle Support Patch Number Description

ATP

4639052

11.5.10 ATP ROLLUP #7 PATCH

ATP

7170316

ATP PATCH TO SUPPORT ATP THROUGH BPEL PROCESS (O2C2)

Advanced Product Catalog

8263652

CREATE LOAD EVENT AND SCRIPTS TO GENERATE LOAD EVENT FOR EGO ITEM

BOM

7034701

Configuration items do not get synced to Siebel.

Application Install

6502082

AD.I.6

Configurator

6468610

Build 25.42

Customer

3618299

Patch 11i.HZ.N

Customer

4280097

HZ.N ONEOFF: CHANGES TO DSS TO ADD RESTRICTION OPTION FOR PARTY MERGE ON SUBMISSION

Customer

5046954

BACKPORT INTEGRATION SERVICES TO 11i

Customer

6434556

HZ.N ONEOFF: ORDER 2 CASH PHASE 2 CDH CHANGES

Install Base/ALM/Asset

7159524

O2C2 IB CONSOLIDATE PATCH

Install Base/ALM/Asset

7682665

CREATE ASSET EVENTS ARE NOT RAISED

Install Base/ALM/Asset

7699277

ATO ITEM INSTANCES - CREATE & UPDATE EVENTS ARE NEEDED FOR HIERARCHY CREATION

Install Base/ALM/Asset

7239642

EVENTS NOT RAISED FOR STATUS UPDATE OF CHILD COMPONENTS IN PTO MODEL

Install Base/ALM/Asset

7313962

ORIGINAL_COST IN THE VIEW CSI_ASSET_INTEGRATION_V IS DIFFERENT IF MANUAL OVERRID

Install Base/ALM/Asset

5310177

OKS 11.5.10 ROLLUP PATCH 4

Install Base/ALM/Asset

9436131

CSI: item instance party relationship>owner update fires create event and not update

Order Management

4665900

This is the OM Prerequisite Patch (OMPRP) for 11.5.10 customers. This includes multiple critical and recommended OM code fixes as of Oct 2005. This patch is highly recommended for all 11i10 Order Management customers.

Order Management

8526377

Order Management OM R11I10 RUP FOR Order to Cash: Siebel CRM - EBS PIP 2.5

Order Management

9242739

eBS/OM consolidation patch for O2C2.5 RUP #2

Order Management

10182986

This patch enhances the behavior of Oe_Inbound_Int.Process_Order(...) to issue a database commit, conditionally.

PaymentAuth

6846210

O2C2: 11I.10CU2 WRAPPER FOR APPS.IBY_PAYMENT_ADAPTER_PUB.ORAPMTREQ REQUESTED

Projects Suite (pj_pf)

3074777

FAMILY PACK 11i.PJ_PF.L

Product Workbench (dna)

4301876

DNA ADSPLICE CHECKIN

PLM

4203793

Patchset 11i.PLM_PF.E

PLM

7037537

11I.PLM_PF.E: CUMULATIVE ROLLUP PATCH E14

Price Lists

6831380

New View CRMINTEG_PRICELIST_V must be created for Order to Cash Phase II AIA Integration

Shipping Execution

8932422

Shipping API to provide the delivery detail attributes for order or line

Trading Community

7171816

BO API: GET_ORG_CUSTS_UPDATED RETURNS PL/SQL NUMERIC OR VALUE ERROR

Trading Community

8769578

FOR BACKPORTING FIX OF 8745333 TO 11I

Table 2-8 ODI Release 11.1.1.3 Patches

Product My Oracle Support Patch Number Description

Oracle Data Integrator

9814235

Oracle Data Integrator: Patch NOSUCHMETHODERROR DURING ODI_SERVER1 STARTUP

This patch is required for compatibility with Oracle SOA Suite 11g Release 1 (11.1.1.4) PS3.

Oracle Data Integrator

10172307

Oracle Data Integrator: Patch ODIINVOKEWEBSERVICE UNABLE TO INVOKE WEBSERVICES WITH USER AUTHENTICATION.

This patch helps ODI invoke secured web services using HTTP Basic Authentication.

2.22 Siebel CRM to OIC Integration

The Siebel CRM to OIC integration requires:

Table 2-9 ODI Release 11.1.1.3 Patches

Product My Oracle Support Patch Number Description

Oracle Data Integrator

9814235

Oracle Data Integrator: Patch NOSUCHMETHODERROR DURING ODI_SERVER1 STARTUP

This patch is required for compatibility with Oracle SOA Suite 11g Release 1 (11.1.1.4) PS3.

Oracle Data Integrator

10172307

Oracle Data Integrator: Patch ODIINVOKEWEBSERVICE UNABLE TO INVOKE WEBSERVICES WITH USER AUTHENTICATION.

This patch helps ODI invoke secured web services using HTTP Basic Authentication.

Table 2-10 Oracle E-Business Suite R12.1.1 Seed Data Patches

Product My Oracle Support Patch Number Description

Oracle E-Business Suite Integration

8611764:R12.HZ.B

EBI: 12.1.1 EBS PATCH TO SUPPORT SIEBEL OIC PIP 2.5

Oracle Incentive Compensation

8904003:R12.CN.B

12.1.1 OIC PATCH TO SUPPORT SIEBEL OIC PIP 2.5

Oracle Incentive Compensation

8918365:R12.CN.B

12.1.1 PATCH TO SUPPORT SIEBEL OIC PIP 2.5 - Drop 1

Oracle Resource Manager

8560891:R12.HZ.B

12.1.1: ORACLE RESOURCE MANAGER PATCH TO SUPPORT SIEBEL OIC PIP 2.5

Oracle Resource Manager

8915500:R12.HZ.B

JTF_RS_RESOURCE_UTL_PUB IS NOT RETURNED PROPER STATUS

Siebel CRM Integration to Oracle Incentive Compensation (sblcrmcn)

9010091

ONE-OFF PATCH FOR SIEBEL CRM INTEGRATION TO ORACLE INCENTIVE COMPENSATION 2.5

Table 2-11 Oracle E-Business Suite R12.1.2 and R12.1.3 Seed Data Patch

Product My Oracle Support Patch Number Description

Oracle E-Business Suite Integration

8611764:R12.HZ.B

EBI: 12.1.1 EBS PATCH TO SUPPORT SIEBEL OIC PIP 2.5

2.23 Lead to Order: CRM OD - EBS PIP

The Lead to Order: CRM OD - EBS PIP requires:

Table 2-12 Oracle E-Business Suite R12.1.2 Seed Data Patches

Product My Oracle Support Patch Number Description

Advanced Product Catalog

8313714:R12.EGO.C

Batch load product

Customers Online

7646994:R12.IMC.B

360 degree view page enhancements

Order Capture

8607620:R12.ASO.B

Provide Create Quote service to support OnDemand integration

Order Management

8516700:R12.ONT.B

OM R12.1 RUP for O2C 2.5

Order Management

9924161:R12.ONT.B

Commit conditionally

Receivables

8313700:R12.AR.B

Batch load customer

Table 2-13 Oracle E-Business Suite R12.1.1 Seed Data Patches

Product My Oracle Support Patch Number Description

Advanced Product Catalog

8313714:R12.EGO.C

Batch load product

Customers Online

7646994:R12.IMC.B

360 degree view page enhancements

Order Capture

8607620:R12.ASO.B

Provide Create Quote service to support OnDemand integration

Order Management

8516700:R12.ONT.B

OM R12.1 RUP for O2C 2.5

Order Management

8722776:R12.ONT.B

Resolves the issue of Quote detail generating an error in OIP when Bill To information is missing

Order Management

9924161:R12.ONT.B

Commit conditionally

Receivables

8313700:R12.AR.B

Batch load customer

TCA

8253604:R12.HZ.B

AIA: HZ_AIA_CUSTOM_PKG raises unhandled exp due to query missing org stripe

Trading Community

8745333:R12.HZ.B

R121 Ebis Environment Patch

Table 2-14 Oracle E-Business Suite R11.5.10.2 Seed Data Patches

Product My Oracle Support Patch Number Description

Advanced Product Catalog

10098682

11I.PLM_PF.E:CUMULATIVE ROLLUP PATCH E22

Advanced Product Catalog

8263652

Batch load product events

Customer

3618299

Patch 11i.HZ.N

Customer

4280097

HZ.N Oneoff: Changes to DSS to add restriction option for party merge on submission

Customer

5046954

Backport integration services to 11i

Customer

6434556

Hz.N Oneoff: Order 2 Cash Phase 2 CDH Changes

Customers Online

5398458

ER: Must view Quotes created for a contact in OCO Transaction Viewer

Customers Online

7624043

360 degree view page enhancements

Order Capture

4252536

11.5.10.3R: Oracle order capture rollup 3 on 11i.aso.m

Order Capture

8342295

Need ASO patch for IStore bug#7488829

Order Capture

8607610

BR11510: Create Quote service to support OnDemand Integration

Order Capture

10023764

ISTORE DOES NOT RESPECT SEGREGATED STOCK PER DEMAND CLASS

Order Management

4665900

This is the OM Prerequisite Patch (OMPRP) for 11.5.10 customers. This includes multiple critical and recommended OM code fixes as of Oct 2005. This patch is highly recommended for all 11i10 Order Management customers.

Order Management

5118218

July 2006, Order Management (11.5.10) cumulative patch

Order Management

8526377

OM R11I10 RUP for O2C 2.5

Order Management

10182986

Commit conditionally

Product Lifecycle Management

4203793

Patchset 11i.PLM_PF.E

Quoting

8296455

BR11510: DIEBOLD ER 7375446 (qualified price list)

Quoting

4692759

BR11510: INCREASE QUOTE_NAME COLUMN SIZE FROM VARCHAR2(80) TO VARCHAR2(240)

Quoting

9352233

UNABLE TO 'COPY ALL ROWS' FROM SEARCH RESULTS

Receivables

8263544

Batch load customer events

Trading Community

7171816

BO API: GET_ORG_CUSTS_UPDATED returns PL/SQL Numeric or Value Error

Trading Community

8769578

11510 Ebis Environment Patch

2.24 Financials Ops Control: Oracle Retail - PSFT PIP

The Financials Ops Control: Oracle Retail - PSFT PIP requires:

Table 2-15 describes the patches you must apply to ODI 11.1.1.3.

Table 2-15 ODI Release 11.1.1.3 Patches

Product My Oracle Support Patch Number Description

Oracle Data Integrator

9814235

Oracle Data Integrator: Patch NOSUCHMETHODERROR DURING ODI_SERVER1 STARTUP

This patch is required for compatibility with Oracle SOA Suite 11g Release 1 (11.1.1.4) PS3.

Oracle Data Integrator

10172307

Oracle Data Integrator: Patch ODIINVOKEWEBSERVICE UNABLE TO INVOKE WEBSERVICES WITH USER AUTHENTICATION.

This patch helps ODI invoke secured web services using HTTP Basic Authentication.

Note:

Ensure that the installation type for ODI includes an Agent folder (Standalone with agent)

2.25 LSP Financial Mgmt: OTM - EBS PIP

The LSP Financial Mgmt: OTM - EBS PIP requires:

2.26 LSP Order Mgmt: OTM - EBS - Siebel CRM PIP

The LSP Order Mgmt: OTM - EBS - Siebel CRM PIP requires:

2.27 LSP Driver Mgmt: OTM - EBS PIP

The LSP Driver Mgmt: OTM - EBS PIP requires

Table 2-16 describes the patches you must apply to Oracle Transportation Management 6.1.1.

Table 2-16 OTM 6.1.1 Patches

Bug Number ARU Description

9729851

12760753

end date field is ignored on driver integration, inbound/outbound

9681898

12601650

AGENT EVENT "WORK INVOICE - STATUS CHANGED" NOT TRIGGERED

9693785

12623553

JAVA NULL POINTER RECEIVED ON GENERATING 2ND WORK INVOICE WITH SPECIAL SERVICE

2.28 Value Chain Planning Integration Base Pack

The VCP Integration Base Pack requires:

For more information, see the Oracle Data Integrator Implementation Guide.

2.29 Project Portfolio Management: Primavera P6-EBS Projects PIP

The Project Portfolio Management: Primavera P6-EBS Projects PIP requires:

2.30 Project Portfolio Mgmt: Primavera P6 - JDE E1

The Project Portfolio Management: Primavera P6 - JDE E1 PIP requires:

At a minimum, you must have these JD Edwards EnterpriseOne modules:

To synchronize equipment data when using this PIP, you must also have one or more of these JD Edwards EnterpriseOne modules:

To synchronize material data when using this PIP, you must also have the JD Edwards EnterpriseOne Inventory Management module.

Additionally, you must also install electronic software updates (ESUs), which you can find by locating searching on these part numbers on https://edelivery.oracle.com/:

  1. JL11051

  2. JL12014

  3. JL14984

  4. JL12809

  5. JL15556

  6. JL13277

2.31 Serialization and Tracking: OPSM - EBS

The Serialization and Tracking: OPSM - EBS integration requires:

Table 2-17 Seed Data Patches for Oracle E-Business Suite 12.1.2

My Oracle Support Patch Number Description

10142201:R12.INV.B

OPSM integration objects

10306577:R12.GME.B

OPSM related OPM changes

Table 2-18 Seed Data Patches for Oracle E-Business Suite 11.5.10

My Oracle Support Patch Number Description

11662684

OPSM integration objects

10390291

OPSM related OPM changes

Table 2-19 ODI Release 11.1.1.3 Patches

Product My Oracle Support Patch Number Description

Oracle Data Integrator

9814235

Oracle Data Integrator: Patch NOSUCHMETHODERROR DURING ODI_SERVER1 STARTUP

This patch is required for compatibility with Oracle SOA Suite 11g Release 1 (11.1.1.4) PS3.

Oracle Data Integrator

10172307

Oracle Data Integrator: Patch ODIINVOKEWEBSERVICE UNABLE TO INVOKE WEBSERVICES WITH USER AUTHENTICATION.

This patch helps ODI invoke secured web services using HTTP Basic Authentication.

2.32 Utilities Field Work PIP

The Utilities Field Work PIP requires:

Go to previous page
Previous		 Go to next page
Next
Go to Documentation Home
Home		 Go to Book List
Book List		 Go to Table of Contents
Contents		 Go to Feedback page
Contact Us