Leveraging OAF to Migrate a Legacy EBS Application

Our client, a Department of Labor agency, was saddled with the challenge to figure out a way to upgrade the front-end user-interface of an application, which was developed using Oracle ADF, while trying to maintain the functionality of the middleware so as to minimize the cost. See how our senior Oracle EBS technical developer worked on a compressed schedule to successfully migrate the front-end of the legacy application to OAF and thereby help the agency save time, money and effort while ensuring that the full functionality of the application was available to its user base.


TSGi Supports Oracle Fusion Implementation

One of the fastest growing retailers on the East Coast recently deployed an ERP cloud-based Oracle Fusion solution. Our client wanted a state of the art solution to support its accounting and finance backbone to assist in their fast-paced organic growth and multiple acquisitions. This new system is responsible for back-office services, with Financials and Fixed Assets centered on the General Ledger. This is a single Organization, single currency implementation handling several thousand transactions a month.

The main challenge for this project is to meet the requirements of multi-dimensional reporting. The firm’s management challenged the team to produce the standard financial reports (Profit and Loss, Income Statement, Budget vs. Actual, etc.) in the most flexible way possible, and in a manner that offers consistency across the reports even when run at different times.

The Squires Group team delivered a solution to the challenge by implementing extracts out of Oracle Fusion into multi-dimensional database EssBase, with a focus on pre-defined General Ledger hierarchies. Once properly configured with EssBase Studio, the scheduled extracts provided the baseline data necessary for the various reports.


Supporting the Roll Out of an Oracle EBS R12 Shared Services Model

A Federal Civilian Agency’s business center was set up as a Federal Shared Services Provider. In September 2014, this Federal Agency was awarded a contract to on-board multiple Department of Homeland Security (DHS) agencies into their shared Oracle Applications Solution. The first three agencies are scheduled to be on-boarded in a staggered release, over the course of three years.

The main challenge of this project is to meet the client requirements with existing features of the standard Application to the largest extent possible, and avoid the path of “customizations” wherever practical. Avoiding a large scope of customization pays off over time as patches can be applied more readily, vendor support can be leveraged more effectively and upgrades will then be more technical in nature and therefore run more smoothly.

To overcome the challenge, the Prime Integrator for this project turned to The Squires Group, Inc. (TSGi) to deliver a local team of Oracle experts with the knowledge and skills that would be capable of leading all tasks in multiple functional areas.


Expert ERP Resources Building Oracle’s Highest Volume Transaction System

We delivered a proven team of Oracle experts to help develop Oracle’s highest volume transaction system in the world. This project team is comprised of both senior functional and technical resources with expertise in Oracle Federal Financials—all delivered locally from the Mid-Atlantic region which helped the client reduce travel costs associated with a large consulting team. At its peak, we had over 30 consultants that were participating in all aspects of the functional and technical solution.


Expert Professionals Conduct 11.5.10 Training

Our client was implementing Oracle Financials version 11.5.10. The modules being implemented included General Ledger, Accounts Receivable, Accounts Payable, Purchasing, and Budgeting. They were looking for an organization well versed in Oracle applications training as they required training documentation and organized training classes to be conducted across the United States.

Due to our proven ERP experience, we were brought in to provide valuable Oracle Applications training and documentation to end-users as part of the implementation rollout plan.


Rescue Service for a Complex Oracle Financials Re-Implementation Project

A long-term client recently turned to us for troubleshooting support for the re-release of their 11.5.10 Oracle GL, AP, AR, PO, FA, PA, INV, OM and HR modules. This complex project required the services of our most senior Oracle technical team.

Because of our team’s contribution, our 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.


Automated Set-Up Process Accelerates Go-Live, Improves Data Integrity and Reduces Costs

Our team developed a process for automating the Oracle Financials set-ups for new CMS contractors that needed to Go-Live within the CMS HIGLAS shared system. This automated set-up routine was developed using Mercury QTP and worked across multiple Oracle Financial Modules. Not only has this automation process improved data integrity while saving hundreds of man-hours of manual data entry routines, it has also resulted in significant budget savings.


Automated Regression Testing Accelerates Quarterly Releases

Frequent feature upgrades and releases necessitated many cycles of regression testing. To speed up the regression testing phase and increase testing productivity, the client required to automate the regression testing process completely. The main challenge was to evolve a robust test strategy/approach that would maximize the benefit from automation. In addition, the team needed to create maintainable scripts taking into account the interrelated functionality and the fact that the application was stable and data intensive.

Our team developed a Test Automation Framework which improved the speed of the regression testing phase for this federal client. This effort also increased testing productivity which allowed the ongoing Oracle Financials Quarterly Release enhancements to be placed into production in advance of scheduled dates.


Oracle 11i Federal Financials Training Delivered to Multi-Site Users in Record Time

Our client was implementing Oracle Federal Financials in the following modules Accounts Payable, Accounts Receivable, Benefits, Federal Administration, General Ledger, and Purchasing. They needed support to train users on the new program. Our client required further documentation capabilities through the creation of multiple output formats from a single recording session of a procedure. These include a customized context-sensitive help (Player) package linked directly to the Oracle application, a set of procedural job aids (Tip Sheets), and role-specific OLT courses through a set of Learning Management System (LMS) packages. These OLT courses were linked to 1100 learning plans through the client’s LMS (GeoLearning).

With an impossibly short deadline, our team of expert Oracle trainers utilized UPK OnDemand to develop a mix of classroom and online training material for a large federal agency. This training program was delivered to hundreds of users across multiple geographies and has received many departmental accolades.


Oracle Optimization Project leads to Ongoing Support and Maintenance

This project involved optimizing and enhancing the implementation of an Oracle Financials application for our Public Sector client. Modules included General Ledger and Accounts Payable at the 11.5.8 release level.

Our client initially called upon us to optimize their recently implemented Oracle Financials system which was underperforming. After working with our team of functional and technical experts, we were able to improve performance time and reporting data accuracy which allowed this client to comply with multiple Sarbanes Oxley requirements. Today we are responsible for all technical support for this client’s Oracle Financial applications.