default logo

Be More Agile – Respond to Business Changes Quickly and Accurately with eprentise Software for Oracle EBS

Executive1Identify business change, such as consolidation, reorganization or standardization.

Executive2Our software automatically generates the code to copy, filter, change and merge the source data into the user-defined target data structure.

Executive3Result: Complete, consistent and correct data – in a shorter amount of time.

With eprentise software, enterprise applications take on a new value because they now can be used to develop a strategy to undertake major changes like mergers, acquisitions or divestitures. With a global view of the organization, executives like yourself will have access to complete, consistent and correct information whenever you need it.

  • With eprentise software, you can make an elephant agile by changing rigid Oracle E-Business Suite structures and configurations. You can quickly consolidate EBS instances if you do a merger or acquisition, you can separate data for a divestiture, and you can make changes to any of the structures that your team set up when they did the initial implementation. eprentise software was designed to give your organization the agility to change. It was designed to allow you to get the most out of your E-Business Suite.
  • With eprentise software, enterprise applications take on a new value because they now can be used to develop a strategy to undertake major changes like a mergers, acquisitions, or divestitures. The enterprise applications, instead of being the barrier to change that they were, contribute to instituting strategic changes because they provide a global view of the organization, and executives like yourself have access to complete, consistent, and correct information whenever you need it.

    Benefits include:
    • Reduced operating costs and increases efficiencies.
    • Avoids a costly reimplementation.
    • Reduced complexity and control risk.
    • Improves business continuity, service quality and compliance.
    • Establishes data quality standards and a single source of truth.
  • FlexField software provides a low risk, low cost way to make rapid changes to the accounting flexfield.

    eprentise Consolidation software merges two or more database instances by automatically resolving database structures, data differences, and differences in business processes.

    eprentise Divestiture software facilitates the divestiture process by creating two separate Oracle E-Business Suite instances – one for the parent company and one for the divested company – while retaining all key information assets of each.

    eprentise Reorganization software allows companies to make a variety of major configuration changes to better reflect their business structure and operations in their Oracle E-Business Suite (EBS).
  • Avoid a Reimplementation

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


    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.


    At first, the company was told that their only choice was to reimplement their EBS. They were told that a reimplementation would take two years and about 50,000 hours of consultants. They didn’t like this option both because of the time involved and the costs. They were worried about the skill levels of the consultants, whether they would be able to accurately create what their future state would look like, and the project generally going over budget with the scope continually changing as the business changed. Instead, they decided to purchaseeprentise Reorganization software to reorganize their existing EBS, resolve duplicates, and as an ongoing solution to accommodate the ongoing changes of their business and the resulting underlying changes to the setup of the EBS environment. eprentise produces software that reliably enables organizations to adapt existing systems to meet ever-changing business conditions. At the heart of the eprentise solution is a rules-based engine containing actions (copy, merge, filter, and change) and built in integrity rules that can be combined to affect changes to a relational database environment. The eprentise software provides testable, repeatable, rules-driven results, without custom coding.

    By allowing applications to be changed to meet your changing needs, eprentise provides the ability to recognize the financial rewards of business and technology initiatives quickly and reliably.

    Break Down the Silos

    Each area of your business was set up differently, there is no sharing, and you need to break down the silos.


    A multinational corporation that has been in business 22 years had recently begun to notice that the systems behind its different business units kept track of the same information, but in different forms and formats, creating a large amount of duplicate data that was difficult and time-consuming to reconcile. In the early stages of the business, each line of business developed its own systems rather than adopting a large ERP system to drive the business as a whole. When E-Business Suite was finally adopted, each line of business implemented its own instance of the Suite, not considering that they were still duplicating the effort of tracking the same data and then having to weed through it for reporting purposes. Many third-party hardware systems were introduced in order to integrate the systems, but they found that the new hardware actually increased the time required to get the reports they needed. The company needed a way to increase communication between the systems and reduce the amount of duplicated efforts across the company.


    The company used eprentise Instance Consolidation software to consolidate all of its instances into a single instance that functioned on its own. During the process, duplicate data such as customers, vendors, employees, and products was eliminated, and the silos of information were broken down allowing different areas of the business to communicate seamlessly. The company was then able to get the reports its needed straight from E-Business Suite and was able to eliminate a large energy footprint in the form of integration systems.

    Consolidate Multiple Production Instances of EBS Into a Single Instance

    You want to go to a central data center and consolidate your Oracle E-Business Suites into a single instance.


    A manufacturing company had 7 different implementations of Oracle E-Business Suite. Each application instance was configured at the plant level and had different product numbers structure, and different business processes that were implemented in their application. They could not consolidate their inventory into a single warehouse because of the different structures. The customer wanted to standardize all products and consolidate the databases into a single data center. They determined that they would save maintenance costs and license fees by having a single global instance, resolve business process inconsistencies, and save operating expenses when all the data resided in a single data center. The instances and the set-up decisions from their initial implementations were not well documented.


    The company used eprentise Metadata Analysis to identify differences among the systems. After defining the target instance, the company used FlexField software to implement a single chart of accounts. Finally, the client used eprentise Consolidation software to identify and resolve configuration differences, other flexfield differences, and resolve duplicates across instances before merging all seven instances into the new target environment. They were able to quickly determine common customers, suppliers, and product lines so they were able to streamline their operations, understand their customers better, and leverage common business practices across the enterprise.

    Integrate Your E-Business Suite with an Acquired Suite

    You have just acquired a company who also uses Oracle E-Business Suite.


    A global manufacturing company running Oracle E-Business Suite recently acquired a smaller competitor who also uses OEBS. They needed to Standardize Oracle Financial and Manufacturing Applications from both companies so that they could operate as a single company. They needed to quickly identify the differences in data between systems, standardize and consolidate data from the merged company, determine common customers, suppliers, and product lines so duplicates can be resolved, and obtain an accurate view of current and future operating requirements.


    The company used eprentise Consolidation software to consolidate the two systems. eprentise Metadata Analysis generated a report listing all the differences in database objects and in the set-up data. The parent company’s E-Business Suite was identified as the target. After changing the chart of accounts and the calendar for the acquired company, the business users decided how the data was to be merged into the target. The company standardized all configuration data and resolved duplicates for all master data using eprentise Data Quality software. All transaction data from the acquired company was synchronized with the cleansed master data and moved into the target database. The history from both companies was preserved. There was no coding, and the instances were merged and went into production within 180 days of the acquisition.

    They identified the benefits as being able to operate as a combined entity quickly. They captured the economies of scope and scale and leveraged the combined information resources, reduced the cost of internal support services, and achieved process efficiencies and business synergies quickly.

    Inventory Consolidation

    You are acquiring a new plant and want to consolidate the inventory into your existing inventory.


    A manufacturing firm recently acquired a plant and needed to integrate the new inventory with its own. Not only did the inventoried products need to be added to the new system, but the historical data from the acquired plant was necessary in order to allow the acquiring company to continue to provide accurate forecasting data to management.


    The company used eprentise Reorganization software’s MSM Inventory Organizations module to consolidate their inventories into a single warehouse as well as to consolidate their inventory organizations. They were able to reduce their warehouse costs by 35% and their inventory costs by 25%.

    Reorganize Departments

    Your organization structure has changed, and you are continually reorganizing.


    A high-tech manufacturing company currently has 10 segments in their chart of accounts:

    • company – 3 digits
    • business unit – 3 digits
    • department – 4 digits
    • account – 3 digits
    • subdetail – 4 digits
    • intercompany – 3 digits
    • management company – 3 digits
    • product code – 4 digits
    • project code – 8 digits
    • marketing channel – 2 digits

    They do extensive reorganizations each quarter to accommodate department changes. There were two identified needs: a short-term change to ease the burden of the quarterly reorganizations, and a longer-term redesign of the Chart of Accounts. The reorganizations are caused when people (sometimes individually, and sometimes in groups) are moved from one department to another and all of their corresponding costs need to be changed to the new department. In the last reorg there were 819 department changes. These departmental reorganization changes generally take between 12-15 people about a month (not full time for anyone and a coordinator about 30-40% time).


    The company used FlexField software to reorganize the department numbers to represent a true cost center rather than an HR organization. They estimated that the change to the chart of accounts saves them almost $500,000 annually and they are able to close their quarter much faster.

    Sell a Part of Your Business


    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.


    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.

  • What is eprentise software?

    eprentise hd_suite is a family of functional modules used to manipulate the data in Oracle E- Business Suite (EBS) while maintaining consistent and correct data. For many solutions, it runs one time, propagating all changes throughout your existing EBS data and then is removed from the EBS instance. It gives you the ability to make changes to your EBS that used to be available only through a reimplementation.

    In what kind of situations would I use eprentise?

    Consider eprentise in situations like these:

    • A merger or acquisition where both parties run E-Business Suite.
    • The set-up of E-Business Suite is more than 3-5 years old and doesn’t support the business.
    • There are inconsistencies in different parts of the organization.
    • The business is supporting several different instances of E-Business Suite.
    • Business reorganization, shared service center, and IT consolidation scenarios.
    • The database is very large and different subsets of data are needed for testing.
    • There is a lot of duplicate data (suppliers, customers, products).
    • Divestiture or spin off of part of the business.

    This M&A scenario is an example.

    • Company A sells its Division M to a competitor, Company B. Both companies, A and B, run E-Business Suite. Company A runs eprentise Divestiture to split off a copy that contains all of Division M’s business (but none of A’s confidential information). Company A continues to run its main instance, which retains Division M history. It gives the new Division M instance to Company B.
    • Company B may choose to run Division M in a stand alone manner until the end of their fiscal year. The instance is functionally complete, consistent, and correct. One optional change would be to run our FlexField software to transform the Division M instance to use the Company B Chart Of Accounts (COA). That would make it easier to consolidate the financial reports between Company B’s main instance and Division M.
    • Next, Company B would run eprentise Consolidate to combine the Division M instance into its main instance. They would add all of Division M’s history and open business transactions, setups that define how Division M transactions work, plus other data like Division M’s customers, suppliers, and employees into Company B’s E-Business Suite instance.

    How much does an eprentise project cost? How long do the projects take?

    We suggest that our customers plan from one to six months for most projects, depending on the complexity. Consolidations are usually complex and will typically take between six months and a year. We welcome the chance to talk with you about the type of project you are contemplating. After a few discussions we will create a project profile which will include the estimates of the schedule, costs and required resources. It usually takes a few weeks of discussions and discovery for us to create and present a proposal.

    Who needs to be involved with installing and running eprentise?

    A DBA installs eprentise software and supervises the technical operations. The primary eprentise user is a senior business system analyst who runs the software.

    A DBA with system privileges makes a clone of the database and installs eprentise software. No special skills or new techniques are needed. The install can be completed in about a half day. The DBA may also create eprentise users and projects so that the correct privileges are assigned. A DBA may also be required to monitor performance, and adjust tablespaces or rollback segments as the data is manipulated. After running Metadata Analysis and analyzing the results, it usually takes a few days from start to finish for each transformation run.

    How do eprentise and FlexField software affect change management processes and systems for regulatory compliance (Sarbanes-Oxley)?

    When your change management people become familiar with how eprentise works and what the business users will “ask” it to do, then they should be able to determine how to set up change requests and approvals, and monitor or verify completed changes. All changes made by eprentise are thoroughly documented. If eprentise creates a journal entry, the new journal entry includes the original journal and a description of why the journal was created. The metadata analysis and configuration analysis provide an accurate “before” picture of the environment. They create reports all the way through the transformation process that show which data was selected for change and what changes were made.

  • “Show Me the Money: Reduce the Costs of Running Oracle EBS Before Upgrading to R12” (white paper)

    Show Me the Money - Reduce the Costs of Running ERP

    Download PDF Download Excel
    Reducing costs is the major strategic focus for most companies. An often-overlooked cost is the general operation of financial operations. This paper details a methodology for calculating the costs of running financial modules in ERP systems.

    The costs are compared against both internal and external benchmarks. After calculating the costs, the paper shows how to reduce costs in two ways: first, by eliminating work that is duplicated across different business units or divisions, and second by determining which operations that are currently distributed across the organization can be consolidated into a shared services center. Together these changes, both to the organization and the ERP system, can generate significant cost savings.

    The paper discusses how a $4 billion company using Oracle E-Business Suite (EBS) consolidated its distributed accounting departments, one for each European country, into a shared services organization supporting all European operations.  The cost savings realized and the streamlining of operations prepared for the organization for a major ERP software upgrade.

    eprentise E-Business Suite Cost Savings Calculator (Excel)

    eprentise E-Business Suite Cost Savings Calculator

    Download File
    Reducing costs is the major strategic focus for most companies. An often-overlooked cost is the general operation of financial operations. Also see the white paper “Show Me the Money: Reduce the Costs of Running Oracle EBS Before Upgrading to R12”.

    "Why Reimplement" (white paper)

    Why Reimplement - an eprentise White Paper

    Download PDF
    This white paper is for decision makers in organizations that run Oracle E-Business Suite 11i and are planning how to get to R12. The purpose is to show how reimplementation became a widely considered approach instead of upgrading, and to give EBS 11i customers a new perspective on upgrading.

    Most organizations will upgrade if possible, since that is the easiest path for enterprise software product upgrades. However, there are a number of factors, including the new Financials architecture and concerns about product quality, that have led many to decide to reimplement or to delay. With the introduction of eprentise software, you can eliminate obsolete fundamental setup configurations and multiple instances as reasons that lead organizations to select reimplementation. If you like what R12 offers and you want to save time, money, and resources on the transition, you can combine eprentise Transformation software with Oracle upgrade to upgrade EBS 11i instances to a single global instance of R12.

    The transition from 11i to R12 is a high-stakes major initiative for any E-Business Suite (EBS) customer. We have observed that companies plan the transition for approximately a year, then set budgets, line up resources, and do the work over one to two years. Projects may cost in the range of several million dollars to tens of millions and are often proportional to the size and complexity of the business.

    We believe E-Business Suite 11i customers can upgrade instead of reimplement, shorten the time-to-value at a lower cost, and provide a better R12 result for both the Business and IT. Why reimplement?

    Consolidation Datasheet (PDF)

    Consolidation Datasheet

    eprentise Consolidation software allows companies to merge two or more instances of Oracle E-Business Suite (EBS) into a single, consolidated database instance that includes all of the data and history from the source instances. eprentise software relies on its built-in knowledge base of EBS to provide a streamlined and cost-effective way to consolidate different instances after a merger or acquisition or a move to a centralized data center. eprentise Consolidation software automates the process and generates all of the required code to standardize data, resolve duplicates, align set-up parameters, and synchronize business processes across multiple implementations of EBS. The resulting single database is a synthesis of all the source EBS database instances, aligned to the current business strategy.


    Reorganization Datasheet (PDF)

    Reorganization Datasheet

    prentise Reorganization software allows companies to make a variety of major organizational changes to better reflect their business structure and operations in their Oracle E-Business Suite (EBS). Types of reorganizations include changing calendars, moving operating units from one set of books (ledger) to another, moving legal entities to a different set of books (ledger), and merging operating units.


  • I would definitely recommend the software and the company and have already done so. If the need arises for us to make any other changes this will be my first and only call.
    eprentise customer