Oracle® Application Integration Architecture Installation and Upgrade Guide for Pre-Built Integrations Release 11.3 Part Number E28316-03 |
|
|
PDF · Mobi · ePub |
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.6, RUP patch 14253266 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:
The AIA Certification Matrix lists the supported version of Oracle BRM for the 11.3 Comms pre-built integrations as follows:
Oracle BRM 7.4 MPS1 (PS 12754752).
This chapter specifies the use of Oracle BRM 7.4 MPS1 (PS 12754752) because PS 12754752 is the latest available PS on BRM 7.4 for the 11.3 Comms Pre-Built Integrations release. It is recommended that you uptake the latest available BRM 7.4 PS when implementing the Comms pre-built integrations.
Example B:
The AIA Certification Matrix lists the supported version of Siebel CRM for the 11.3 Order To Cash Siebel CRM - EBS PIP as follows:
Siebel CRM SIA 8.1.1.x (where x is 4 or greater, with ACR 474 or 508).
This chapter specifies the use of Siebel CRM SIA 8.1.1.6 (with ACR 474 or 508) because 8.1.1.6 is the latest available Siebel FP at the time of the AIA 11.3 release. It is recommended that you uptake the latest available Siebel CRM SIA 8.1.1.x FP (with ACR 474 or 508) when implementing the Order To Cash Siebel CRM - EBS PIP.
This chapter includes the following sections:
Section 2.1, "Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration"
Section 2.2, "Comms Revenue Accounting: BRM - EBS Pre-Built Integration"
Section 2.3, "Comms Order to Cash: SBL CRM, OSM, and BRM Pre-Built Integration"
Section 2.4, "Comms Order to Cash: SBL CRM and BRM Pre-Built Integration"
Section 2.5, "Comms Order to Cash: SBL CRM and OSM Pre-Built Integration"
Section 2.11, "Customer MDM: Match Fetch Enterprise Composite Application"
Section 2.18, "Agile Product Lifecycle Management Integration Pack for SAP"
Section 2.19, "Oracle Process Integration Pack for Oracle Utilities Field Work"
Section 2.22, "Design to Release: Agile PLM for Process - OPM PIP"
Section 2.26, "Financials Ops Control: Oracle Retail - PSFT PIP"
Section 2.31, "Project Portfolio Mgmt: Primavera P6 - JDE E1"
The Comms Agent Assisted Billing Care: SBL CRM - BRM Pre-Built Integration requires:
Siebel CRM 8.1.1.x FP with ACR 474
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.
BRM 7.4 MPS1 (PS patch 12754752) or BRM 7.5
ODI 11.1.1.5 plus patch 12837214
The Comms Revenue Accounting: BRM - EBS Pre-Built Integration requires either:
EBS 12.1.3
EBS 12.1.1 or 12.1.2 (additional seed data patch 8344349 required for both versions)
EBS 11.5.10 (additional seed data patch 6012471)
And this Pre-Built Integration requires:
BRM 7.4 MPS1 (PS patch 12754752) or BRM 7.5
ODI 11.1.1.5 plus patch 12837214
The Comms Order to Cash: SBL CRM, OSM, and BRM Pre-Built Integration requires:
Siebel CRM 8.1.1.x FP with ACR 474
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.
BRM 7.4 MPS1 (PS patch 12754752) or BRM 7.5
OSM 7.0.3
The Comms Order to Cash: SBL CRM and BRM Pre-Built Integration 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.
BRM 7.4 MPS1 (PS patch 12754752) or BRM 7.5
The Comms Order to Cash: SBL CRM and OSM Pre-Built Integration requires:
Siebel CRM 8.1.1.x FP with ACR 474
Note:
See the AIA Certification Matrix for the minimum Siebel CRM 8.1.1.x FP required for this release.
OSM 7.0.3
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 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.
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.
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: 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.
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.
The Product MDM: Comms BRM requires BRM 7.4 MPS1 (PS 12754752) or BRM 7.5.
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.
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.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.0.1 with patch 10276392.
Agile Product Lifecycle Management releases 9.3.0.2 with patch 10276395.
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.0.0, apply patches # 9233009 and # 10288124.
If you are using VM and Agile 9.3.0.1, apply patches # 9305555 and # 10288124.
If you are using VM and Agile 9.3.1, apply patch # 10288124.
If you are using VM and Agile 9.3.1.2 is running on WLS, apply patch # 14458989.
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 11i - 11.5.10CU2 + 11i.ATG_PF.H.delta.7 + 9945762 + 12374991
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
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
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 + 9945332:R12.INV.B, 10172716:R12.INV.B, 11654417:R12.ITM.C,10397048:R12.INV.B, 10632813:R12.OWF.B, 10399014:R12.ITM.C, 13893810:R12.INV.B
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.
The Agile PLM Integration Pack for SAP requires:
Agile Product Lifecycle Management release 9.3.1.2.
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.0.1 with patch 10276392.
Agile Product Lifecycle Management releases 9.3.0.2 with patch 10276395.
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.
Rollup patch ARU 14240657 after installation is complete.
The Oracle Process Integration Pack for Oracle Utilities Field Work requires:
Oracle Utilities Customer Care and Billing (OUCCB) with versions:
2.4.0 or higher or,
2.3.1 with Service Pack 1 (11675360) or higher or,
2.2.0 with Service Pack 9 (patch 2610362) or higher
Oracle Utilities Work and Asset Management with version:
1.9.0.1 with patch 11729236 or higher
Oracle Utilities Mobile Workforce Management with versions:
2.0.1.3 with patch 11728648 or higher or,
2.1.0 or higher or,
1.5.0.11 or higher
Oracle Utilities Real Time Scheduler Planner with version:
10.3.14 (required for MWM 1.5.0.11)
Oracle Utilities Resource Manager with 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.3.1
Patch 13403214 and prerequisites must be applied to the Oracle Utilities Customer Care and Billing application.
Note:
Patch 13403214 is included in OUCCB 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.3.1.
Patch 13403214 and prerequisites must be applied to the Oracle Utilities Customer Care and Billing application.
Note:
Patch 13403214 is included in OUCCB 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 or 12.1.3
For more information on the seed data patches you must apply for each version of Oracle E-Business Suite, see Table 2-7 or Table 2-6.
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-8.
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. |
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-9.
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-10 or Table 2-11.
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 |
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-12, Table 2-13 or Table 2-14.
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 |
The Financials Ops Control: Oracle Retail - PSFT PIP requires:
Oracle Retail Merchandising Suite:
Oracle Retail Merchandising System 13.1.1.3
Oracle Retail Invoice Matching 13.1.1.2
Oracle Retail Integration Bus 13.1.1
For PeopleSoft Financials 9.0:
PeopleTools 8.49.19 or greater.
Resolution 791023 applied first then 801426, 776755, 845240 and 843161.
For PeopleSoft Financials 9.1:
PeopleTools 8.50 or greater
Resolutions 845787 and 843169.
Oracle Data Integrator version 11.1.1.5 plus patch 12837214 or ODI 11.1.1.3.
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)
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.
Patch 16188196
Table 2-16 describes the patches you must apply to Oracle SOA Suite 11.1.1.6
Table 2-16 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-17 describes the patches you must apply to Foundation Pack 11.1.1.6 (PS5).
Table 2-17 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-18 describes the patches you must apply to Oracle Transportation Management (OTM) 6.2
Table 2-18 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. |
Table 2-19 describes the patches you must apply to Oracle E-Business Suite R12.1.3.
Table 2-19 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
Patch 16188196
Table 2-20 describes the patches you must apply to Oracle SOA Suite 11.1.1.6
Table 2-20 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-21 describes the patches you must apply to Foundation Pack 11.1.1.6 (PS5).
Table 2-21 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-22 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
Patch 16188196
Table 2-23 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-24 describes the patches you must apply to Oracle SOA Suite 11.1.1.6.
Table 2-24 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-25 describes the patches you must apply to Foundation Pack 11.1.1.6 (PS5).
Table 2-25 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-26 describes the patches you must apply to Oracle Transportation Management (OTM) 6.2.
Table 2-26 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. |
Table 2-27 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 locating searching on these part numbers on https://edelivery.oracle.com/
:
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 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-28 or Table 2-29.
Oracle Data Integrator 11.1.1.5 plus patch 12837214.
For information on the patches you must apply to other versions of ODI, see Table 2-30.
Table 2-28 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-29 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-30 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. |