so pimp tech challenges 1280088578

7/30/2019 So Pimp Tech Challenges 1280088578

1/18

Sales & Operations PlanningDemantra Implementation

Technical challenges Overview

KV Moorthy


2/18

Agenda

Introduction

Implementation phase

Technical Architecture and identity solution Collection

Weekl to Monthl

Analytical Engine

Worksheet performance and Java plug-in

Support process with Demantra developmentteam

Demantra tools (NT)

Q&A


3/18

Introduction - BCI

About BCI

KV Moorthy Architect

Nexinfo

Demand

Supply

S&OP


4/18

About Beckman Coulter

Leading manufacturer in the Medical Diagnostics and

Life Sciences industry Products that simplify, automate and innovate complex

biomedical testing

.

Over 200,000 systems operate world wide

Recently acquired Olympus

Operations in over 60 countries

Multiple Manufacturing Plants Multiple Distribution Locations

Multiple Warehouses


5/18

Nexinfo implementation team Founded in 1999

Second Decade of improving supply Chain Managed by Computer Industry and Supply Chain

Professionals

Client experience ranging from emerging

corporations to Fortune 1000 corporations Deep Domain expertise in Planning and Supply

Chain

HQ in Orange County, CA


6/18

Implementation phase

Before phase 0 migration to R12

Phase 0 - Demantra in Prod

Phase 1 - Full S&OP for Hardware

-spares


7/18

Technical Architecture and identitysolution

Distributed ERP 11.5.10 on LINUX

Demantra 7.2 (7.3)

Single sign on evaluation

Multiple user ids ( Planning , DM and SOP)


8/18

Technical Architecture

Demantra ClientWindows Server

APS Database

OracleApplication

Server

R12.0.6

Linux

DBLink

ERP Database

OracleApplication

Server

R11.5.10Linux

TomcatApache

Client ApplicationsBusiness ModelerAnalytical Engine


9/18

Collection

Multiple data sources

Erp Access

Legacy supply

Materialized view Oe Lines

Mtl system items

Hz parties


10/18


11/18

Migration from Weekly - Monthly

Rebuild Data Model

Forecast issue IU_LAST_DATE Worksheet Dates


12/18

Analytical Engine

VM vs Regular server

Single thread memory issues Distributed for volume and performance

M l i le en ine and m l i le servers

Proport process

Understand the AE logs


13/18


14/18

Distributed Analytical engine server setup - Production

Each server has 2 QUAD CPU with 4GB RAM 32 bit OS


15/18

Worksheet performance and Java plug-in

Gather Schema stat

Demantra collection Supply data download

Temp tables cleanup

Free space in tablespace Java plug-in issues


16/18

Support process with Demantradevelopment team

Service Request Weekly meeting with ORACLE

-


17/18

Demantra tools (NT)

Business modeler

Segregation of duty Reset User password

Unlimited access (drop an object)

BAL next phase


18/18

so pimp tech challenges 1280088578

Documents