Oil & Gas Industry Success
Oracle application implementations & upgrades
- A world leader in project management, engineering and construction for the energy industry: global Oracle E-Business Suite R12 upgrade
Oracle E-Business Suite
- Global, maintenance, repair & overhaul services provider:Implementation of ERP Cloud financials, procurement, HCM Cloud, Sales Cloud, Cloud Integration
Multi-pillar Oracle Cloud Applications:
Sales Cloud Read the full case study
- Industrial Services Contractor, the leading provider of speciality maintenance services to the US Energy sector: Multi-functional Oracle Cloud Implementation, including Oracle HCM Cloud, Payroll, Time & Labor and Oracle Talent Management Cloud.
Industry bespoke web-based applications
Case Study: Vessel and Crew Management
Requirement: An oil and gas services company required a system for managing vessels and crew for their global operations. The system had to integrate with existing E-Business Suite data and provide a way to maintain schedules of what each vessel was working on for the coming months, as well as deal with the associated, often complex, crew requirements. An interface was required to allow available crew to be assigned to vessels to meet the crew requirements and the system should then write timecards back to E-Business Suite to facilitate payroll processing.
Solution: Inoapps designed and built a web-based application in APEX integrated with the customer’s existing single sign on system (Oracle Access Manager) and with E-Business Suite. A series of administration pages were developed to allow the vessel schedules and crew requirements to be quickly and easily entered and maintained. The system included an intuitive, graphical interface that allowed the crew management team to easily establish the crew requirements for any vessel and date period and assign crew that fit the required compliance and availability criteria. Timecards are created via a daily job and pushed to E-Business Suite to generate accounting and payroll data.
Benefits: The system has led to significant efficiency improvements in the core business operations of the customer by reducing effort spent managing vessels, crew, timewriting and payroll. The security model employed has enabled sensitive company data to be processed while ensuring that authorisation and access protocols meet existing corporate guidelines. The system was delivered within strict budgetary and time constraints and has provided employees with a real-time single source of data, flexible administration tools, and a suite of customisable reports.
Client Quote:“It’s become an invaluable tool for the business, we now have the ability to efficiently forward plan and schedule the resourcing of the entire fleet in order to meet vessel and equipment utilisation.”
Case Study: Joint Venture Accounting
Requirement: An international energy firm required a finance system to manage a large and multifaceted joint venture project in the North Sea. The solution need to provide real-time transparency for all parties and forecast, report, allocate and recover cost across multiple countries and currencies to a minute level of detail.
Solution: Inoapps designed and implemented a web-based application built using Oracle Application Express (APEX) integrated with the customer’s finance applications. This gave all parties access to the same data up to 8 decimal places of detail in real time. The system was able to separate and allocate billable and non-billable costs quickly meaning clear, accurate billing and payment for the expenses and revenues of the project. The solution was also capable of managing changes in exchange rates and made multicurrency processing vastly simpler.
Benefits: The implementation of Inoapps’ Joint Venture Accounting system provided a highly efficient system which improved decision-making and transparency across the project, with a streamlined workflow and fewer errors. The system was a crucial component in a highly successful project which scaled enormously from requiring 8 employees to over 1000 in just 3 years.
Case Study: Manifesting
Requirement: A start-up oil and gas exploration and development company required a solution to enable them to efficiently manage the passage of assets through all stages of the transition of a major project.
Solution: Inoapps developed and deployed a manifesting solution, built using Oracle Application Express (APEX) that integrated fully with the customer’s ERP applications which allowed the project managers to have complete, real time information on their asset’s whereabouts. The solution was fully integrated with the Inventory and Purchasing module of Oracle E-Business Suite, meaning total control from acquisition to receipt on site.
Benefits: Due to the Manifesting solution, the customer was able to minimise downtime on the project and make huge cost savings through improved efficiency and planning. The solution played a crucial role in transforming this start-up company into the multibillion dollar business it is today.
Case Study: Business Intelligence Portal
Requirement: An oil and gas company had recently witnessed rapid growth through acquisitions and the senior management team wanted an instant view of company Key Performance Indicators in order to improve strategic decision making. Information also needed to be available to other company staff to ensure better communication and visibility of company performance. The main requirement was to provide visualisations of performance data from the hydrocarbon accountants and production system data so that the performance of reservoirs and installations could be monitored.
Solution: Data from various source systems was extracted and gathered in to a single Oracle database. An APEX application was developed with a series of sophisticated charts. Each chart can be customised to the needs of the user with various intuitive data filters. Different charts, graphs and views of the data were made available to different staff based on their role. Over 180 individual graphs, charts and data extract routines were delivered within tight timescales.
Benefits: All staff were now working from a common set of data and assumptions, improving corporate understanding throughout the company. There was a significant reduction in the amount of time staff spent “data handling”, allowing people to focus on their core job role. The data was presented in a clear, consistent and repeatable format that users were comfortable with. The system was developed in a way that required very low levels of ongoing future maintenance. A full BI platform was delivered within strict time, quality and cost restrictions.
Case Study: Forms Migration
Requirement: A global manufacturer of petrochemical and oil products had an existing data capture and management information system written in Oracle Forms and Reports. The requirement was to overcome various issues with the legacy system, mainly by providing a modern front end and allowing system updates to be done quickly in order to meet rapidly changing business requirements.
Solution: A robust and future proof system was rapidly developed in APEX that addressed the issues with the legacy system. The new system very quickly provided an intuitive and user friendly front end with flexible searching capabilities that allows users to easily find the data they need. The business rules and validations of the legacy forms and reports system were re-used in order to preserve the existing investment made by the company.
Benefits: The new system replaced the legacy system with a modern front end and greatly reduced the training time required for new staff to get up to speed. Future changes can now be done quickly and at a significantly reduced cost.
Please contact us below
+44 (0)870 112 2000
Inoapps Head Office
2 Fountainhall Road
+44 (0)870 112 2000
Oracle Corporation UK Ltd
+44 (0)870 112 200
5177 Richmond Avenue, Suite 1260
Suite 2B-13-3, Level 13, Block 2B,
Jalan Stesen Sentral 5,
50470 Kuala Lumpur.
+603 2714 5707