Transportation & Global Trade Product Development Update

2. Transportation & Global Trade Product Development Update Jim Mooney Vice President, Logistics Development March 2014

3. Agenda • Oracle Survey • Release Update • Key Functional Initiatives • Rollup Features • Technology Topics • Q&A

4. Oracle Logistics Survey

5. Oracle Logistics Survey Company information e.g. Which version is in production? Client satisfaction e.g. Ease of install & upgrade e.g. Integration Capabilities Participant Information Don’t forget the business card 

6. Release Update

7. Product Innovation 15 releases in past 8.5 years LCC, Mobile Apps, Customs Fleet Management Transportation Cooperative Routing 6.3 5.5 5.5.3 6.0 6.1 Transportation Business Intelligence Global Trade Management

8. Product Innovation Pipeline of New Capabilities ≤ 1 year Current GA release 6.3.4 6.3.5 6.4 6.3.3 ≤ 1 year >1 year

9. 6.3 Rollups Released every 4 months Able to patch against specific Rollups Include more robust enhancements: Incremental DB additions Incremental XML additions Property / Parameter controlled enhanced functionality Improved upgrade experience Due to more focus on incremental controls – if current Working on reducing downtime for Rollups – if current

10. While we will have the ability to patch back: Backports of bugs will still be on an exception basis No backports of enhancements Same advice from Development: Stay Current! No official line on Rollup age, but similar to current approach we will not be able to patch back too many Rollups – they age! Likely no longer than 1 year (match other Oracle products) This will likely be the same approach we will follow with 6.4 Rollups and beyond. 6.3 Rollups

11. OTM/GTM Lifetime Support Policy

12. Key Functional Initiatives

13. In-Memory Logistics Command Center • What-If Planning & Simulations • Network disruptions (e.g., closed ports) • Freight cost changes (e.g., fuel charges) • Service provider changes • Network design (e.g., new cross-dock) • Sustainability impacts • Capacity forecasting • Sensitivity analysis • Optimization parameter tuning • Use Cases

14. Multi-Tier Networks • New multi-tier network optimization algorithm • OTM automatically discovers all network routing options • Improved solution quality & performance • E.g., unlimited number of cross-dock / pooling options

15. Ship Unit Optimization • Load Configuration algorithm was extended to become a generalized Packing Algorithm • Used to pack ship units into equipment (existing OTM functionality) • Now also used to pack order lines into Ship Units

16. Ship Unit Optimization Mode Selection Example Option 2 Scenario Option 1 • Create multiple ship units for the order release • Ship each ship unit individually via small parcel at a cost of $22/carton • Total small parcel cost = $88 • Create one pallet (one ship unit) representing the entire order release • Ship via LTL at a cost of $95 • Order Release sent to OTM with four packaged items • Each packaged item weighs 40lbs. • Mode is unknown when Order Release is created

17. Oracle Global Trade Management 6.3 Product Features by Module Red = New in GTM 6.3

18. Rollup Features

19. User Interface Enhancements • Header Information on Every Tab • Reference Number Hyperlinks on Track & Trace • Enable Hyperlinks on Lookup Pages • Add SELECT ALL/NONE boxes to: • Finder Results • Manager Results • Flex field Pick and Drop Lists • Advanced Layout 19

20. User Interface EnhancementsHeader Information on Every Tab Enhancement • Manager Layout has a new Header Fields section • Select up to four fields • Fields from parent table only • Supports translation 20

21. User Interface EnhancementsHeader Information on Every Tab Enhancement • Fields have been added to PUBLIC manager layouts • Default headers added for: • Shipment, Order Release, Freight Forwarding, Order Base, Quote, Location, Invoice/Bill 21

22. User Interface EnhancementsReference Number Hyperlinks on Track & Trace Background 22 • Track and Trace Screen • Used to present a unified view of an order and all related buy/sell shipments, reference numbers and shipment event messages • Shipment manager allows user to view reference numbers as a hyperlink • This is accomplished by setting a property: • glog.webserver.refnum.link.REFNUM_GID=http://server_name?argument={0} • Example: glog.webserver.refnum.link.FEDEX=http://www.fedex.com?tracking_number={0}

23. User Interface EnhancementsReference Number Hyperlinks on Track & Trace Enhancement • This has been added to the Track & Trace screens, available through SmartLinks via the following objects: • Order Release, Shipment, and Shipment Group 23

24. User Interface EnhancementsEnable Hyperlinks on Lookup Pages Enhancement 24

25. User Interface EnhancementsAdd SELECT ALL/NONE: Finder Results Enhancement 25

26. User Interface EnhancementsAdd SELECT ALL/NONE: Manager Results - Enhancement 26

27. Flex FieldsSetup and Process • Example Shipment with 5 Flex Fields PickList DropList FixedDropList FlexPickList FlexDropList 27

28. Advanced Layout in OTM

29. Reporting Enhancements • Accommodate Daylight Savings Time when Scheduling Reports • Modify Existing Scheduled Reports • Save Reports in an XLSX Format • Default Operators in Reports • Relative dates and times on Reports 29

30. Reporting EnhancementsAccommodate Daylight Savings Time when Scheduling Reports and Recurring Processes • Reports and processes are scheduled to run at the same time each day • Twice/year these must be rescheduled to compensate for DST • OTM should be able to adjust automatically for this condition 30

31. Reporting EnhancementsModify Existing Scheduled Reports • Previously, scheduled reports were not editable. Once scheduled, you could not change parameters, email addresses, make additions/deletions/etc. • Required user to delete and reschedule report • Updated UI to see existing reports, modify & save 31

32. Reporting EnhancementsSave Reports in an XLSX Format • Provided Excel 2007 format. • Generates reports with .xlsx extension • Reports with .xlsx format are much smaller • Pure binary spread sheets • Supported only for external report generation • Not Supported for embedded report generation • Certified for BI Publisher 11.1.1 32

33. Reporting EnhancementsDefault Operators in Reports • When configuring reports, often need to specify default query operators. • Now possible with the new DEFAULT OPERATOR drop-down • Business Process Automation > Power Data > Document Generation > Reports 33

34. Reporting EnhancementsRelative Dates and Times on Reports • Provides additional flexibility to time and date queries • Two new values: • Range To/From Today: accepts +/- integer relative to today’s date • Relative Hours: two fields, accepts integers relative to current time 34

35. Technology Topics

36. Promote to Production

37. ROD and FTI

38. OTM and Disaster Recovery Typical DataGuard DR • OTM Options: • Consider using DR as a test site • GoldenGate is also certified • All data kept in DB • Code only changes by admin

39. Security in OTM – Best Practices Guide • Install only what is required. • Remove unnecessary default user accounts. • Enable data dictionary protection. • Practice the principle of least privilege. a. Grant necessary privileges only. b. Revoke unnecessary privileges from the PUBLIC user group. c. Restrict permissions on run-time facilities. • Enforce access controls effectively and authenticate clients stringently. • Restrict network access. a. Use a firewall. b. Never poke a hole through a firewall. c. Monitor listener activity. d. Monitor who accesses your systems. • Check network IP addresses. • Encrypt network traffic. • Harden the operating system. • Apply all security patches and workarounds.

40. Q&A

41. Question #1 We can’t take every Rollup, otherwise we would spend all our time testing. What is Oracle’s recommendation? Rollups are cumulative, so skipping a Rollup is fine (however, you may need to apply newer patches). Develop an approach – every 6, 12, 18 months and stick to it. If you plan to use new functionality, or continue rollouts to new businesses or geographies, then you should stay as current as possible.

42. Question #2 From where does the Development / Strategy team get their European requirements? Many places – from experience of developing TMS systems for 25+ years, from working directly with customers over the years – UPM, DHL, Ikea, Ahold, and also from our sales and consulting partners working with customers and providing us feedback.

43. Safe Harbor Statement • The preceding is intended to outline our general product direction. It is intended for information purposes only, and may not be incorporated into any contract. It is not a commitment to deliver any material, code, or functionality, and should not be relied upon in making purchasing decisions. The development, release, and timing of any features or functionality described for Oracle’s products remains at the sole discretion of Oracle.

44. Q&A