BPI - Business Process based application Integration - and its application for Supply Chain Management System

(1)

BPI

--

Business Process based application Integration

-

-and its application for Supply Chain Management System

and its application for Supply Chain Management System

Kazuyuki Aoyama

[email protected]

Business Solution Systems Development Division

Hitachi, Ltd.

(2)

Why EAI now?

BPI

(Business Process based application Integration)

The Purpose of EAI:

To support improvement and progress of enterprise business systems

in order to keep up with the radical change of business environment

The Purpose of EAI:

To support improvement and progress of enterprise business systems

in order to keep up with the radical change of business environment

But, how?...

Rapid Change in

Business Environment

Rapid Change in

Business Environment

Information Technology

Rapid Change in

Information Technology

z

Business system becomes complex more and more

z

But still, business style need to be changed...

(3)

What is BPI?

BPI Framework

Application

Package

Ｄ

Systems

atabase

Existing

Systems

ERP

Package

Human

Business Process Definition

9

Business process definition is set as the core of the integration

architecture

9

Application components and business process are combined

BFC

(4)

Business Process Definition

Features of BPI

BPI Framework

BFC

Flexibility for Changes

of Application

Component

Integration including

human decisions

Capability for

step

-

by

-

step

improvement

Reusability of Design & Program

z

Integration Model

z

Data Model & Mapping Rule

z

BFC Framework & Adapters

Reusability of Design & Program

z

Business Process Definition

z

Integration Model

z

Data Model & Mapping Rule

z

BFC Framework & Adapters

Flexibility for

Changes of

Business Process

BFC

(5)

WorkCoordinator

Server

WorkCoordinator

Support for variety of

process model

Open interface

Adaptability for changes

Hitachi’s Workflow System specialized for Integration

Hitachi

’

s Workflow System specialized for Integration

Collaborative business process

A Semi-predefined process in which operations are different for each process instance

Form-circulation business process

A predefined process

Project-type business process

Ad-hoc process in which a work item is broken down at every step into smaller tasks

CORBA based interface

RDB data access

Changes at runtime

Changes of rules in business process definition such as conditions can be done at runtime

Process instance migration

Process instance migration utility is available to migrate process instances from an old business process definition into new ones.

WorkCoordinator

Definer

WorkCoordinator

Definer

zBusiness Process

Definition

WorkCoordinator

Monitor

WorkCoordinator

Monitor

zStatus Monitoring

zAdministration of

Process instances

BFC

Existing application on

mainframe

Web-based application

RDB

ERP Package

(6)

A Case Study - BPI application for SCM

SCPLAN

(Hitachi’s MRP Engine)

Production Planning

System

Production Plan

Purchasing & Inventory

Management System

(ERP)

Purchase Order Inventory Material Master BOM

WorkCoordinator

(controls flow of the process)

WorkCoordinator

(controls flow of the process)

Purchasing &

Inventory

Management

System

(ERP)

Buyers

SCPLAN Generates future material shortage

information based on the production plan, current inventory, and issued P.O.

Material shortage information is

transformed to purchase requisition and distributed to appropriate buyers

Receiving the purchase requisitions, buyers issue purchase order with their professional decisions

Data

extraction &

transform

Execution

& complete

detection

Data

transform &

distribution

Event detection

(purchase order,

inventory receipt)

Supply Chain Management (SCM) System for Acquisition Process of

Manufacturer

Receipt of

Material

(7)

Integration Schedule and Outputs

Business

Analysis

& Design

System

Desi

ｇ

n

Program

Design &

Implementation

April

May

June

July

August

September

March

Business Process Modeling

Data Modeling

Integration Modeling

Study of Application Components (ERP, SCPLAN)

Data Mapping Design

Study of APIs of Application Components

Coding, Testing, & Debugging

Program Design

BP Definition Data Model Integration Model Data Mapping BFC Program Design Application Program Design BP Definition Integration Model Data Mapping

(8)

Examples of Design (1)

MRP & Purchase Requisition BP

Execute MRP

Purchase Requisition (Parallel Work Item)

Purchase Requisition for material “A”

Executing MRP

Purchase Requisition for material “F”

Waiting Purchase Requisition

Purchase Order & Inventory Receipt BP

Accept Purchase Requisition Create Purchase Order Issue Purchase Order Accepting Purchase Requisition Creating Purchase Order Waiting Purchase Order Inventory Receipt Waiting Inventory Receipt

SCPLAN

z

Business processes and rules of

processes are defined

z

Application Components should be

considered

z

However, business process should

not be designed closely dependent

on the Application Components

z

Business processes and rules of

processes are defined

z

Application Components should be

considered

z

However, business process should

not be designed closely dependent

on the Application Components

Business Level: Business Process Modeling

(9)

z

Application Components are combined to

work items in business process definition

using BPI Framework Components (BFCs)

z

System Level Process may be defined as a

sub-process of a business process

z

Application Components are combined to

work items in business process definition

using BPI Framework Components (BFCs)

z

System Level Process may be defined as a

sub-process of a business process

BPI Framework

MRP Execution BP Create SCPLAN Input Data Execute SCPLAN Store SCPLAN Execution Result Creating SCPLAN Input Data Executing SCPLAN Storing SCPLAN Execution Result

MRP & Purchase Requisition BP

Execute MRP

Purchase Requisition (Parallel Work Item)

Purchase Requisition for material “A” Executing MRP

Purchase Requisition for material “F” Waiting Purchase Requisition

System Level Process

AP Start & Complete Detect

SCPLAN

SCPLAN Input File

ERP

Production

Planning

System

Production Plan Purchase Order Inventory

RDB

Material Shortage Data

Transformer TransformerData

Evaluate “Material Shortage”

DB and generate parallel work

items for each records

DB Evaluator

System Level: Integration Modeling

(10)

Material Code *

Material Name

Effective Start Date

Effective End Date

Buyer Code

Inventory Category

Inventory Block

Material Category

Warehouse Code

...

Material Code

Material Type

Registered Date

Effective Start Date

Material Code (FK)

Language Code

Material Name

Fixed by “J”

Tables in ERP

SCPLAN Input File Format

z

Data mapping rules between source and

target Application Components are defined

for each “Data Transformer” type BFC.

z

Data Model developed at previous step

makes this easier.

z

Data mapping rules between source and

target Application Components are defined

for each “Data Transformer” type BFC.

z

Data Model developed at previous step

makes this easier.

references

System Level: Data Mapping

(11)

Purchase Order & Inventory Receipt BP

Purchase Order & Inventory Receipt BP

Accept Purchase Requisition Create Purchase Order Issue Purchase Order Inventory Receipt BP BP Junction Junction Create SCPLAN Input Data Execute SCPLAN Store SCPLAN Execution Result

MRP & Purchase Requisition BP

Execute MRP Purchase Requisition Purchase Requisition

for each Material

Overall Structure

BP BP Junction Junction SCPLAN Input Files Activator Program WorkCoordinator API SCPLAN Server SCPLAN Adapter SCPLAN Adapter Material Shortage Info RDB RDB Adapter ERP Adapter ERP Purchase Requisition Worklist management P.O. Client SCPLAN Client (Customized) ERP Purchase Order SCPLAN

Server Purchase_Order

Registration Inventory Receipt ERP Adapter Purchase Requisition Registration Production Plan Material -Shop Material Master Shop Master Warehouse Master Vendor Master Production Capacity Material Master BOM RDB Adapter RDB Adapter ERP Adapter ERP Adapter ERP Adapter ERP Adapter ERP Adapter ERP Adapter ERP Adapter ERP Adapter File Adapter File Adapter File Adapter File Adapter File Adapter File Adapter MPS Calendar (Local) Shop Master Production Master Lot Info. Calendar (Master) Inventory In/Out Inventory Supply Master ERP RDB File Adapter File Adapter Production Plan Detail RDB Adapter Purchase Info (Org.) Purchase Info.(Gen.) P.O. P.O Detail P.O. Ship Inventory ERP Adapter ERP Adapter ERP Adapter Material-Warehouse BOM ERP Adapter ERP Adapter File

Adapter Material-Vendor WCO

Link WCO

Link WCOLink WCO_Link WCO_Link

ERP Adapter Purchase

Requisition

RDB

Transformer (table to table) Transformer (table to table)

Execution / Execution / Complete Detection Complete Detection Transformer Transformer (table to table) (table to table) Transformer Transformer (record to record)

(record to record) WatcherWatcher

Wrapper Wrapper

Note: Arrows in this diagram indicates the direction of call, or reference. Arrows do not indicate flows of data.

Worklist Worklist Purchase Requisition RDB Process Data Management Process Data Management (a) BP Junction BFC

Activate sub-process, and notify end of the sub-process

(C) Execution/Complete Detection BFC

Execute SCPLAN, and notify WorkCoordinator the completion of MRP

(b) Transformer (table to table) BFC

　Collects data from ERP and other system, and transform it into SCPLAN input files

(d) Transformer (table to table) BFC

Extract material shortage data from SCPLAN, transform it, and put it in RDB

(e) BP Junction BFC

Create BP2 Instances for each work item “Purchase Requisition for each

Material” in BP1 (f) Transformer (record

to record) BFC

Register Purchase Requisition records

(g) Worklist BFC

Show issued purchase requisition records for each buyer

(h) Wrapper

Put P.O. record into ERP

(i) DB Watcher BFC

Periodically check ERP table, and detect entry of inventory receipt record Program which is independent to Application Components

(12)

Findings from the SCM Integration (1)

Common Part (WCO Link) Notify Completion Application Independent Execute Notify Application Dependent (Adapter) Application Dependent (Adapter) Application Component Data Import Application Component Data Export

Work Item

WorkCoordinator

Transformer type

BPI Framework Component

Execute an application with parameters, detect completion, and notify the completion to the WorkCoordinator

Import data from multiple tables in source applications, transform the data, and put the data into target applications

Receive record data, transform the data and put the data into target application Put process instance into a business process with passing parameters, and watch the status of the business process (e.g. completion of the process) Check data in an application periodically, and notify the result to the WorkCoordinator when predefined condition occurs in the data

Check data in an application once, and notify the result to the WorkCoordinator Provide list of work items for each users, and activate appropriate application when the user select a work item on the list.

Execution / Complete Detection

Transformer (table to table)

Transformer (record to record)

BP Junction

DB

Watcher

DB

Evaluator

Worklist

Types of BPI Framework Components

(13)

Business

Analysis

& Design

Scrap & build

(estimated)

BPI without

reusable templates

Generic part of BPI

BPI with templates

(estimated)

System

Design

Program

Design &

Implementation

Total

Cost for the integration/development (Human.Month)

Findings from the SCM Integration (2)

Reusability of

design

and program

4

12

16

32

yApplication program (10) ySCPLAN Integration (6)

4

12

28

yBusiness Template (3) yDetail Design (1) yIntegration Template (9) yApplication dependent (3) yApplication program (2)

yBPI Framework Component Generic (7.3) Customer dependent ( 2.7)

19.3

3

9

7.3

yBusiness Template yIntegration Template

yGeneric part of BPI Framework Component

8.7

1

3

4.7

Relative cost

using templates

27.2%

87.5%

64.7%

(14)

BPI Concept

BPI Methodology

Our Challenges

Methods and Procedures

z

Procedures for BPI

z

BP Design for Integration

z

Enhancement of BFC Model

Methods and Procedures

z

Procedures for BPI

z

BP Design for Integration

z

Enhancement of BFC Model

Tools & Products

z

Enhancement of

WorkCoordinator

z

BPI Design Support Tool

z

BFC Toolkit

Tools & Products

z

Enhancement of

WorkCoordinator

z

BPI Design Support Tool

z

BFC Toolkit

Application & Evaluation

z

Template Development for

Business Domains (SCM,

CRM, …)

z

Application for Customer’s

Business System

Application & Evaluation

z

Template Development for

Business Domains (SCM,

CRM, …)

z

Application for Customer’s

Business System