What does it mean to have a Complete, Consistent, and Correct database instance?
• Consider the following observations about what is not complete, consistent, or correct. • If there are multiple E-Business Suite database instances, no instance provides the complete business data. There are often inconsistencies among instances. The inconsistencies lead business users to conclude the data is incorrect and can’t be trusted. They often have external spreadsheets to fix the data and reconcile the differences among the instances. • When there are multiple EBS instances, you usually find data is passed between them via interfaces, to synchronize data and couple business processes together. • Some approaches to consolidating multiple instances leave out the transaction history, so the business users are left with “sunset” instances that contain all the history up to the point of consolidation. They may need to access these sunset instances to look up prior events and transactions. Thus the single consolidated instance is not complete. • Even when there is only a single in
