default logo


Reorganization Software – Make Major Configuration Changes to Your Oracle EBS Quickly & Painlessly

Reorganization1You identify the needed configuration changes from a series of drop-down lists.

Reorganization2Our software “learns” all of the changes that will be required & generates the code.

Reorganization3Result: Seamless implementation and maintenance of all data & history.

Make major Oracle E-Business Suite configuration changes and maintain data history and integrity without reimplementation.

With our Reorganization software, you can easily:

  • Change calendars
  • Move operating units from one set of books (ledger) to another
  • Move legal entities to a different set of books (ledger)
  • Merge operating units, business groups, or inventory orgs

Our software automates the process and generates all of the code needed to effect the reorganization. Projects can be completed – including test runs – in a matter of weeks.


    • Low risk. No loss of history. No loss of data integrity.
    • Low cost and better results. The consulting or IT alternatives cost many times as much, take longer, and add risk of error and loss of most history.
    • Improved efficiency. Reorganization meets business, legal, or reporting requirements.
    • Improved corporate decision-making. The EBS is now organizationally aligned with the way that the company does business.
    • Metadata Analysis of all source and target instances.
      • Gap analysis of source and target configuration and structures
      • Drop-down lists with instance specific data choices
    • Maintenance of data and history.
    • Seamless implementation of all types of desired reorganization.
    • Automatic integration of data into target organization or set of books (ledger).
  • Calendar Change

    Automates the process of changing calendars in Oracle E-Business Suite, allowing you to support business requirements, retain history, and tie in all the subledger detail with the GL calendar. Calendars in other Oracle modules are copied or can be synchronized to the new GL calendar (Including FA, Projects, Inv, Budgets, and others).

    Sometimes the business requires changes to an existing calendar – either changing the calendar from a 4-4-5 calendar to a monthly calendar, changing a monthly calendar to a fiscal calendar, changing the dates on a period, changing the number of periods, or even changing the period names or calendar name. There are a number of difficulties to overcome because in Oracle E-Business Suite, the GL calendar is also used in many subledgers. Creating a new set of books or ledger and using financial consolidation for reporting isn’t always an option because when you change sets of books, your history and subledger detail isn’t synchronized with the reporting set of books and periods.

    Learn More Contact Us

    Merge, Split, or Move Sets of Books (Ledgers)

    Merge or split EBS sets of books (ledgers in R12) in order to more accurately reflect your current business.

    • Redesign your sets of books in order to take advantage of Subledger Accounting and Multi-org Access Control in R12
    • Design your new set of books configuration to enable an easy upgrade to R12
    • Take advantage of merging or splitting sets of books to get the configuration you need without an intensive reimplementation

    Merge, Split, or Move Business Groups

    Merge or split EBS business groups in order to more accurately reflect ongoing organizational operations and business processes.

    • Keep your EBS in line with one-time or ongoing organizational changes
    • Configure your business groups to take advantage of Multi-org Access Control in EBS R12 without reimplementing
    • Make configuration changes to your business groups that were neglected during your original implementation of EBS

    Merge, Split, or Move Inventory Orgs

    Merge, Split, or Move EBS inventory organizations to reduce costs, save time, and increase accuracy.

    • Reflect changing product lines in EBS as your business changes
    • Merge or split inventory organizations in the event of an acquisition or a divestiture
    • Increase ease and accuracy of product-oriented reporting

    Merge, Split, or Move Operating Units

    Merge or split EBS operating units or organization units to share or segregate sensitive data for different parts of the organization.

    • Restructure to more easily run a shared service center
    • Streamline security rules and administration
    • Enable better customer service and supplier leverage

    Merge, Split, or Move Legal Entities

    Merge, Split, or Move EBS legal entities to reflect the current organization structure.

    • Comply with local and statutory requirements
    • Restructure the enterprise for global expansion
    • Move legal entities from one set of books to another in order to align EBS with the way you do business
  • Merge Ledgers or Sets of Books

    Problem

    A large system integrator put each line of business into a separate primary ledger in their E-Business Suite. Realizing that the same customer may use each of their ERP implementation services, their security services, and their data warehouse services, they decided to merge their ledgers. The chart of accounts, the currency, the calendar, and the accounting conventions were the same for all 9 of their ledgers.

    Solution

    The firm used eprentise Reorganization software’s MS Sets of Books module to merge their 9 ledgers into a single primary ledger. They created operating units for each of the lines of business to keep the transactions separate and to maintain controls within the organization. They used Multiple Organizations Access Control in R12 to enable cross organizational processing and reporting on operating units in their subledgers.

    Move Legal Entities to a New Ledger or Set of Books

    Problem

    Before moving to E-Business Suite, the legacy systems for a steel manufacturing company did not handle multiple legal entities. They had set up separate accounting books for each legal entity. Not really understanding the functionality of E-Business Suite, they initially set up their applications to have multiple sets of books – one for each legal entity.

    Solution

    Using eprentise Reorganization software’s MSM Legal Entities module, they moved all the legal entities into a single set of books giving them visibility into the entire enterprise and the ability to operate consistently.

    Merge Org Units or Inventory Organizations

    Profile

    A utility company had thousands of warehouses across the city to stock their cable, poles, meters, and other supplies. Each warehouse was set up in their Oracle E-Business Suite as a separate inventory organization. Every time a work order came in, the truck drivers had to check the inventory at the closest warehouse and if the item was out of stock, had to check 4 or 5 other warehouses to locate the item. If the item was not used, they had to go back to each of the warehouses to have the item restocked. Sometimes a warehouse would reorder an item when the same item was overstocked at a warehouse just a few blocks away.

    Solution

    The company decided to consolidate their inventories into 4 warehouses – one in the north, one in the south, one in the east, and one on the west side of the city. They used eprentise Reorganization software’s MSM Inventory Organizations module to consolidate their inventory organizations. The result was a 20% savings on the warehouse costs, approximately 40% savings of time for their truck drivers, and a 27% savings on inventory costs.

    Consolidate Supplier Terms

    You have different terms with your suppliers and don’t know how much you buy from each supplier.

    Profile

    During an ad-hoc vendor analysis project, a large computer manufacturing company discovered that throughout the organization, it had many different contracts with each of its suppliers, each with different payment terms, inconsistent discounts, and shipment policies making it difficult to determine how much business they did with any one supplier, whether they were getting the best prices, and whether they were able to leverage their purchasing power. Furthermore, it discovered that there was no uniform way of accounting for the cost of goods sold, as expenses were set up to be tracked only by product. While accounting for expenses by product made it easy to determine profit margins for a particular product line, the lack of consistent accounting practices.

    Solution

    The company used eprentise Reorganization software’s MS Inventory Organizations module to consolidate its inventory organizations into organizations based on product lines, and to assign their costs consistently at the subinventory level within each organization. They also standardized on their min/max reorder points for each item, and standardized on their receiving policies within each organization unit. They used eprentise Data Quality software to identify and resolve duplicate suppliers and MRO items. Four hundred vendor contracts were renegotiated, the supplier list was consolidated, and the company was able to save an estimated $9 million a year in supplies.

    Change Your Calendar in E-Business Suite

    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).

    Solution

    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.

  • What can I do with eprentise software?

    With eprentise software you can reorganize, split, divide, or consolidate OEBS instances, and clean up the data within an instance or across multiple instances.

    • Reorganize the business structure within an instance. You can:
      • Move transactions from one set of books, operating unit, or legal entity to another.
      • Move, legal entities between SOBs.
      • Change accounting calendars.
      • Change currency
    • Divide an Oracle application instance into two or more consistent and correct instances.
    • Consolidate two or more application instances to take advantage of a single shared source of business data.
    • Consolidate inventories within an instance. You can also change the valuation of inventories.
    • Propagate data quality standards throughout one or more instances, including elimination of duplicate master data records.
    • Change key flexfield (KFF) segments and values, such as Sales Territories or Asset Categories, and reflect the change in the existing transactional data.

    Can I use eprentise and FlexField on E-Business Suite R12?

    Yes. eprentise and FlexField can be used for these E-Business Suite releases: 10.7, 11.x, 11i, and R12 (all current versions).

    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.

    What’s involved in the project? How is that time spent?

    An eprentise project involves:

    • Managing the project.
    • Defining requirements.
    • Making business decisions to define the target environment.
    • Obtaining consensus for changes.
    • Revision and adjustment of reports and interfaces to the organization’s other systems (custom, legacy, third party software, or external) to support the changes made within the E-Business Suite.
    • Running eprentise software.
    • Testing to make sure that the results meet the requirements.
    • Planning for cutover to production.
    • Cutover to production.

    Within any project, executing and analyzing Metadata Analysis usually takes between two to three weeks. For some projects, you may need to execute Metadata Analysis multiple times to account for the changes to the database that will occur by executing some of the rules. Most rules can be executed in days.

    Where is the work done?

    An eprentise project is like most E-Business Suite projects these days, in that we expect the combined customer and eprentise team to be working from multiple locations across the Internet using web sessions. During key parts of the project, a small number of eprentise team members may work at the customer’s facilities. The eprentise team will provide product usage guidance and product support from offices in Orlando, FL, Atlanta, GA, Ann Arbor, MI, and Bangalore, India.

    Can I use eprentise and FlexField on E-Business Suite R12?

    Yes. eprentise and FlexField can be used for these E-Business Suite releases: 10.7, 11.x, 11i, and R12 (all current versions).

  • Datasheets (PDFs):

    Reorganization Datasheet

    Download PDF
    eprentise 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.

    Calendar Change Datasheet

    Download PDF
    Sometimes the business requires changes to an existing calendar – either changing the calendar from a 4-4-5 calendar to a monthly calendar, changing a monthly calendar to a fiscal calendar, changing the dates on a period, changing the number of periods, or even changing the period names or calendar name. There are a number of difficulties to overcome because in Oracle E-Business Suite, the GL calendar is also used in many subledgers. Creating a new set of books or ledger and using financial consolidation for reporting isn’t always an option because when you change sets of books, your history and subledger detail isn’t synchronized with the reporting set of books and periods.

    Currency Change Datasheet

    Download PDF
    eprentise Currency Change software allows Oracle® E-Business Suite customers to change the functional currency for any set of books. Relying on its built-in knowledge base of Oracle EBS, eprentise software provides a streamlined, cost-effective way to change the functional currency for a set of books.


    Software Demos (video):