1 / 32

Custom Extensions of Oracle E-Business Suite

Andrew Archibald/Lindsay Smith Scottish OUG 2012 Linlithgow 13 th June 2012. Custom Extensions of Oracle E-Business Suite . Custom Extensions of Oracle E-Business Suite R12 Realizing your ERP's full power. AGENDA. Introduction Cairn Rocela Extending E Business Suite

ulfah
Download Presentation

Custom Extensions of Oracle E-Business Suite

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. Andrew Archibald/Lindsay Smith Scottish OUG 2012 Linlithgow 13thJune 2012 Custom Extensions of Oracle E-Business Suite

  2. Custom Extensions of Oracle E-Business Suite R12 Realizing your ERP's full power.

  3. AGENDA • Introduction • Cairn • Rocela • Extending E Business Suite Joint Venture Accounting Travel Form • Questions

  4. Presenters Lindsay Smith Oracle E-Business Senior Analyst Cairn Energy Andrew Archibald Senior Consultant Rocela

  5. Cairn Energy

  6. Cairn Energy FTSE 250 listed (FTSE 100 until recent return of $3.5bn to shareholders) One of Europe's largest Oil and Gas exploration and development companies Based in Edinburgh, approx 150 employees with another 30 in overseas offices Varied portfolio with interests in Greenland, North West Europe & Greater Mediterranean Currently looking to expand the portfolio

  7. Cairn Energy Recently upgraded E Business Suite to R12.1.3 from 11.5.10.2 Ebusiness: Payables/Purchasing/Projects/GL/HR modules Team of 4: Oracle SDM, 3 analysts. External support provided by Rocela

  8. Cairn Energy 4 APEX Applications running in Production First Application in Production 15 Months ago. Implementation of Joint Venture Accounting application in progress

  9. Rocela • Independent Oracle Consultancy and Microsoft Consultancy • Headquartered in Edinburgh with offices in Knutsford. • Oracle Certified Advantage Partner

  10. Rocela Provides Oracle License Optimisation Managed Services Professional services consultancy

  11. Extending E Business Suite

  12. Tools to build extensions OAF (Oracle Applications Framework) Oracle APEX (Application Express) Oracle ADF (Application Development Framework) Oracle E-Business Suite SDK for Java Reference – support.oracle.com white paper : 1435894.1 (Upgrading your Customizations to Oracle E-Business Suite Release 12.1)

  13. Oracle APEX The Tool of Choice

  14. Custom Extensions • Built using Oracle APEX (Application Express) • Easy Integration with E business

  15. Custom Extensions Cairn have 5 APEX applications extending EBS. Joint Venture Accounting (currently under development) Travel Form Flexi Time Summary Well Cost Tracking P2P Dashboard

  16. Architecture 11.2.2 DB Forms Server Web Server Web Logic APEX Listener Discoverer

  17. Joint Venture Accounting (JVAcc)

  18. Joint Venture Accounting (JVAcc) The Problem: Oracle Projects/GL used to account and report for Joint Venture assets – Greenland/Albania etc A need to decouple Joint Venture Accounting from Supply Chain process

  19. Joint Venture Accounting (JVAcc) Proposed Solution:

  20. The Solution • APEX Application • Search screens allow for allocation of data • Validation of data • Transfer to GL Interface

  21. The Integration Points • AP, Cost Management, Project and GL Data Pull • GL Interface population and GL Import • Concurrent Requests

  22. The Issues • End - User • Data not matching Oracle • Search query performance • Posting to Corporate – rounding Developer • Sub Ledger Accounting • Split import to GL tables

  23. Development Time Project started in Nov-11 Work stopped for 2 – 3 months during the R12 upgrade Testing now resumed Estimated go live date – Sep 2012

  24. JV Accounting Application Demonstration

  25. Travel Lookup Form

  26. The Problem New Corporate Travel agency selected Opportunity to streamline travel booking service to prevent having to raise a Requisition/PO for every individual travel request All travel, even within policy, must be approved

  27. The Solution • Apex form completed by administrator • Administrator to complete details of Travel • On submission, email sent to Budget holder requesting approval to travel • Form to replicate iPROC coding customisation i.e. only specific Project/Task/Expenditure Types available

  28. Development Time • 7 Days Development Time • 2 Days User Testing

  29. Travel Lookup Form Demonstration

  30. Thank You

  31. Questions? Andrew.Archibald@rocela.com

More Related