1 / 40

Oracle’s E-Business Suite of Applications [EBS] and Primavera Integration

Oracle’s E-Business Suite of Applications [EBS] and Primavera Integration. Mac Chouhan UKOUG Primavera Conference – 22 nd March 2011. Agenda …. Introduction Introduction to Thales Thales B1 Programme Oracle / Primavera Interfaces Q & A. Introduction ….

saleema-soroush
Download Presentation

Oracle’s E-Business Suite of Applications [EBS] and Primavera Integration

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Oracle’s E-Business Suite of Applications [EBS] and Primavera Integration Mac Chouhan UKOUG Primavera Conference – 22nd March 2011

  2. Agenda … • Introduction • Introduction to Thales • Thales B1 Programme • Oracle / Primavera Interfaces • Q & A

  3. Introduction … • This presentation will provide how the ‘B-One Primavera Rollout’ within Thales was established and the benefits and Return on Investment [ROI] it brings with it • The integration of Oracle’s E-Business Suite of Applications [EBS] and Primavera Integration Architecture brings together a true Enterprise Solution: B-ONE • Thales Core Model showing the various Interfaces between Oracle EBS and Primavera

  4. A technology leader providing safety and security • A global company with 68,000 employees and €12.9 billion in revenues • We help our customers to: • Provide reliable and secure solutions • Monitor and control • Protect and defend • In two major sectors Aerospace and Transport 40% Defence and Security 60% Thales: a reliable, long-term partner with operations in 50 countries

  5. Defence and Security • Defence • Serving all branches of the armed forces • Air, Land, Naval and Joint operations • Security • Serving governments, institutional customers and civil operators Interoperable, scalable solutions and services focused on operational requirements A comprehensive approach to national security and citizen protection

  6. Aerospace and Transport • Aerospace • Serving aircraft manufacturers, airlines and civil aviation authorities • Space • A major player through Thales Alenia Space • Serving satellite operators, space agenciesand defence customers • Transport • Helping to optimise use of rail and road infrastructures Presence on all types of civil and military aircraftand all major new aircraft programmes Central role on the major civil and military programmes Driving improvements in traveller safety and ground transport efficiency

  7. A Global Player 68,000employees in 50countries Global reach, local expertise

  8. Thales Oracle Practice • Oracle partner since 1998 • Certified Partner • Accelerate Partner • Engaged on Thales Global B1 Project • History of Worldwide Oracle Implementationsacross all Business types

  9. What is B1…? • B1 is … • a multinational programme being introduced in the UK, Spain, The Netherlands, France…. More to Follow • aimed at enabling greater efficiency and productivity through the convergence of business process • 2000+ B1 users now benefit from a process centric business toolset that promotes collaboration and continuous improvement • replaces all existing ERPs (Enterprise Resource Planning systems) with a powerful single technology platform across all Thales Group activities • A global business transformation programme, not an IT initiative • Primavera provides key data inputs in to IBP (Integrated Business Planning)

  10. Clearing & Netting System Solution Architecture Component PDM Timesheet Information ' System Export Control DCC (TUS Only) TCIS OTL Local Export Systems Corporate Purchasing Planning & Resource Management Thalsis Primavera MS & C / Customer Purchasing Manufacturing Programme Support Controlling BI / Data Buyerless Warehouse Purchasing ( All Domains ) Cognos SPAG Banking Accounting / General Controlling BACS Human Resources & Payroll Key Scanning Clearing Travel Corporate · & & Reporting OCM Scope System · Netting Expenses Country application · Group application Local Scanning Northgate Marco Polo Magnitude System IMSCAN th 17 April 2008

  11. B1 - Realising the Power of ‘One’ within Thales B1 is a key enabler of the group’s transformation plans To deliver greater efficiency and productivity Implementation of common business processes and systems throughout the group One Set of Systems One Mobile Workforce OneWay of Working OneApproach to Information Using Oracle Core Model Enhanced Staff Mobility Improved Quality of Service Greater Speed and Accuracy Lower Costs

  12. Background – Primavera … • Primavera ? • All During 2004, Thales synthesized all its Divisions’ programme management processes on the basis of existing methodologies within the Group and international standards. • To support this process, a tool was chosen… Primavera, which is … • a standard market tool widely utilised worldwide • particularly within companies functioning in Project mode • Its parameters are based on accepted business management processes • Acceptance: • First, functional and technical experts accepted Primavera together with its parameters before testing and validating it on pilot schemes • Decided at Group level to utilise this tool and its associated processes within the Divisions

  13. Objective – Process supported by a tool… • Because Programmes are the whole point of reason for our business, the Thales objective is to improve • Anticipation & forecast accuracy • Transparency • Data consistency • The Thales worldwide deployment of Primavera is at the same time • A more demanding application, but also more virtuous, of our process of Program Management • A set of cultural changes • And finally, a tool in the service of the Programme Management • Use of a Thales “Primavera Core Model”

  14. THALES PM PROCESS PRIMAVERA THALES CORE MODEL LAYER PRIMAVERA Why a core model ? • secured fields • set of standard codes • configured layouts • additional tools / functions • data history • simulation • capability to capture “validated” programme situations • Additional reports • Excel • Cognos (finance – workload) • Interface with our BO • cultural changes A need to standardize across regions / entities …

  15. Keep in mind that … • Before looking at the PM process, keep in mind that • Primavera stores all our data in a centralised & shared database • Any modification – at any level - is immediately recorded in the database • With limited undo capabilities • The current situation of our programmes is a “live” one (any change immediately affects the milestones, the cost at completion, the workload, …etc …..)

  16. Disjointed situation No consistent view of schedule, workload and costs Excel … Programme Management tool Costs Artemis P3 MSP Excel … Integrated resource schedule Excel … Schedule(s) Workload Costs Workload Why a Programme Management Process and Tool …Background • An integrated Programme Management process for schedule, workload and costs Target situation

  17. Scope of the Programme Management tool • All the programmes shall be managed within the Programme Management tool. • The functionalities to be used depend on the programme complexity as a minimum: start date – end date, workload, budget, costs • Workload forecast for the unit will be provided by Primavera and shall include: • Business opportunities, Current programmes, Other budgeted activities (PV, bids, warranties) • Primavera is built to meet both Programme Management and Finance needs • The Programme Management tool is the Master for the programme structure • The ERP is the master for actual costs • Every work package has its corresponding cost point in the ERP • EAC are transferred from the PM tool to the ERP • The Contract budget base is under the responsibility of the Programme Manager

  18. Interfaces – B1 UK Time Sheet Cost Points Time sheet at cost point level ERP PM tool HierarchyOrganisation / Cost Centre ResourcesEmployees/Non Labour/Rates ProgrammeHeader ID/Budget/Responsibility WBSCA / WPs’ CostEmployee & Non Labour plusSummary Commitments At Cost point level - Labour Hours - Labour Costs To Date - Labour Period Costs- NonLabour Period Costs Commitment Detailed PO info / Profiled ETC PM EACProgramme Level Business Organisation Hierarchy and Resource (Labour and Non Labour) to Primavera with various attributes Programmes are created in the BO and transferred into Primavera if Status <<Approved>> Full WBS is created in Primavera [Master]. Only key elements “CA” and “WP” are sent to the BO Timesheet captures Hours at Cost Point level (Manufacturing WIP booking direct into BO) Actual costs (both labour and non labour) are transferred from the BO to Primavera at cost point level – WP Actual labour quantity (hours) also transferred at WP level Detail Commitments information by WP – summary only. Next version direct into ETC as profile per PO dates Global EAC (PMB + MR) at Programme level is transferred from Primavera to the BO

  19. Screenshots – Hierarchy… • Hierarchy in Oracle …

  20. Screenshots – Hierarchy… • Hierarchy Interfaced into Primavera OBS View …

  21. Screenshots – Resources… • Csv output …

  22. Screenshots – Resources… • Resources Interfaced into Primavera Resources View …

  23. Screenshots – Programme… • Oracle Projects …

  24. Screenshots – Programme… • Csv output … • Primavera End Log file

  25. Screenshots – Programme… • Programme Interfaced into Primavera Projects View…

  26. Screenshots – WBS… • WBS created in Primavera …

  27. Screenshots – WBS… • Sending WBS to Oracle …

  28. Screenshots – WBS… • WBS InterfaceLog … • Csv output …

  29. Screenshots – WBS… • WBS Interfaced into Oracle …

  30. Screenshots – Actual Costs… • Costs in‘Oracle Time & Labour’ …

  31. Screenshots – Actual Costs… • Oracle Csvoutput … • Costs InterfaceLog File …

  32. Screenshots – WBS… • Costs in Primavera …Activities View

  33. Screenshots – Actual Costs in … • … Projects View… • … WBS View …

  34. Screenshots – PMEAC … • PMEAC …

  35. Screenshots – PMEAC… • PMEAC Log File … • PMEAC Csv

  36. Screenshots – PMEAC… • PMEAC Interfaced to Oracle Projects …

  37. Oracle – Primavera Interface Timings • Frequency and timings of each interface are: • Cost interface run at month end when month end processing complete Scheduled to run overnight • Log Files • log files generated for each interface and emailed to Business Super Users • Nominated key users validate and respond back to users

  38. EAC transfer towards ERP. PMV Dashboard updating. Possible schedule update (without to change the Data Date) Actuals and Commitments transfer to PMV. ETC update  ! ! End of month N updating. ~ 2 weeks Data Date 1st month N Data Date 1st month N+1 The « update session » as currently practiced on programmes – and appears as a very efficient process. The programme team meets around the “live” Primavera schedule and updates it while discussing the issues. Typical duration is ½ to 1 day – depending on the programme size. Baselines creation (Current Situation) Selection / Type baselines change, for creation of Financial Baselines Monthly Update Process

  39. Other Interface / Tools … • Other Interfaces and Tools • Resource Rate Inflation • A specific resource rate inflation tool to manage inflation rate for labour resources • PM Tools • Tools to aid reporting cycle • Checks Project data compliance to Standard Planning Practices • Automates Primavera Summarisation, Baseline creation for PMBI Reporting • WBS Loader • Load any ERP WBS’s into Primavera • Used for Data / Cost Migration …

  40. Questions …? THANK YOU … Mac Chouhan Primavera Functional Consultant Mac.chouhan@uk.thalesgroup.com

More Related