Passing Interface Processing Ownership to User Community

1
Passing Interface Processing Ownership to User
Community

• Jacob Seidelman
• Yi Tang
• NCOAUG Training Day
• Feb 28, 2005

2
Agenda

• Business Case
• Solution Design
• Implementation
• Delivered Benefits
• Q A

3
Background

• Jacob Seidelman Business Analyst, Life Fitness
• Yi Tang Programmer Analyst, Life Fitness
• Life Fitness, a Brunswick company, is the global
  leader in designing and manufacturing a full line
  of reliable, high-quality fitness equipment for
  commercial and consumer use
• Oracle 11.5.9 E-Business
• Multiple locations
• Full ERP implementation (FIN, MFG, SCM)
• In the process of implementing CRM Services

4
Business Case

• Key business processes that are labor intensive,
  time consuming, and error prone
• Value-adds are derived from data and process
  analysis not data entry
• A need to create and/or update large volumes of
  data accurately
• A need to process business transactions
  efficiently

5
Key Business Processes

• New production introduction and maintenance
• Item creations, updates, and revisions
• Bill of materials
• Routings
• Item categories
• Pricing
• Costing
• Internal Buy/Sell Transactions

6
Key Business Processes (cont)

• Order fulfillment
• Order entry
• Customer maintenance
• Pick release
• Ship confirmation
• Work In Process
• Inventory Management

7
Current Options

• Manual entry
• Labor intensive
• Time consuming
• Macro dataload
• Resource constraint
• Error prone
• Open Interface
• One time custom development

8
Business Requirements

• Organizational
• Engineering, PACE program
• Order Management
• Supply Chain
• Lean Six Sigma
• User skill sets
• Oracle expertise
• Computer skills
• System security
• Sarbanes-Oxley
• Oracle configuration

9
Functional Design

• Uniform
• Robust
• Modular
• Secure
• Flexible
• Simple

10
Technical Design

• Leverage existing tools and technologies
• Oracle open interfaces and APIs
• Unix shell scripting
• Ftp, csv file format
• SQLLoad
• PL/SQL
• Build-in security features
• User-interface through concurrent program

11
Solution

• Data Load Process - DLP
• Set of tools and rules for loading and processing
  data in Oracle Applications
• Reusable validation and interface logic
• Utilize Oracle open interfaces and APIs
• User-friendly tool that boosts productivity and
  efficiency

12
DLP Framework
13
Basic Process Flow

• Load data
• Validate data
• Process data

14
Complete Process Flow
15
Implementation

• Design framework
• Develop components
• Test interfaces
• Integrate components
• User testing
• Report validation
• Implement solution

16
Setup DLP

• Create DLP responsibilities
• Use request set to setup different process
  components
• Each DLP process (request set) is assigned to a
  DLP group
• Use Oracle build-in security feature to link
  responsibilities with respective DLP groups
• Create SQLLoader control file

17
Run DLP

• Prepare flat file
• FTP file
• Run DLP Master Program
• Select DLP Group
• Select DLP Process
• Click on submit
• Review output and log

18
(No Transcript)
19
(No Transcript)
20
Delivered Benefits

• Empower user to process more data effectively so
  they can focus on making business decision rather
  than data entry
• Provide effective means to load data so data can
  be tested before load into production
• Increase productivity and accuracy
• Create a new paradigm for data maintenance

21
Additional Benefit

• Facilitates testing required by PACE
• Free up IT resource
• Tailored to each individual business purpose
• Logs and reports all data maintenance activities
  and results

22
Q A