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.7, RUP patch 17553612 or later, FP content patch 19010814. FP Patch 19267748 is applicable only for AIA Comms pre-built integrations.This chapter includes the following sections:
Comms Agent Assisted Billing Care: Siebel CRM - BRM Pre-Built Integration
Comms Order to Cash: Siebel CRM, OSM, and BRM Pre-Built Integration
Comms Order to Cash: Siebel CRM and BRM Pre-Built Integration
Comms Order to Cash: Siebel CRM and OSM Pre-Built Integration
Agile Product Lifecycle Management Integration Pack for Oracle E-Business Suite: Design to Release
Oracle Process Integration Pack for Oracle Utilities Field Work
The Comms Agent Assisted Billing Care: Siebel CRM - BRM Pre-Built Integration requires:
Siebel CRM 8.1.1.14 IP 2014 + Patch Set 1 or greater with repository content.
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.BRM 7.5 PATCH SET-10 [7.5.0.10.0] Patch 19678435 + IP19921037 + IP 20245747 or BRM 7.5 PATCH SET 11 [7.5.0.11.0]
ODI 11.1.1.7
BRM JCA Adapter version that matches your BRM installation version. For example, if you are using BRM 7.5 PS11, you must use the BRM 7.5 PS11 JCA Adapter.
If you are using BRM 7.5 PS10, change the JCA Resource Adapter transaction mode to LOCAL_TRANSACTION. By default, the transaction mode is set to XA_TRANSACTION. For information about changing the JCA Resource Adapter transaction mode, see the discussion of deploying and configuring JCA Resource Adapter in Oracle Communications Billing and Revenue Management JCA Resource Adapter.
If you are using BRM 7.5 PS11, you can leave the JCA Resource Adapter transaction mode in the default XA_TRANSACTION mode.
In addition to the above, the PDF invoice display feature requires:
Oracle Business Intelligence Publisher 11.1.1.9
Oracle WebCenter Content 11.1.1.7
The Comms Revenue Accounting: BRM - EBS Pre-Built Integration requires one of the following:
EBS 12.1.3
EBS 12.1.2
EBS 12.1.1 (additional seed data patch 8344349 required)
And this Pre-Built Integration requires:
BRM 7.5 PATCH SET-10 [7.5.0.10.0] Patch 19678435 + IP19921037 + IP 20245747.
ODI 11.1.1.6
The Comms Order to Cash: Siebel CRM, OSM, and BRM Pre-Built Integration requires:
Siebel CRM 8.1.1.14 IP 2014 + Patch Set 1 or greater with repository content.
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.BRM 7.5 PATCH SET-10 [7.5.0.10.0] Patch 19678435 + IP19921037 + IP 20245747 or BRM 7.5 PATCH SET 11 [7.5.0.11.0]
OSM 7.2.4.1.0 Patch 20175578
OSM O2A 2.0.1 Cartridge
BRM JCA Adapter version that matches your BRM installation version. For example, if you are using BRM 7.5 PS11, you must use the BRM 7.5 PS11 JCA Adapter.
If you are using BRM 7.5 PS10, change the JCA Resource Adapter transaction mode to LOCAL_TRANSACTION. By default, the transaction mode is set to XA_TRANSACTION. For information about changing the JCA Resource Adapter transaction mode, see the discussion of deploying and configuring JCA Resource Adapter in Oracle Communications Billing and Revenue Management JCA Resource Adapter.
If you are using BRM 7.5 PS11, you can leave the JCA Resource Adapter transaction mode in the default XA_TRANSACTION mode.
The Comms Order to Cash: Siebel CRM and BRM Pre-Built Integration requires:
Siebel CRM 8.1.1.14 IP 2014 + Patch Set 1 or greater with repository content.
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.BRM 7.5 PATCH SET-10 [7.5.0.10.0] Patch 19678435 + IP19921037 + IP 20245747 or BRM 7.5 PATCH SET 11 [7.5.0.11.0]
BRM JCA Adapter version that matches your BRM installation version. For example, if you are using BRM 7.5 PS11, you must use the BRM 7.5 PS11 JCA Adapter.
If you are using BRM 7.5 PS10, change the JCA Resource Adapter transaction mode to LOCAL_TRANSACTION. By default, the transaction mode is set to XA_TRANSACTION. For information about changing the JCA Resource Adapter transaction mode, see the discussion of deploying and configuring JCA Resource Adapter in Oracle Communications Billing and Revenue Management JCA Resource Adapter.
If you are using BRM 7.5 PS11, you can leave the JCA Resource Adapter transaction mode in the default XA_TRANSACTION mode.
The Comms Order to Cash: Siebel CRM and OSM Pre-Built Integration requires:
Siebel CRM 8.1.1.14 IP 2014 + Patch Set 1 or greater with repository content.
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.OSM 7.2.4.1.0 Patch 20175578
OSM O2A 2.1.0 Cartridge
The Customer MDM Base Pack requires:
Oracle Customer Hub (Siebel UCM) 8.1.1.x with ACR 437,ACR 475A, and ACR475B.
SOA patch 14104016
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.The Customer MDM: Siebel CRM 8.1.1.14 IP 2014 + Patch Set 1 or greater with repository content.
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.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-Business 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 |
The Customer MDM: Comms BRM requires BRM 7.4 MPS1 (PS 12754752) or BRM 7.5 PS3 with interim patch 16216254.
The Customer MDM Routing Rules requires:
Customer MDM Base Pack
Any of the available Customer MDM Option packs (optional)
The Customer MDM: Match Fetch Enterprise Composite Application requires:
Customer MDM Base Pack
Any of the available Customer MDM Option packs (optional)
The Product MDM Base Pack Pre-Built Integration requires Oracle Product Hub 12.1.3 or higher with the patches listed in Table 2-3.
Table 2-3 Oracle Product Hub 12.1.3 or Higher Patch
Product | My Oracle Support Patch Number | Description |
---|---|---|
Oracle Product Hub |
13848985:R12.EGO.C |
This patch provides rules enhancements (backport) for 12.1.3. |
Oracle Product Hub |
13775323:R12.EGO.C |
This Patch is for PIM Publication web services on 12.1.3. The services are created using ODI 11g and WLS tech-stack. Please refer to My Oracle Support note 888696.1 section ”Setting Up Oracle Data Integrator 11g Artifacts and web services for Oracle Product Hub” for configuring and deploying these services. Pre-requisite or Co-requisite which is not included with this patch: Patch can be applied only on top of release 12.1.3.Patch Applicable for versions/releases12.1.3 |
Oracle Product Hub |
16175038:R12.EGO.C |
This patch resolves the null pointer exception when publishing the ICC with its structure. |
Oracle Product Hub |
8481493:R12.BOM.C |
Patch for BOM AIA BPEL objects |
Oracle Product Hub |
12749057:R12.EGO.C |
After applying this patch, Item web service will publish in installed and base languages if a user does not provide any language information in the input payload. This patch can only be applied on top of Oracle E-Business Suite SCM Release 12.1.2. |
Oracle Product Hub |
14121048:R12.EGO.C |
After applying this patch, Transaction Attribute date modified at Item revision will be available to Item output payload. |
Oracle Product Hub |
13775323:R12.EGO.C(for ODI) |
12.1.3: PIM Publication WEBSERVICES with ODI 11g and WLS tech stack. This Patch is for PIM Publication web services on 12.1.3. The services are created using ODI 11g and WLS tech-stack. |
Oracle Product Hub |
18644686:R12.EGO.C |
This patch includes Telco Library changes |
Oracle Product Hub |
14851479:R12.EGO.C |
NA |
Oracle Product Hub |
19443866:R12.EGO.C |
This patch provides fix to enable MLS support for Transaction attributes ”Attribute Display Name” |
Oracle Product Hub |
18646886:R12.EGO.C |
After applying this patch Translated Valueset payload will contain all the language tags |
Oracle Product Hub |
18001366:R12.BOM.C |
After applying this patch Structure payload will have translatable Component UDA attribute values captured in appropriate tags |
The Product MDM: Design Studio integration requires Design Studio 7.2.4.0.2 Patch 19478660.
The Product MDM: Comms BRM requires:
BRM 7.5 PATCH SET-10 [7.5.0.10.0] Patch 19678435 + IP 19921037 + IP 20245747 or BRM 7.5 PATCH SET 11 [7.5.0.11.0]
PDC 11.1.0 + PDC PS6 Full Install or Upgrade Patch 19663783
BRM JCA Adapter version that matches your BRM installation version. For example, if you are using BRM 7.5 PS11, you must use the BRM 7.5 PS11 JCA Adapter.
If you are using BRM 7.5 PS10, change the JCA Resource Adapter transaction mode to LOCAL_TRANSACTION. By default, the transaction mode is set to XA_TRANSACTION. For information about changing the JCA Resource Adapter transaction mode, see the discussion of deploying and configuring JCA Resource Adapter in Oracle Communications Billing and Revenue Management JCA Resource Adapter.
If you are using BRM 7.5 PS11, you can leave the JCA Resource Adapter transaction mode in the default XA_TRANSACTION mode.
The Product MDM: Siebel CRM 8.1.1.14 IP 2014 + Patch Set 1 or greater with repository content.
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.The Product MDM Routing Rules requires:
Product MDM Base Pack
Any of the available Product MDM Option packs (optional)
The Design to Release: Agile - EBS / PIM Pre-Built Integration requires:
Agile Product Lifecycle Management release 9.3.3, 9.3.2, 9.3.1.2, 9.3.1.1 or 9.3.1.
If Agile is running on Oracle Application Server (OAS), apply the following patches depending on your version. These patches are not required if Agile is running on Weblogic Server (WLS):
Agile Product Lifecycle Management releases 9.3 with patch 10011995.
Agile Product Lifecycle Management releases 9.3.1 with patch 10276397.
If Agile is running on WLS, you must select Enable Global Trust between the weblogic domains: Agile and FMW.
For more information on configuring security for a WebLogic domain, see Oracle Fusion Middleware Securing Oracle WebLogic Server.
Note:
If you are using Agile 9.3.1 on Weblogic and if you are using an Oracle RAC database for the FMW server, the database driver in Agile must be a thin client driver, not an XA driver, which is the default when creating a new data source in Agile.Add the following patches for Variant Management (VM):
If you are using VM and Agile 9.3.1, then apply patch # 10288124.
If you are using VM and Agile 9.3.1.2 is running on WLS, then apply patch # 14458989.
If you are using VM and Agile 9.3.2, then apply patch # 16733804.
Note:
VM is not supported in Agile 9.3.0.2.For more information about deploying the Design to Release: Agile - EBS / PIM Pre-Built Integration extensions, see Deploying the Design to Release: Agile - EBS / PIM PIP Components on the Agile PLM Server.
One of the listed Oracle E-Business Suite: Discrete Manufacturing with the seed data patches:
EBS Release (R) 12 - 12.2.2 + 14769523:R12.INV.C + 17237771:R12.INV.C + 17189026:R12.ITM.D
In EBS R12.1.0 or later versions - To deploy GenerateItenNumberService successfully in Agile-Ebiz PIP, you must install Oracle E-Business Suite Integrated SOA Gateway. For more information, see My Oracle Support note 556540.1 on My Oracle Support.
In EBS R12.2.0 or later versions - To deploy GenerateItenNumberService successfully in Agile-Ebiz PIP, you must install Oracle E-Business Suite Integrated SOA Gateway. For more information, see My Oracle Support note 1311068.1 on My Oracle Support.
EBS R12 - 12.1.1 + 9335882:R12.INV.B, 9945332:R12.INV.B, 10172716:R12.INV.B, 10397048:R12.INV.B, 10632813:R12.OWF.B, 8640262:R12.INV.B, 8622332:R12.CZ.B (For Variant Management), 13893810:R12.INV.B, 8313714:R12.EGO.C, 18955663:R12.INV.B
EBS R12 - 12.1.2 + 8942177:R12.ITM.C, 8941665:R12.EGO.C, 8839091:R12.BOM.C, 9535244:R12.ENG.C, 9335882:R12.INV.B, 9548336:R12.ITM.C, 9945332:R12.INV.B, 10172716:R12.INV.B, 10397048:R12.INV.B, 10632813:R12.OWF.B, 13893810:R12.INV.B, 8313714:R12.EGO.C, 18955663:R12.INV.B
For 12.1.2 with PIM option, apply the following additional patches - 9070077:R12.OWF.B, 9453520:R12.OWF.B
EBS R12 - 12.1.3 +18955663:R12.INV.B,13370136:R12.INV.B, 10397048:R12.INV.B, 10172716:R12.INV.B, 9945332:R12.INV.B ,13893810:R12.INV.B and 14769523:R12.INV.B + 10632813:R12.OWF.B,10399014:R12.ITM.C, 11654417:R12.ITM.C, 14395360:R12.ITM.C, 13905125:R12.ITM.C
For 12.1.3 with VM, apply these additional patches 10009922:R12.CZ.B + 10009066:R12.FND.B.
Note:
After applying the patches, restart the EBS server.Database: 11.2.0.1.0 + Patch 9140891 and 9488247
The Agile PLM Integration Pack for SAP requires:
Agile Product Lifecycle Management release 9.3.2, 9.3.1.2, 9.3.1.1 or 9.3.1.
Agile Product Lifecycle Management release 9.3.1.1 and earlier require patch 12986698.
If Agile is running on Oracle Application Server (OAS), apply the following patches depending on your version. These patches are not required if Agile is running on Weblogic Server (WLS).
Agile Product Lifecycle Management releases 9.2.2.6 with patch 10276383.
Agile Product Lifecycle Management releases 9.2.2.7 with patch 10276386.
Agile Product Lifecycle Management releases 9.3 with patch 10011995.
Agile Product Lifecycle Management releases 9.3.1 with patch 10276397.
If Agile is running on WLS, you must select Enable Global Trust between the weblogic domains: Agile and FMW.
For more information on configuring security for a WebLogic domain, see Oracle Fusion Middleware Securing Oracle WebLogic Server.
Note:
If you are using Agile 9.3.1 on Weblogic and if you are using an Oracle RAC database for the FMW server, the database driver in Agile must be a thin client driver, not an XA driver, which is the default when creating a new data source in Agile.SAP- R/3 4.7 or ECC 6.0.
The Oracle Process Integration Pack for Oracle Utilities Field Work requires:
Oracle Utilities Customer Care and Billing 2.3.1 with Service Pack 1 (11675360), 2.2.0 with Service Pack 9 (patch 2610362), or 2.4.0.x
Oracle Utilities Work and Asset Management 1.9.1.x or 1.9.0.1 with patch 11729236
Oracle Utilities Mobile Workforce Management 2.2.0.x, 2.1.0.x, 2.0.1.3 with patch 11728648, or 1.5.0.11
Oracle Utilities Real Time Schedule r Planner 10.3.14 (required for MWM 1.5.0.11)
Oracle Utilities Resource Manager version 4.2.21 (required for MWM 1.5.0.11)
The Oracle Customer Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy requires:
Oracle Utilities Customer Care and Billing (OUCCB) version 2.4.0 or 2.3.1.
Patch 13403214 and prerequisites must be applied to the Oracle Utilities Customer Care and Billing application.
Note:
Patch 13403214 is included in Oracle Utilities Customer Care and Billing 2.3.1 Service Pack 4.Siebel CRM 8116 FP + ACR474 + ACR756 QF0610 (CC&B ACR)
SOA Patch for Bug 12895909 on PS4 - ADD NEW API CALLED "POPULATELOOKUPXREF"
The Oracle Product Data Synchronization Integration Pack for Oracle Utilities Customer Care and Billing and Siebel Energy requires:
Oracle Utilities Customer Care and Billing (OUCCB) version 2.4.0 or 2.3.1.
Patch 13403214 and prerequisites must be applied to the Oracle Utilities Customer Care and Billing application.
Note:
Patch 13403214 is included in Oracle Utilities Customer Care and Billing 2.3.1 Service Pack 4.Siebel CRM 8116 FP + ACR474 + ACR756 QF0610 (CC&B ACR)
The Design to Release: Agile PLM for Process - OPM PIP requires:
Agile Product Lifecycle Management for Process 6.0.0.3.0 with Hotfix 6.0.0.3.48.
Agile Product Lifecycle Management for Process Extensibility Pack 2.4.1.
Oracle E-Business Suite 12.1.2 with the following seed data patches:
9335882:R12.INV.B
9583654:R12.INV.B
9548336:R12.ITM.C
8942177:R12.ITM.C
9709508:R12.ITM.C
9563603:R12.GMD.B
9466716:R12.GMD.B
9701617:R12.GMD.B
9687801:R12.GMD.B
9713855:R12.GMD.B
The Order to Cash: Siebel CRM - EBS PIP requires:
Siebel SIA CRM version:
8.0.0.10 (FP patch 10016428) with ACR 508
8.0.0.11 (FP patch 11865300) with ACR 508
8.0.0.12 (FP Patch 12884885) with ACR 508
8.1.1.4 (FP patch 10428101) with ACR 474 or 508
8.1.1.5 (FP patch 12545956) with ACR 474 or 508
8.1.1.6 (FP patch 13078549) with ACR 474 or 508
Oracle E-Business Suite versions 11.5.10.2, 12.1.1, 12.1.2 , 12.1.3 or 12.2.1
Apply patch 16686747:R12.CSI.C only for Oracle E-Business Suite version 12.2.1. For more information on the seed data patch you must apply for Oracle E-Business Suite version 12.2.1, see Table 2-4.
Table 2-4 Seed Data Patches for Oracle E-Business Suite R12.2.1
Product | My Oracle Support Patch Number | Description |
---|---|---|
Oracle Installed Base (csi) |
16686747:R12.CSI.C |
QRE1222.2:CSI.INV.1:INVALID OBJECTS FOUND BY AUTOBUILD |
For more information on the seed data patches you must apply for each version of Oracle E-Business Suite, see Table 2-6 or Table 2-5.
Oracle Transportation Management 5.5 CU5.
This participating application is required if you plan to use the Shipping Charges integration flow that fetches shipping charges from Oracle Transportation Management.
Oracle Data Integrator 11.1.1.5 plus patch 12837214.
For more information on the patches you must apply to other versions of ODI, see Table 2-7.
Table 2-5 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-6 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-7 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. |
The Siebel CRM to OIC integration requires:
Siebel SIA CRM 7.8.2.x, 8.0.0.x or 8.1.1.x.
Oracle Data Integrator version 11.1.1.5 Java EE installation plus patch 12837214 or version 11.1.1.3.
For more information on the patches you must apply to ODI 11.1.1.3, see Table 2-8.
Oracle E-Business Suite R12.1.1, R12.1.2 or R12.1.3.
For more information on the seed data patches you must apply to each version of Oracle E-Business Suite, see Table 2-9 or Table 2-10.
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. |
Table 2-9 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 |
The Lead to Order: CRM OD - EBS PIP requires:
CRM On Demand release 16 or higher.
Oracle E-Business Suite R12.1.3 with seed data patch 9924161:R12.ONT.B, R12.1.2, R12.1.1 or R11.5.10.2.
For more information on the seed data patches you must apply to each version of Oracle E-Business Suite, see Table 2-11, Table 2-12 or Table 2-13.
Table 2-11 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-12 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-13 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 |
The LSP Financial Mgmt: OTM - EBS PIP requires:
Oracle E-Business Suite R12.1.2 or Oracle E-Business Suite R12.1.3
Oracle Transportation Management 6.1.1 or Oracle Transportation Management 6.2.
Table 2-14 describes the patches you must apply to Oracle SOA Suite 11.1.1.6
Table 2-14 Oracle SOA Suite 11.1.1.6
Product | My Oracle Support Patch Number | Description |
---|---|---|
Oracle SOA Suite 11.1.1.6 |
13704163 |
PATCH FOR 13704163 - soa ps5 11.1.1.6.1 (fusion applications b5.1) |
Oracle SOA Suite 11.1.1.6 |
13826266 |
JCA BINDING EXCEPTION WHILE INVOKING ADAPTER SERVICE FROM SOA 11G PS5 TEMPLATE |
Oracle SOA Suite 11.1.1.6 |
14104016 |
COMPOSITE INVOCATION FAILING WITH ERROR UNABLE TO FIND SERVICE |
Oracle SOA Suite 11.1.1.6 |
13866584 |
PS2,PS5:ORACLE.WEBSERVICES.STANDALONE.CLIENT.JAR:DUPLICATE ENTRIES:LICENSE.TXT |
Oracle SOA Suite 11.1.1.6 |
14200229 |
MISSING OPERATION NAME FAILS IN INVOCATION WITH NO FAILURE |
Oracle SOA Suite 11.1.1.6 |
14310998 |
BPEL EXCEPTION WHEN FP HAS BEEN UPGRADED TO PS5 (11.1.1.6) |
Table 2-15 describes the patches you must apply to Foundation Pack 11.1.1.6 (PS5).
Table 2-15 Foundation Pack 11.1.1.6 (PS5)
Product | My Oracle Support Patch Number | Description |
---|---|---|
Foundation Pack 11.1.1.6 (PS5) |
RUP(14253266) |
RUP ON TOP OF AIAFP 11.1.1.6.0 (Patch) |
Table 2-16 describes the patches you must apply to Oracle Transportation Management (OTM) 6.2
Table 2-16 Oracle Transportation Management (OTM) 6.2
Product | My Oracle Support Patch Number | Description |
---|---|---|
OTM 6.2 |
9492690 |
SU Patch [asgw]: SERVICE #CREATEDISPATCH FAILS WITH VALID PORT (Patch) This is a Weblogic patch to be applied on OTM 6.2 Environment running on Weblogic 10.3.3 release. |
Table 2-17 describes the patches you must apply to Oracle E-Business Suite R12.1.3.
Table 2-17 Oracle E-Business Suite R12.1.3
Product | My Oracle Support Patch Number | Description |
---|---|---|
Oracle E-Business Suite R12.1.3 |
16004835:R12.AR.B |
ACCOUNT RECEIVABLE FLOW IS GETTING FAILED WITH AIA FAULTS IN EM. |
Oracle E-Business Suite R12.1.3 |
13954258:R12.AR.B |
Autoinvoice child program errors out with no data found only when master program submited in parallel. |
The LSP Order Mgmt: OTM - EBS - Siebel CRM PIP requires:
Siebel CRM FP 8.0.0.8 QF# 2801 or Siebel SIA CRM 8.0.0.12 with ACR 508
Oracle E-Business Suite R12.1.2 or Oracle E-Business Suite R12.1.3
Oracle Transportation Management 6.1.1 or Oracle Transportation Management 6.2
Table 2-18 describes the patches you must apply to Oracle SOA Suite 11.1.1.6
Table 2-18 Oracle SOA Suite 11.1.1.6
Product | My Oracle Support Patch Number | Description |
---|---|---|
Oracle SOA Suite 11.1.1.6 |
13704163 |
PATCH FOR 13704163 - soa ps5 11.1.1.6.1 (fusion applications b5.1) |
Oracle SOA Suite 11.1.1.6 |
13826266 |
JCA BINDING EXCEPTION WHILE INVOKING ADAPTER SERVICE FROM SOA 11G PS5 TEMPLATE |
Oracle SOA Suite 11.1.1.6 |
14104016 |
COMPOSITE INVOCATION FAILING WITH ERROR UNABLE TO FIND SERVICE |
Oracle SOA Suite 11.1.1.6 |
13866584 |
PS2,PS5:ORACLE.WEBSERVICES.STANDALONE.CLIENT.JAR:DUPLICATE ENTRIES:LICENSE.TXT |
Oracle SOA Suite 11.1.1.6 |
14200229 |
MISSING OPERATION NAME FAILS IN INVOCATION WITH NO FAILURE |
Oracle SOA Suite 11.1.1.6 |
14310998 |
BPEL EXCEPTION WHEN FP HAS BEEN UPGRADED TO PS5 (11.1.1.6) |
Table 2-19 describes the patches you must apply to Foundation Pack 11.1.1.6 (PS5).
Table 2-19 Foundation Pack 11.1.1.6 (PS5)
Product | My Oracle Support Patch Number | Description |
---|---|---|
Foundation Pack 11.1.1.6 (PS5) |
RUP(14253266) |
RUP ON TOP OF AIAFP 11.1.1.6.0 (Patch) |
Table 2-20 describes the patches you must apply to Oracle Transportation Management (OTM) 6.2.
The LSP Driver Mgmt: OTM - EBS PIP requires
Oracle E-Business Suite R12.1.2 or Oracle E-Business Suite R12.1.3
Oracle Transportation Management 6.1.1 or Oracle Transportation Management 6.2
Table 2-21 describes the patches you must apply to Oracle Transportation Management 6.1.1.
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 |
Table 2-22 describes the patches you must apply to Oracle SOA Suite 11.1.1.6.
Table 2-22 Oracle SOA Suite 11.1.1.6
Product | My Oracle Support Patch Number | Description |
---|---|---|
Oracle SOA Suite 11.1.1.6 |
13704163 |
PATCH FOR 13704163 - soa ps5 11.1.1.6.1 (fusion applications b5.1) |
Oracle SOA Suite 11.1.1.6 |
13826266 |
JCA BINDING EXCEPTION WHILE INVOKING ADAPTER SERVICE FROM SOA 11G PS5 TEMPLATE |
Oracle SOA Suite 11.1.1.6 |
14104016 |
COMPOSITE INVOCATION FAILING WITH ERROR UNABLE TO FIND SERVICE |
Oracle SOA Suite 11.1.1.6 |
13866584 |
PS2,PS5:ORACLE.WEBSERVICES.STANDALONE.CLIENT.JAR:DUPLICATE ENTRIES:LICENSE.TXT |
Oracle SOA Suite 11.1.1.6 |
14200229 |
MISSING OPERATION NAME FAILS IN INVOCATION WITH NO FAILURE |
Oracle SOA Suite 11.1.1.6 |
14310998 |
BPEL EXCEPTION WHEN FP HAS BEEN UPGRADED TO PS5 (11.1.1.6) |
Table 2-23 describes the patches you must apply to Foundation Pack 11.1.1.6 (PS5).
Table 2-23 Foundation Pack 11.1.1.6 (PS5)
Product | My Oracle Support Patch Number | Description |
---|---|---|
Foundation Pack 11.1.1.6 (PS5) |
RUP(14253266) |
RUP ON TOP OF AIAFP 11.1.1.6.0 (Patch) |
Table 2-24 describes the patches you must apply to Oracle Transportation Management (OTM) 6.2.
Table 2-24 Oracle Transportation Management (OTM) 6.2
Product | My Oracle Support Patch Number | Description |
---|---|---|
OTM 6.2 |
9492690 |
SU Patch [asgw]: SERVICE #CREATEDISPATCH FAILS WITH VALID PORT (Patch) This is a Weblogic patch to be applied on OTM 6.2 Environment running on Weblogic 10.3.3 release. |
Table 2-25 describes the patches you must apply to Oracle E-Business Suite R12.1.3.
The VCP Integration Base Pack requires:
Oracle Data Integrator 11.1.1.5.0
Oracle Value Chain Planning Suite Release 12.1.3.x
Oracle Demantra 7.3.0.1
ESU for SAR number 8925532 applied to JD Edwards EnterpriseOne 9.0 (for JDE users)
PeopleSoft 9.1.24 (for PeopleSoft users)
For more information, see the Oracle Data Integrator Implementation Guide.
The Project Portfolio Management: Primavera P6 - JDE E1 PIP requires:
Primavera P6 Project Management release 8.0.0
JD Edwards EnterpriseOne Tools release 8.98.3.0
JD Edwards EnterpriseOne Applications release 9.0
At a minimum, you must have these JD Edwards EnterpriseOne modules:
System Foundation
Financial Management
Project Costing
To synchronize equipment data when using this PIP, you must also have one or more of these JD Edwards EnterpriseOne modules:
Capital Asset Management
Service Management
Customer Relationship Management (CRM) Foundation
Case Management
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 searching onhttps://edelivery.oracle.com
for the following part numbers:
V22722-01
This part number contains JD Edwards EnterpriseOne Tools 8.98.3.0 patch, which is required for the Project Portfolio Management Integration Pack for Primavera P6 and JDE E1.
V22751-01
This part number contains the Oracle Project Portfolio Management Integration Pack for Primavera P6 and JD Edwards EnterpriseOne patches for JD Edwards EnterpriseOne Applications 9.0. These patches are required, and should be installed in the following order:
JL11051
JL12014
JL14984
JL12809
JL15556
JL13277
The Serialization and Tracking: OPSM - EBS integration requires:
OPSM 1.1
Oracle E-Business Suite 12.1.2 or Oracle E-Business Suite 11.5.10.
For more information on the seed data patches you must apply to each version of Oracle E-Business Suite, see Table 2-26 or Table 2-27.
Oracle Data Integrator 11.1.1.3
For information on the patches you must apply to other versions of ODI, see Table 2-28.
Table 2-26 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-27 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-28 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. |