Maintain Agility in Your Organization with eprentise Software for Oracle® EBS
Ensure your data is Complete, Consistent, and Correct by using eprentise software to transform your Oracle® E-Business Suite.
Developed around four core functions of Copy, Filter, Merge, and Change, the software products below are the results of patent-pending eprentise technology that has been in development for over ten years.
- Create Two Separate Oracle E-Business Suite Instances
Create Two Separate Oracle E-Business Suite Instances
Both end databases remain complete, functioning, and fully configured with only the information relevant to each continuing company.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.
Our software allows you to divest data based on any type of criteria including:
- legal entity
- sets of books
- business unit
- product line
- customers
- regions
- organization units
Both end databases remain complete, functioning, and fully configured with only the information relevant to each continuing company. Each company’s application has only its own data, ensuring that the parent company is comfortable with data security while enabling the divested company to function completely on its own.
- Separate Data When You Sell a Part of Your Business
Separate Data When You Sell a Part of Your Business
You are selling a part of your business and need to separate out the related data. Use eprentise Divestiture software.
ProblemA 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
The eprentise method maintained all relational integrity and adjusted all totals to reflect the deleted transactions.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.
- Break Down the Silos
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. Use eprentise Consolidation software.
ProblemA 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.
Solution
The company was able to get the reports it needed straight from EBS and was able to eliminate a large energy footprint in the form of integration systems.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 it needed straight from E-Business Suite and was able to eliminate a large energy footprint in the form of integration systems.
- Integrate Your E-Business Suite with an Acquired Suite
Integrate Your E-Business Suite with an Acquired Suite
You have just acquired a company who also uses Oracle E-Business Suite. Use eprentise Consolidation software.
ProblemA 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.
Solution
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.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.
- Consolidate Multiple Production Instances of EBS Into One Instance
Consolidate Multiple Production Instances of EBS Into One Instance
You want to go to a central data center and consolidate your Oracle E-Business Suites into a single instance. Use eprentise Consolidation software.
Problem
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.
Solution
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.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.
- Change All Key Flexfields
Change All Key Flexfields
Accounting flexfield is covered by FlexField software.
- Revalue Assets
Revalue Assets
- Reduce the Number of Legal Entities or Sets of Books
Reduce the Number of Legal Entities or Sets of Books
- Change Currency
Change Currency
- Change Costing Methods
Change Costing Methods
- Consolidate Supplier Terms
Consolidate Supplier Terms
You have different terms with your suppliers and don’t know how much you buy from each supplier. Use eprentise Reorganization software’s MS Inventory Organizations module.
Problem
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
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.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.
- Merge Business Groups
Merge Business Groups
- Move Operating Units to New Set of Books
Move Operating Units to New Set of Books
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
- Inventory Consolidation
Inventory Consolidation
You are acquiring a new plant and want to consolidate the inventory into your existing inventory. Use eprentise Reorganization software’s MSM Inventory Organizations module.
Problem
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.
Solution
They were able to reduce their warehouse costs by 35% and their inventory costs by 25%.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%.
- Merge Org Units or Inventory Organizations
Merge Org Units or Inventory Organizations
You have too many org units or inventory organizations, and you want to merge them together. Use eprentise Reorganization software’s MSM Inventory Organizations module.
ProblemA 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 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.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.
- Move Legal Entities to a New Ledger or Set of Books
Move Legal Entities to a New Ledger or Set of Books
You want to move legal entities into a new ledger or set of books. Use eprentise Reorganization software’s MSM Legal Entities module.
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 or Split EBS Sets of Books/Ledgers
Merge or Split EBS Sets of Books/Ledgers
You want to merge ledgers or sets of books. Use eprentise Reorganization software’s MS Sets of Books module.
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. - Make Calendar Changes in EBS
Make Calendar Changes in EBS
You need to change your GL Calendar in E-Business Suite. Use eprentise Reorganization software’s Calendar Change module.
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
They used eprentise to synchronize the Fixed Assets calendar, the project accounting calendar, and the inventory calendar to the GL calendar.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.
- Out-of-the Box Software – No Scripts, No Coding
Out-of-the Box Software – No Scripts, No Coding
- Map at the segment level (1:1, 1:M, M:1) or the code combination level (1:1, M:1)
Map at the segment level (1:1, 1:M, M:1) or the code combination level (1:1, M:1)
- Eliminate Unused Code Combinations
Eliminate Unused Code Combinations
- Add or Reduce the Number of Segments
Add or Reduce the Number of Segments
- Clean Up Your Data Before Upgrading to R12
Clean Up Your Data Before Upgrading to R12
You want to clean up your data before upgrading to R12. Use eprentise software to standardize, consolidate, and eliminate duplicate data.
Problem
After years of running E-Business Suite 11.5.9, a global company was planning an upgrade to R12 but realized that it would be difficult to utilize the additional functionality of R12 without cleaning up the data first. While they previously had several sets of books to accommodate different statutory and regulatory requirements as well as different currencies, they wanted to use the subledger accounting features of R12 and use a single primary ledger along with multiple subsidiary ledgers that would handle the local requirements.
Solution
The company used FlexField software to change the accounting flexfields in each set of books to the same chart of accounts and put its accounts in clean logical ranges, standardizing the accounting structure and making consolidated financial reporting easier. They then used eprentise Reorganization software’s MS Sets of Books module to consolidate the different sets of books into a single set of books to prepare the instance for subledger accounting with a single primary ledger in R12. Furthermore, the company used eprentise Data Archive software to purge obsolete data and eprentise Data Quality software to eliminate duplicate data.
- Eliminate Thousands of Cross-validation Rules
Eliminate Thousands of Cross-validation Rules
You need to eliminate thousands of cross-validation rules. Use eprentise FlexField software.
Problem
A financial services company had over 2000 cross validation rules to enforce which departments could use which cost centers and accounts. In their current chart of accounts, they had run out of digits in the ranges that were defined, so the structure that was supposed to have Revenue starting from 1000 to 1999, Liabilities from 2000 to 2999, Expenses from 3000 to 3999, Assets from 4000 to 4999, and owner’s equity from 6000 to 6999 now had Revenue from 1000 to 1999, Revenue from 5000-5499, Revenue from 5700-5999, Liability from 2000-2999, Assets from 5500-5699, and so on.
It was almost impossible to remember what account went with which cost centers for each department. Every time the company wanted to add a new value, they had to rearrange all their cross validation rules. Maintenance on the chart of accounts was taking days each year end when they added new tax accounts.
Solution
The company expanded their account segment to 6 digits using FlexField software, put everything in ranges, and went down to a total of 17 cross-validation rules. There was no longer any maintenance to add new accounts or new departments. As an aside, they were also able to streamline their reporting so new reports were generated quickly.
- Comply with Regulatory Requirements
Comply with Regulatory Requirements
You need to comply with regulatory requirements. Use eprentise FlexField software.
Problem
A prominent manufacturing and distribution company needed to change their chart of accounts a few years back. They followed Oracle’s recommendation, set up a new set of books with a new chart of accounts and used Oracle’s financial consolidation to consolidate their general ledger. However, when their auditor came to assess their Sarbanes-Oxley compliance, he said that since their history and their subledgers did not use the same chart of accounts for their detail transactions and it was difficult to drill down on their accounts, they were non-compliant. Since Sarbanes-Oxley’s inception in 2002, the company had complied by using third-party reporting tools, but management had finally made the decision that it would be more efficient to change the way they accounted for certain parts of the business at the source, the accounting flexfield. They were told that in order to make the changes they wished to make, a re-implementation of their E-Business Suite would be necessary, but they did not want to spend the time or the capital to get involved in a process that would likely last over a year. They needed a quick way to make fundamental changes to their accounting flexfield without the need for a re-implementation.
Solution
By restructuring their accounting flexfield, they were able to save millions of dollars in personnel and third-party software license costs over the next 3 years.The company used FlexField software to restructure their accounting flexfield in a way that enabled them to save multiple millions of dollars in personnel and third-party software license costs over the next 3 years. Because their reporting, drill down and the transaction history was transparent (it looked like they had always used the new chart of accounts), the auditors and their compliance officers were pleased.
- Move to a Single Global Chart of Accounts
Move to a Single Global Chart of Accounts
You want to go to a single global chart of accounts. Use eprentise FlexField software.
Problem
A pharmaceutical company is upgrading to R12 in their Oracle E-Business Suite because of the capability to have multiple ledgers. Their current setup had seven separate sets of books, one for each of the European countries they did business in, because they implemented before the Euro was the European standard currency. Now, in R12, they can record all transactions in a single ledger because the currency is the same. However, in order to use a single primary ledger, they need to have a single chart of accounts.
Solution
Using FlexField software, they completed the conversion process to their new chart of accounts with three test runs in 5 months.The company created their new chart of accounts, and mapped each of the seven charts of accounts to the new chart of accounts. Using FlexField software, they completed the conversion process to their new chart of accounts with three test runs in 5 months. Using security and cross validation rules, they were able to restrict access, giving each country some freedom in the way they controlled operations without limiting the company’s ability to operate globally with consistent data. They are now able to close their books each month in 3 days instead of the 12 days that it took before the chart of accounts change. They estimate that they have reduced operating costs for their accounting team by approximately 35%.