Custom EBS Data Transformation

Oracle has told you that the only way to solve your problem is to reimplement.

Problem

Over time, businesses undergo major changes — reorganizations, mergers, or divestitures. They develop new lines of business, set up global operations, or work in different ways to comply with new statutory and regulatory requirements. Similar to many of the companies that use our software, this global security software company was always going through major changes. They had acquired several smaller companies, sold about 15 different divisions, and in general, didn’t have the same business as they did when they implemented Oracle E- Business Suite 12 years ago. The problem is that as their business changed, their EBS was stagnant. In order to keep up with the changes, the security software company maintained thousands of spreadsheets, implemented a data warehouse, and used a middleware product to integrate a variety of systems. There were literally hundreds of people trying to determine what parts of their business were profitable.

View Solution...

You need to reduce your budget by more than 20% and are looking for ways to save money.

Problem

A large automotive company was in financial trouble, and received a bail-out from the US Government. One of the terms of the bail-out agreement was that they reduce spending by at least 20%. Over the years, the company had grown, by acquiring other, smaller companies, but the acquisitions had never become fully integrated, even though they were all using the Oracle E-Business Suite.

View Solution...

You need to change your E-Business Suite calendar.

Problem

A pharmaceutical company has been acquired. The old company used a fiscal 4-4-5 calendar (so period 1 ended on January 28) and the new parent company uses a monthly calendar (with period 1 ending on January 31).

Using eprentise Reorganization software's Calendar Change module, the acquired company changed the start and end dates of each of their GL periods. eprentise created unposted journal entries to add all the transactions from January 29-31 to period 1 and subtract them from period 2. It did the same for all the periods in the year. After changing the start and end dates for the GL periods, they used eprentise to synchronize the Fixed Assets calendar, the project accounting calendar, and the inventory calendar to the GL calendar. Everything tied out to the penny with the new calendar.

You need to create different subsets of data for testing.

Problem

A large internet book supplier had a very rigorous testing and QA process. Whenever a change was made in their E-Business Suite, one team tested open transactions across modules, other teams tested within a single module, and still other teams tested a full business process cycle such as purchase to pay. The test teams were constantly required to create new test instances that met different criteria. The book supplier’s database was quite large and developing complete clones for testing took a long time and made the test cycles very long and the testing very cumbersome. At any point in time, the company maintained more than 300 different test environments.

View Solution...

You are selling a part of your business and need to separate out the related data.

Problem

A large entertainment company is selling their “Stores” division to another company. They don’t want the new company to be able to see the proprietary data from the other segments of the business, that aren’t being sold.

Solution

Using eprentise Divestiture software, the company created a filter rule to separate and delete data from the accounting flexfield in the Oracle E-Business Suite. Once the rule was created, they quickly and easily ran a report to show what data met the criteria set out in the rule. They then deleted all transactions not related to the “Stores” division.

The eprentise method maintained all relational integrity and adjusted all totals to reflect the deleted transactions.