Demantra integration patches rolled up into R12.0.4

For customers on R12.0.4 instance level, there is no need for applying any integration patch for seeded Oracle EBS-Demantra integration to work.
As Oracle has got the Demantra-EBS Integration patch contents rolled up into 12.0.4, so if you are on 12.0.4 you just need to install Oracle Demantra 7.2.0 or higher version and no other patch is required for integration, unlike with 11.5.10 CU2 and R12.0.3 where EBS-Demantra integration patch needs to be applied.

For more details refer to Oracle Metalink Note:727237.1

Demantra - S&OP (Sales & Operational Planning) : Integration Overview - 3

S&OP module of Demantra 7.2:

Oracle has provided a great solution as out of box offering for Sales & Operational Planning process in form of Demantra's S&OP module, integrated seamlessly with EBS R12, ASCP, and SNO. Oracle has done lot of seeded configuration in Demantra front to support the S&OP processes and integration with Enterprise resource planning(ERP), strategic planning tool(SNO), and tactical planning application(ASCP). We will try to take a closer look at these entities and how it can help you in building a collaborative, integrated, Real time Sales & Operational Planning environment using Demantra.
S&OP configuration in Demantra has been built on top of basic Demand Management module, so all the seeded DM entities co-exist and are used in S&OP module as well. S&OP has been defined as a separate component within Demantra so that S&OP process stakeholders work on entities related to them. Remember that Data model definition remains common for S&OP as well as DM modules of Demantra.

NEW DEMANTRA ENTITIES:

1. Levels & Hierarchies:

New levels and hierachies to support viewing/analyzing supply plan and related data for Supply Review and Executive Reviews have been introduced. For Supply review, Supply plan information is being captured in Plan Scenario (General Levels) with proper statuses in Scenario Status(Plan Scenario>Scenario Status) to maintain and manage Supply plans in Demantra. Also new Supplier level(lowest level) and Resource level (Resource-Scenario>Resource, Linked Scenario) hierarchy also appears for viewing data at Supplier level.

2. Series for RT-S&OP

S&OP involves much more information and collaboration in terms of inputs, recommendations and consensus, thus Oracle has provided seeded series for carrying out S&OP sub processes. All the supply plan related information at Plan Scenario level for item & location population is stored in form on various series:

Plan related data series: Available Resource/Supplier Premium/Standard Capacity, Required Resource/Supplier Capacity, Constrained Forecast, Beginning On-hand, Dependent Demand, Inventory plan, Planned Shipments, Production Plan, Safety Stock.

SCI data series: Actual Production, Actual On-hand, Past due backlog, Total backlog etc. for capturing Supply Chain Intelligence data to monitor KPIs and for exception management.

Consensus related data: Multiple series for handling consensus creation process during Demand Review stage, like for weightages from various stakeholders, their forecasts, Consensus Forecast (in units & amount), etc.

3. Worksheets

To carry out each of the sub-processes in S&OP like Demand Review, Supply Review, etc., Oracle has provided quite a few seeded worksheets for each of these steps.

• 
  
  Worksheets to support Demand Review Process : Marketing Forecast, Sales Forecast, Consensus Forecast related worksheets at various levels of aggregation.


• 
  
  Worksheets to support Supply Review Process: Constrained Plan, Production Plan, Inventory plan and Exception management related worksheets for Supply Demand balancing and analysis of various Supply scenarios, coming from ASCP/SNO.


• 
  
  Consolidated Plan related worksheets for reviewing and approving the final agreed upon Demand & Supply plan, which is further published back to ASCP for further detailed planning and execution.


• 
  
  Worksheets & Content panes for KPIs like Demand Fill%, Production & Inventory plan adherence, etc.

4. Integration Interfaces: Since S&OP process captures, processes and involves much more information as compared to DM, you can find new Integration Interfaces for supporting this inbound and outbound data flow. Few important interfaces which has been seeded by Oracle are described briefly in table below:

Workflows related to Plans, allow you to easily load your Supply plan data in form of Plan scenarios into Demantra for Supply reviews and Plan consolidations.

5. Workflows: Real time Sales & Operational Planning is more of process and people oriented than application oriented, it requires input and approvals from various stakeholders for consolidation Oracle has addressed this front with Demantra's seeded workflows which can be customized further to fit customer's requirements. Workflows automate/semi-automate key processes like Demand Review, Supply plan load, exceptions handling and Publishing Consensus plans.

Besides above discussed entities, there are few more setups and entities, which have been provided with out-of-box S&OP Demantra application. Remember that the configuration flexibility of Demantra provides a huge opportunity for solving your specific S&OP problems. With seeded integration between EBS and APS suite products, S&OP module of Demantra can be easily Incorporated in your organization.

Demantra - S&OP (Sales & Operational Planning) : Integration Overview - 2

What it takes for seeded S&OP integration to work ?
Demantra's 7.2.0 and higher versions have seeded integration for Sales & Operations Planning(S&OP) module with Advanced Supply Chain Planning(ASCP) & Strategic Network Optimizer(SNO) modules of APS. The seeded integration however currently is supported only with Oracle EBS R12.0.4 version and is available as integration patch. Once you fulfill the pre-requisite criterias and apply the patches, on EBS front new responsbilities start appearing(similar to EBS-DM integration).

What's new on EBS side? :

The New Responsbilities for S&OP:
1. Sales & Operations Planning System Administrator : This responsbility is quite similar to Demand Managment System Administrator responsbility and has few Menu options common to DM System Administrator. Users who controls and executes data collection for S&OP planning should have access to this responsbility. S&OP Administrator can collect all the relevant data from EBS into Demantra, using Collection menu options controlled by Setups and Profile options.
The Menus in this responsbility are divided broadly into following:

• Links to Open Demantra S&OP application (which includes : S&OP Workbench, Workflow Manager, Administration, User Management)
• Collections Menu (which includes : Collection > Standard collection, Shipment & Booking History data, SCI Data**, Currency Conversion, UOM Conversion, Returns History, Pricing Data, and Download Calendars)
• Collect from Legacy (Legacy Collection - Flat; Legacy Collection - Self; Shipment & Booking History - Flat; Shipment & Booking History - Self Service)
• Setup ( Instances; Calendar List; New Product List; Price List )

2. Sales & Operations Planning Analyst: S&OP Analyst responsibility is same as Demand Analyst in Oracle's EBS-Demantra DM integration. As an analyst, the menu options have limited authority and can only Open Demantra S&OP applications - S&OP Workbench, Workflow, Administration, and User Management pages.

3. New S&OP enabled plan options: ASCP & SNO plan options have now a new check box saying "S&OP enabled", once selected those Supply plans can be brought inside Demantra for S&OP process as Supply Plan Scenarios.

4. Publish option in SNO: New option to publish SNO plan for S&OP usage has been added in SNO workbench.

** From collection point of view, only Supply Chain Intelligence(SCI) data is added entity as compared to Demand Management integration. SCI data being collected comprises of Order backlog information, Actual production data, etc.

Besides above changes on EBS/ASCP/SNO side, Demantra's S&OP module has been changed a lot to support this seeded integration. There are new Levels, hierarchies, series, worksheets. integration interfaces, workflows etc. which appear if you install S&OP module.