The Latest Technology Stack News Directly from EBS Development

Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases

Steven Chan
Senior Director

[Update June 21, 2011: A complementary tool that compares seed data between different EBS releases is now available.]

The EBS 12.1.3 Release Content Document (RCD, Note 561580.1) summarizes the latest functional and technology stack-related updates in a specific release.  The E-Business Suite Electronic Technical Reference Manual (eTRM) summarizes the database objects in a specific EBS release.  Those are useful references, but sometimes you need to find out which database objects have changed between one EBS release and another.  This kind of information about the differences or deltas between two releases is useful if you have customized or extended your EBS instance and plan to upgrade to EBS 12.1.3. Where can you find that information? Answering that question has just gotten a lot easier.  You can now use a new EBS Data Model Comparison Report tool:

This new tool lists the database object definition changes between the following source and target EBS releases:
  1. EBS and EBS 12.1.3
  2. EBS 12.0.4 and EBS 12.1.3
  3. EBS 12.1.1 and EBS 12.1.3
  4. EBS 12.1.2 and EBS 12.1.3
For example, here's part of the report comparing Bill of Materials changes between and 12.1.3:
Screenshot of EBS data model comparison report for Bill of Materials 12 1 3 and EBS 11 5 10 2 bom_1213_diffs.png
What types of database objects does this tool cover? This tool includes reports of the differences in:
  • Regular tables
  • Partitioned tables
  • Index organized tables
  • Global temporary tables
  • Queued tables
  • Views
  • Indexes
  • Sequences
  • Materialized views
  • Materialized view logs
  • Advanced queues
  • Packages
  • Triggers
  • Types
Your feedback is welcome This new tool was produced by our hard-working EBS Release Management team, and they're actively seeking your feedback.  Please feel free to share your experiences with it by posting a comment here.  You can also request enhancements to this tool via the distribution list address included in Note 1290886.1. Related Articles