Rescue Service for a Complex Oracle Financials Re-Implementation Project

The Client

Commercial Client

For this Oracle project, our client needed maintenance, enhancement, and troubleshooting support for their corporate-wide financial, human resources, and manufacturing applications. These applications included the 11.5.10 release of Oracle General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Fixed Assets, Project Accounting, Inventory, Order Management, and Human Resources.

In addition, they required several extensions of application functionality, development of custom interfaces and technical support in their efforts to integrate a large division of a company which they acquired in 2010. This acquisition, which doubled the size of the company from 2,000 to 4,000 employees, required the conversion and integration of data and business processes from an SAP-based ERP system to an Oracle ERP system.

The Technology

Oracle Financials Version: 11.5.10

  • General Ledger
  • Accounts Payable
  • Accounts Receivable
  • Purchasing
  • Fixed Assets
  • Project Accounting
  • Inventory
  • Order Management
  • Human Resources

The Challenge

For this Oracle project, our client needed maintenance, enhancement, and troubleshooting support for their corporate-wide financial, human resources, and manufacturing applications. These applications included the 11.5.10 release of Oracle General Ledger, Accounts Payable, Accounts Receivable, Purchasing, Fixed Assets, Project Accounting, Inventory, Order Management, and Human Resources.

In addition, they required several extensions of application functionality, development of custom interfaces and technical support in their efforts to integrate a large division of a company which they acquired in 2010. This acquisition, which doubled the size of the company from 2,000 to 4,000 employees, required the conversion and integration of data and business processes from an SAP-based ERP system to an Oracle ERP system.

The Solution

As part of this project, the TSGi team developed several custom extensions to the standard Oracle functionality. Foremost among these extensions was an Accounts Receivable Revenue Recognition program. This program was created to automate the manual Revenue Recognition process performed by the Financial Users in Excel Spreadsheets. Our team developed the extension in 11.5.6 and was responsible for upgrading the process in 11.5.10.

As part of our deliverables, we also developed several processes to interface data in both directions between the Oracle ERP system and a Hyperion reporting application. Among these processes were:

  • An interface to load Quarterly Budget data into Oracle using data files extracted from Hyperion.
  • Several interfaces to extract critical business process information from the Oracle applications for upload to Hyperion. Reports produced from this information are used on a daily, weekly and monthly basis to manage the company’s most important functions, including inventory maintenance, revenue recognition, as well as budget and expense review.

The TSGi team also developed several custom enhancements to automate processes that were previously performed manually. These enhancements included:

  • The automated processing of vendor invoices via an Ariba interface.
  • The automated deposit of employee expense reimbursement payments via an ACH interface.
  • The automated maintenance of asset information in Oracle Assets via an Excel spreadsheet interface.
  • An automated interface of corporate and employee contribution data to the company’s 401k plan administrator.

The TSGI team also developed multiple new processes to support the integration of a company which was acquired. Among these new processes were:

  • An interface from the acquired company’s SAP-based GL system to our client’s Oracle General Ledger.
  • A new revenue recognition process to support additional inventory organizations created by the acquisition.
  • Several custom reports which were necessary to manage transactions across multiple operating units, currencies, and sets of books.

The Success

The client received immediate and measurable cost savings as well as improved data accuracy and reduced transaction processing timeframes. This implementation helped our client seamlessly handle transactions across multiple books, organizations, and currencies. It also helped them maintain full compliance with all aspects of the Sarbanes-Oxley Act of 2002.

In addition, the corporate acquisition was executed successfully. The business processes of the acquired company were integrated into our client’s Oracle ERP system on schedule and within the project budget.


Download this case study


Leave a Reply

Your email address will not be published. Required fields are marked *