flexible products

8/9/2019 Flexible Products

1/17

Flexible Products CompanyFlexible Products Company

Small CompanyBIGSystem


2/17

Flexible Products CompanyFlexible Products Company

Largest Independent Polyurethane SystemsHouse in North America

Revenue 100+ Million- Growing 15%/yr

Sell Similar Products Into Different Markets Consumer, Construction, Industrial, Packaging

Multi-Site, Multi-National Marietta, GA, Joliet, IL, Austin TX

Toronto, CAN

London, UK


3/17

Reasons for RunningReasons for Running

Oracle ApplicationsOracle Applications

Open System- Ability to Use Data WithMS Office Applications

Enterprise Install Centralize IS, G&A, Customer Service, and

Technical Support Functions

NCA/Internet Architecture

Minimal WAN bandwidth (56k is OK) Future Development (11i and beyond)


4/17

Implemented Oracle ModulesImplemented Oracle Modules

Accounting Applications General Ledger

Accounts Payable

Accounts Receivable

Manufacturing/Customer Service Applications Inventory Control

Order Entry

Purchasing

Bills Of Material

Cost Management

Engineering

EDI Gateway


5/17

Ancillary ProgramsAncillary Programs

Scope (now part of PeopleSoft) Forecasting

MRP

Capacity Planning

Gentran EDI Translator

Jetform Central Plain Paper Forms Server


6/17

Computer InfrastructureComputer Infrastructure

Dec Alpha 2100 Database Server

3 Processor (300mhz), 1Gb Memory

True64 Unix

Dec Alpha 2100 Standby/Development Server 1 Processor (300mhz), 512Mb Memory

Dell 6350 NT Middle Tier

2 Processor (500mhz), 1Gb Memory

Dell 6100 NT Backup for Middle Tier 2 Processor (Pro 200mhz), 1.5 Gb Memory

Dell Pentium Workstations 150mhz to 600mhz


7/17

Network InfrastructureNetwork Infrastructure

MCI Frame Relay (512K Marietta & Joliet,56K Austin, 56k Toronto, 64k England)

1Mb Internet

Domestic Locations-Global Crossing International Locations- UUNet

ISDN/Cable Modem/DSL Backup

Cisco and Ascend Routers SonicWall Routers for VPN

SMC and DLINK Switches and Hubs


8/17

10.7 Implementation10.7 Implementation

Divisional Approach

Corporate ( Mar-May 1997)

GL, AP

Marietta Manufacturing (May-Aug 1997)

AR, OE, IC, PO, Interface To Cimpro Process Mfg

FPC Custom Process MFG (Dec 1997)

Joliet Division (Sept 97-Feb 1998) BOM, Cost, Eng, EDI, Tank Tracking (FPC App)

NCA Upgrade (May-June 1998)

Market Conversion/Centralization/Calendar Year (Nov-Jan 1998)

London Distribution (Dec 1998)

OE, IC, Manual Interface to Sage

Austin Manufacturing (Nov-Dec 1998)

FPC Process Mfg, BOM, IC

Toronto Manufacturing (Nov-Dec 1999)

Chart of Account Conversion (Dec-Jan 1999)

London Accounting (Feb 2000)


9/17

EDI- Lessons LearnedEDI- Lessons LearnedBill Drozda- MIS DirectorBill Drozda- MIS Director

Twenty Five Major Trading Partners

Inbound Data Purchase Orders (850)

Freight Invoices (210/980)

Invoice Discrepancies (864)

Payment Order / Remittance Advice (820) via Bank

Functional Acknowledgments (997)

Outbound Data

Invoices (810) Advanced Shipping Notices (856)

Functional Acknowledgments (997)


10/17

EDI X12 Transactions Currently InDI X12 Transactions Currently InUsese 810 Invoice (Outbound)

820 Payment Order / Remittance Advice (Inbound)

850 Purchase Order (Inbound)

856 Ship Notice / Manifest (Outbound)

210 Motor Carrier Freight Details & Inv. (Inbound)

864 Text Message (Invoice Discrepancy) (Inbound)

997 Functional Acknowledgment (In & Out)


11/17

Future EDI Transactions Requireduture EDI Transactions Required 810 Invoice (Out)

812 (Debit / Credit Advice) (In & Out)

816 Organizational Relationships (In)

820 Payment Order / Remittance Advice (Out)

830 Planning Schedule with Release Capability (In)

832 Item Synchronization (In & Out)

850 Purchase Orders (Out)

856 Ship Notice / Manifest with SCC 128 Bar Code (In & Out)

857 Shipment & Billing Advice (Out) 940 Warehouse Shipment Order (Out)

945 Warehouse Shipment Advice (In)


12/17


13/17

EDI LESSONS LEARNEDDI LESSONS LEARNEDO r a c l e E D I G a t e w a y i s O n l y O n e P i e c er a c le E D I G a t e w a y i s O n l y O n e P i e c e

o f t he ED I Puz z l ef t he ED I Pu z z le Customizations

Programming & Testing Translator Maps Takes Time (Customer\Version Specific)

Required Data May Not Be In Oracle Applications (Flexfields)

Oracle EDI Gateway May Not Extract Required Data (Extension tables)

Need to Warehouse Inbound Data or Build XREF for Outbound Data

Customer Part / Our Part Our Part / UPC

Oracle Address / Customer - Supplier SiteCode

Edit / Update Programs to Ensure EDI Data Integrity

Print / EDI Routines (Oracle Does Not Support Both)

Address Maintenance (AR & EDI Gateway Trading Partners)

Redundant Synchronization Problems


14/17

EDI LESSONS LEARNEDDI LESSONS LEARNEDO r a c l e E D I G a t e w a y i s O n l y O n e P i e c er a c le E D I G a t e w a y i s O n l y O n e P i e c e

o f t he ED I Puz z l ef t he ED I Pu z z le Customizations (Continued)

Control Reports to Monitor Errors & Data Flow Status

VAN / Direct to Translator & Vice Versa

Translator to Oracle & Vice Versa

VAN / Direct to & from Trading Partner


15/17

DevelopmentDevelopmentDan Crowley- Director of MISDan Crowley- Director of MIS

We do not modify Oracle Code

Use Oracle Interface Tables

Oracle PL/SQL MS Visual Basic Development Tools

Less expensive

Easier to use ODBC fast enough


16/17

Custom ApplicationsCustom Applications

Custom Forms (Jetform Central)

PO, Invoice, Statement, Check,

Packing Slip and Bill of Lading

EDI Edit and Update processing

Tank Tracking

Batch Ticket Processing

Quality Assurance Testing Quick Order Entry


17/17

The FutureThe Future

WEB Interface to the Data Warehouse

Internet WAN- VPN

Eliminate Frame Relay Private Lines

Lower cost, higher bandwidth, better performance

Convert VB Apps to Internet Interface 11i

Scanned Attachments

WEB Procurement

E-Commerce Oracle Front Office Modules

flexible products

Documents