Instance Consolidation

eprentise Consolidation software allows companies to completely merge two or more instances of Oracle’s E-Business Suite (EBS) into a single consolidated instance that includes all of the history from each of the source instances.

eprentise software relies on its built-in knowledge base of EBS to provide a streamlined, highly cost-effective way to consolidate different instances after a merger, or to move to a centralized data center. eprentise Consolidation software automates the process and generates all of the code needed to consolidate the instances, retaining and updating all history found in the source instances, and resolving duplicates in the target instance in accordance with user-defined or software-implemented patterns and preferences. Using drop-down lists, rule creation templates, and mapping tools, eprentise allows the business user to make changes without understanding the technical details. If, after a test run, the results are not exactly as desired, those same business users can modify their previous choices to achieve the preferred final design for the target instance.

Business Objectives

• Merge two companies that had been running on the Oracle E-Business Suite
• Merge company divisions or other entities that had been running in separate instances
• Leverage suppliers, provide better service to customers, and minimize unnecessary inventory using readily-available, consistent, consolidated data
• Improve and streamline reporting and data warehouse extracts based on a consistent, global view of all the enterprise data
• Eliminate duplicative hardware, overhead, and maintenance costs of multiple instances

eprentise Features

• Consolidation of entire instances without loss of history
• Easy-to-use, eprentise software interfaces with EBS
• Automatic features, no coding, designed for business users
• Initiate projects with drop down lists
• Rule template groups that operate with check boxes and lists of choices
• Duplicate resolution by user created rules or suggested defaults
• Feel secure. All updates are done by the software, and its knowledge base maintains relational integrity. All code is automatically generated by eprentise software. Does not require technical knowledge of the EBS version, specific modules, or SQL coding. Built-in error checking identifies exceptions, alerts the user, and implements resolution. Automatically maintains a full audit trail.
• Shortens the time to completion. Even with two or more full test cycles, the time to completion is a few months, not years.

eprentise Benefits

• 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, add risk of error, and loss of most history.
• Improved efficiency. Consolidated instance reduces hardware, license, and maintenance costs.
• Improved corporate decision making. Complete, consistent, and correct data in a single source of truth. No more costly and awkward data bridges and reconciliations across instances of the EBS to perform periodic tasks or for routine reporting
• The consolidated instance is aligned with the consolidated business. Software allows easy mapping to global chart of accounts and organization that reflects the actual current business of the firm

eprentise Consolidation Functions

• Metadata analysis of all source and target instances
• Identification and repair of missing or broken constraints
• Comparison of set-up data, business differences
• Complete data merge from all source instances into target instance, with all differences resolved
• Standardization, duplicate identification and resolution across instances
• Seamless implementation of all types of desired reorganizations with consolidation