Breadcrumbs
Home / Case Studies / Consolidation, Migration, and Sharing Information / Consolidate Multiple Production Instances of EBS Into a Single InstanceConsolidate 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.
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
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.
Frequently Asked Questions
- Why do you suggest consolidation before the upgrade?
- Can I consolidate my old 11i instance with my recently-implemented R12 instance?
- Doesn’t Oracle E-Business Suite documentation say not to use Oracle database tools to modify Oracle Applications data?
- I’m going to upgrade from 11i to R12 soon. Can I use eprentise or FlexField before the upgrade, and if I do, are there any special considerations?
- What happens if something does go wrong and I need to call Oracle Support?
Related Problems
Solution: FlexField
Solution: Consolidation
Related Blog Posts
- Everyone Takes the Hit: What You Can Do About It – 5 Key Business Metrics and Oracle E-Business Suite
- Operating a Shared Service Center in R12 Using EBS
- 1 + 1 = 12: A Look at Migration vs. Consolidation
- Approaches for Changing the Chart of Accounts: Eliminating the Risks
- Before You Upgrade to Release 12 - Look at the Data




