APPLIES TO:

Oracle Demantra Real-Time Sales and Operations Planning - Version 7.0.2 and later
Oracle Demand Planning - Version 11.5.10 to 12.0.3 [Release 11.5 to 12]
Oracle Demantra Deduction and Settlement Management - Version 7.0.2 and later
Oracle Demantra Advanced Forecasting and Demand Modeling - Version 7.0.2 and later
Oracle Demantra Predictive Trade Planning - Version 7.0.2 to 7.2 [Release 7 to 7.2]
Information in this document applies to any platform.

PURPOSE

!!!PLEASE READ NOTE 788671.1 AS THERE IS AN IMPORTANT ALERT THAT DEALS WITH DEMANTRA CUMULATIVE PATCH AND BASE VERSION INSTALLATIONS!!!

This document is intended to provide the latest rollup patches available for Demantra as well as general patch number information for EBS/Siebel/E1 to/from Demantra integrations. There are other reference note links to topics that would be beneficial to the customer and Oracle personnel. Please note that all Rollup patches are cumulative unless otherwise specified.

It should be remembered that when applying a Demantra patch that if you are using a WAR file to deploy the application to the web server (common, but not limited, to those clients using Oracle Application Server (OAS), WebLogic, and Websphere) that after the patch is installed on the centralized box that the WAR file needs be recreated and redeployed. This is so that the changes that the patch made to the web application files (ex. java, .jsp, classes, etc.) are propagated to the web server.

In addition, if the patch you are applying contained changes to the Demantra Engine executables (check the Patch ReadMe), and you are utilizing a multi-machine distributed engine, then follow Note 751772.1 as to how to propagate those changes to these distributed machines.

SCOPE

The intended audiences include Oracle Support, Oracle Partners, Oracle Development, Oracle Sales, Oracle Consulting and Oracle Customers

DETAILS

This Document was last updated on 17-MARCH-2021

Demantra 12.2.x:

From 12.2.x onward compatibility between Demantra VCP is as follows:

Demantra 12.2.x will work with VCP 12.2.x, same version for both demantra and VCP

Demantra 12.2.x individual versions compatibly as follows:

Demantra 12.2.10 will only work with VCP 12.2.10

Demantra patches for 12.2.10 see Note 2714991.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.10 - R12.SCP_PF.C.delta.11
Demantra 12.2.10 and VCP 12.2.10 will work with
- EBS 12.1.3
- EBS 12.2.10

Demantra 12.2.9 will only work with VCP 12.2.9

Demantra patches for 12.2.9 see Note 2652288.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.9 - R12.SCP_PF.C.delta.10
Demantra 12.2.9 and VCP 12.2.9 will work with
- EBS 12.1.3 (EBS Source on must be on VCP 12.1.3.9.2)
- EBS 12.2.9

Demantra 12.2.8 will only work with VCP 12.2.8

Demantra patches for 12.2.8 see Note 2482698.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.8 - R12.SCP_PF.C.delta.9
Demantra 12.2.8 and VCP 12.2.8 will work with
- EBS 12.1.3 (EBS Source on must be on VCP 12.1.3.9.2)
- EBS 12.2.8

Demantra requires 12.2.7.1 which works with VCP 12.2.7.1

Demantra patches for 12.2.7.1 see Note 2413191.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.7 - R12.SCP_PF.C.delta.8
Demantra 12.2.7.1 and VCP 12.2.7.1 will work with

EBS 12.1.3 (EBS Source on must be on VCP 12.1.3.9.2)
EBS 12.2.4
EBS 12.2.5
EBS 12.2.6
EBS 12.2.7.1

Demantra requires 12.2.6.3 which works with VCP 12.2.6.3

Demantra patches for 12.2.6.3 see Note 2392888.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.6 - R12.SCP_PF.C.delta.7
Demantra 12.2.6 and VCP 12.2.6 will work with

EBS 12.1.3 (EBS Source on must be on VCP 12.1.3.9.2)
EBS 12.2.4
EBS 12.2.5
EBS 12.2.6

Demantra 12.2.6 will work with JD Edwards EnterpriseOne 9.1 and 9.2.

Demantra requires 12.2.5.1 which works with VCP 12.2.5.1

Demantra patches for 12.2.5.1 see Note 2069281.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.5 - R12.SCP_PF.C.delta.6
Demantra 12.2.5.1 and VCP 12.2.5.1 will work with

EBS 12.1.3 with VCP Cum Patch 12.1.3.9.1 OR 12.1.3.9.2
EBS 12.2.4
EBS 12.2.5

Demantra 12.2.5.1 will work with JD Edwards EnterpriseOne 9.1 and 9.2.

Demantra requires 12.2.4.1 which works with VCP 12.2.4.1

Demantra patches for 12.2.4.1 see Note 1342064.1
For VCP Patching see Note 1361221.1 - Known Issues for 12.2.4.1
Demantra 12.2.4.1 and VCP 12.2.4.1 will work with

EBS 12.1.3 with VCP Cum Patch 12.1.3.9.1 OR 12.1.3.9.2
EBS 12.2.4

Demantra 12.2.4.1 will work with JD Edwards EnterpriseOne 9.1 using the AIA 11.4 for the Value Chain Planning Base Integration Pack.

Demantra 12.2.3 will work with VCP 12.2.3.

Demantra patches for 12.2.3 see Note 1342064.1
Demantra 12.2.3 and VCP 12.2.3 will work with

EBS 12.2.3

Demantra 12.2.3 will work with JD Edwards EnterpriseOne 9.1 using the AIA 11.4 for the Value Chain Planning Base Integration Pack.

Demantra 12.2.2 will work with VCP 12.2.2.

Demantra patches for 12.2.2 see Note 1342064.1
Demantra 12.2.2 and VCP 12.2.2 will work with

EBS 12.2.2

I. Demantra Version 7.3.1

a) 7.3.1.5 - Install PATCH 17850720 - from INSTALL Main Release Patches & How to Upgrade Note. - -Document: 1342064.1

---- VCP 12.1.3.9 is certified ONLY with Demantra Release 7.3.1.5.

-- In 12.2 Demantra/VCP connection to 11i EBS source will no longer be supported. 12.2 VCP supports only EBS 12.1 and EBS 12.2. So customer on EBS 11i will stay in 7.3.1.x line until they upgrade their EBS instance to 12.1 or 12.2.
-- Specific EBS/VCP (formerly ASCP) - Demantra Integration patches go away beginning in VCP 12.1.1 and higher; Please note that beginning with the release of VCP (the name previously given to ASCP) v12.1.1 and higher that no separate EBS/VCP - Demantra patches (ex. Bug 8551184) required. Customer should still run 'Update Synonyms' For Demantra 7.3.1

b) 7315 CDP - Install Patch 17248308 / Focuses on providing a new solution In-Memory Consumption Driven Planning. IMCDP provides the ability and scale to load support daily store level forecasting, safety stock generation and initialization of replenishment orders
Please note that customers upgrading to 7.3.1.5 will be unable to upgrade to currently available 12.2.1 and future release 12.2.2. A supported 12.2.X release for upgrade will be available in the future. Customers who believe they will upgrade to 12.2 branch in the near future should not implement using or upgrade to 7.3.1.5

1. 12.1.x VCP instance -
        The minimum VCP patch level required - 10192383:R12.SCP_PF.B - VCP 12.1.3.2 PATCH. However it is recommended that you get to the latest VCP/ASCP patch for 12.1.3 that's shown in Note 746824.1
        This means that, if you have a centralized environment, it should only be 12.1.3 or higher in order for Demantra to work.
        Note
        - Service Parts Forecasting (SPF) is only supported for 12.1 (source/destination). For 11510 or 12.0.6 source, SPF is not supported.
        - VCP 12.1.3.2 continues to support 7301, 730(without CTO), 720X

1.1 Supported SOURCE Instances for 12.1.x VCP instance -
i) 12.1.x - 10192383:R12.SCP_PF.B - VCP 12.1.3.2 PATCH

  ii) 12.0.6 - (This scenario is not certified by QA. But we do have a patch available)
    1. Patch 9830310 :R12.MSD.A - R12 EBS-DEMANTRA INTEGRATION RUP#09
    2. Patch 11058441:R12.MSD.A - 12.0.6 COMPATIBILITY PATCH FOR VCP 12.1.3.2 (Controlled Release)

iii) 11.5.10 CU2 -
a. Patch 9072397 - DEMANTRA INTEGRATION RUP#07 PATCH FOR 11.5.10
b. Patch 11058665 - 11.5.10 CU2 COMPATIBILITY PATCH FOR VCP 12.1.3.2

Note : Patches 9072397 and 11058665 are mandatory patches for 11510CU2 source, if customer is upgrading his 12.1 instance to VCP 12.1.3.2 or above, irrespective of the Demantra version.

2. 12.0.X VCP instance - Not Supported.
3. 11510CU2 VCP instance - Not Supported.

-- Attention: Oracle Value Chain Planning (VCP) Release 12.1.3.8 can only be applied to Oracle EBS Release 12.1.3 or 12.1.2. VCP 12.1.3.8 can be integrated with Demantra Release 7.3.1.4.

Official Note on VCP 11.5.10.2

The VCP policy is to have customers stay with EBS 11i but upgrade their VCP install to the level compatible with Demantra. So for 7314 they would work with the following configuration: EBS 11.5.10 (11i), VCP 12.1.3.8 Demantra 7.3.1.4
Most customers are unwilling to upgrade their EBS due to customizations, users and overall effort required, but upgrading their VCP apps is easier and is supported.

The customers leave their 11i source system as it is now and installs a separate VCP 12.1 instance which will collect data from 11.5.10.2. This is a fully supported configuration and allows them to connect Demantra 7.3.1.4 to EBS 11i10.
They don't even need to use any VCP apps other than Demantra, but the data flows through the 12.1 VCP instance into Demantra 7.3.1.4. This is the certified configuration for 11i and Demantra 7314, so we advise customers to this.
The additional benefit the customers get is the ability to bring their VCP apps forward without impacting their other EBS applications.

II. Important Reference Notes

Note 443969.1 Oracle Demantra Demand Management Documentation Library
Note 434991.1 EBS-Demantra Integration Installation Overview and Diagram

III. Latest Demantra Version for SQL Server Databases

The latest Demantra Version that supports Microsoft SQL Server Databases is v7.2.0.1.1 Patch 8811761. Note that the resulting file that is downloaded from this link should be p8811761_720_WINNT.zip. After installing that version and/or upgrading from earlier Demantra versions then please also apply Cumulative Patch 8823379
NOTE:1319331.1 Latest Supported Demantra Release For Sql Server and Installation

REFERENCES

NOTE:434991.1 - EBS-Demantra Integration Installation Overview and Diagram
NOTE:223026.1 - List of High Priority Patches for the Value Chain Planning (aka APS - Advanced Planning & Scheduling) Applications
NOTE:727237.1 - What patches are required to integrate Demantra with EBS?
NOTE:751772.1 - Distributed Engine Windows and Linux Deploying Multiple Engines Howto and Troubleshoot
NOTE:1361221.1 - Release 12.2.x Oracle Value Chain Planning Installation Notes - Known Issues, FAQ and Latest Patch Information
NOTE:443969.1 - Oracle Demantra: Documentation, Release Notes, Transfer of Information (TOI), and Training
NOTE:1969589.1 - Is Demantra 7.3.0.2 supported on a distributed installation of EBS 12.1.3.9 and VCP 12.1.3.9
NOTE:746824.1 - 12.1.x - Latest Patches and Installation Requirements for Value Chain Planning (aka APS Advanced Planning & Scheduling)
NOTE:1319331.1 - Latest Supported Demantra Release For Sql Server and Installation
NOTE:865764.1 - Patches for Demantra version 7.2.0
NOTE:421097.1 - R12.0 - Latest Patches and Critical Information for VCP - Value Chain Planning (aka APS - Advanced Planning and Scheduling)