Management Dynamics Export Solutions Oracle Integration Nor Cal

Management Dynamics Export Solutions & Oracle Integration Nor. Cal OAUG Training Day January 24, 2006 © 2005 Management Dynamics Inc. Proprietary and Confidential Proprietary Confidential

About Management Dynamics § Global Trade Management specialist with more than a decade of proven results § Delivering “enterprise class” information services – On-demand – Subscription or license behind the firewall § Unique combination of software and specialized content § Supporting over 300 customers with 13, 000 users in 70 countries § Operations in US, UK, Europe, India and Hong Kong § Key to success: continuous innovation 2

Global Trade Management Goals § Accelerate Improve supply chain performance with rich operational data and Six Sigma initiatives Objectives: • 1 Profitable Global Trade • 2 Lean Delivery § Optimize Use decision support tools to optimize strategic sourcing, carrier selection and inventory deployment decisions § Integrate Trade Content Manage supply chain risk and efficiently cross borders with high-value trade content § Automate § Connect Streamline end-to-end processes with configurable workflows Link all trading partners in the supply chain with a common platform 3

The Global Trade Management (GTM) Suite 4

Trade Collaborator Suite TRADE COLLABORATOR TRADE SERVICES ENTERPRISE SOFTWARE GLOBAL CONTENT • • Denied Party Screening Trade Import Trade Export Trade Agreements Trade Reference Landed Costs Import/Export Controls GLOBAL • • • Trade Documents Trade Wizards Trade Engines Trade Classifier Trade Planner Classification Document Mgmt. Content Distribution CONTENT 5

Enterprise Software (TC) Management Dynamics Trade Collaborator Export • Order Management • Customer Management • Product Management • Denied Parties Screening • Export Screening & Licensing • Shipping Documentation • Customs Automated Export System Import • Purchase Order Management Trade Agreements • NAFTA / CBTPA • Pre-Customs Entry (ASN) • Maintenance of Rules of Origin • Customs Entry • BOM Management • Post Entry Management • Supplier/Manufacturer Management • Delivery Order Management • Qualification Determination • Product Management • Supplier Portal • Supplier/Manufacturer Management • Supplier qualification letter requests, distribution and management • Broker Interface • Import Documentation • TA Certificate Generation • Manufacturer’s Affidavit Requests 6

TC Technology Overview Architecture Strategy Tech. Stack Framework Trade Collaborator Dev. Tools Scheduler SDLC Integration Documentation Reports 7

Trade Collaborator Architecture Web Users Browser Users Web Browser Internet (HTTP/HTTPS) (HTTP) Firewall XML ASCII CSV Web Server (Presentation Tier) Application Server Database Tier ERP Trade Collaborator 8

Key Aspects of TC Technology § Global Architecture § Multi-tier Architecture § Native Browser Technology (HTTP, HTTPS, XML) § Java Technology (EJB, JSP, JDBC, JNDI) § Application Server: J 2 EE Compliant (Weblogic/Websphere/Ora cle 9 i. AS) § Database Server: Oracle § Productized Integration (XML) § Security (SSL, LDAP Integration, encrypted login) § Documentation Engine (XML/PDF) § XML Integration with Content § Workflow Support & Event Management § Reporting Tools (Business Objects) 9

Trade Export Modules Restricted Party Screening Export Documentation GLOBAL Web Orders AES CONTENT 10

Trade Export Business Process - ORACLE Oracle Apps Management Dynamics Order Entry Order Restricted Party Validation Order Holds License Determination Letter of Credit Screening Pick Slip Holds Restricted Party Validation License Determination Whse Pick Order Consolidation Scheduler Alerts Manufacture Warehouse Pick Complete Confirmation Documentation Decrement Lo. C Accounts Receivable Decrement License 11

Global Export Integration Points - ORACLE EXPORTER Oracle Apps Trade Export 1 Customers 1 RPS / Embargo Screening 2 Products 2 Classification/ Import Controls 3 Sales Order 3 Export Screening / Lic Mgmt / LOC Mgmt 4 Deliveries / Shipments 4 Export Screening / Consolidation / Documentation G L O B A L C O N T E N T AES Output CUSTOMS 12

Trade Export Functionality • Workflow • Restricted Parties Screening • Event Management • Export Screening • Product Management and • Shipping Documentation Classification • Consolidation • Integration to Global Content • License Tracking • Recordkeeping (audit trail) • Letter of Credit Management • Reporting (Exception / • Customs AES / SED Filing Management) • Ad-hoc Reporting • Carrier Interface • Export Import Integration 13

QUESTIONS? © 2005 Management Dynamics Inc. Proprietary and Confidential Proprietary Confidential