Thursday, July 17, 2008

Oracle Demantra: Seeded EBS-DM integration data flow

Oracle's seeded Demantra integration with Demantra's Demand Management module can be utilized with ease to empower an organization with a collaborative, web based, integrated demand planning environment.

In EBS-DM integrated environment, one can start the process of demand planning, with responsibility "Demand Management System Administrator" .

The process starts with Collection of master/transactional data (item, location & sales) from EBS and ends with publishing back consensus forecast to Oracle supply chain planning application. Demand Administrator logs into the Demantra responsibility and starts the Collection program, downloads the master and historical data into Demantra application using seeded workflows, kicks off a workflow to execute the analytical engine in batch mode, makes manual adjustments/overrides on forecast with information like causal factors and promotions and finally runs another workflow to upload the forecast back into APS/MRP.

Demand planning using Demantra Demand Management application compromises of following high level process steps:

  • Collection of Dimensional, historical, pricing, costing and other reference data
  • Validate & Modify data
  • Generate Baseline Forecast
  • Consolidate Baseline, Simulation and manual forecasts
  • Upload Final Forecast to ASCP/SNO/IO/MRP
  • Archive Monthly Forecast

2 comments:

Anonymous said...

Will you explain in micro level the details/steps of collection from EBS to demantra.
I am a begineer to demantra.

Raj said...

Hi Jagannathan,

Thanks for the comments.

Writing micro level would be difficult through blogging. As Oracle already has detailed micro level documentation available for these processes.

In an integrated environment, these collection processes are available as Requests/programs under the responsbility "Demand Management System Administrator".

You can refer to "Demantra 7.1.1 Advanced Planning End-User Applications Functional Overview TOI" available in MEtalink (note ID: 443969.1) for more details on collection.

Regards
Raj

Perspectives on Managing through Difficult Times