Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases

[Kashif Manzoor]

When I recall year 2009 and my first project to work on upgrade from 11.5.9 to R-12 it was a big time challenge to find out Data model changes between 11i release and R-12 & to convince client’s Audit team, how upgrade will impact on database architecture.

But I am delighted to write here after going through work of Steven & his team has done to get comparison reports of database object definition changes between two EBS releases. It will help us to review the database object definition changes before upgrading instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

Really very good tool, now I am just copying the blog of Steven or you can find from.
http://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213

By Steven Chan (Oracle Development) on Feb 17, 2011
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:

• EBS Data Model Comparison Report Overview (Note 1290886.1)
  

This new tool lists the database object definition changes between the following source and target EBS releases:

1. EBS 11.5.10.2 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 11.5.10.2 and 12.1.3:


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

-------
You can watch a good video on report
https://support.oracle.com/CSP/main/article?cmd=show&type=VIDEO&id=1290886.1:overview_video
Select one of the links below to view the data model comparison report for a specific release.

• Release 11.5.9 to Release 12.1.3 (zip)
• Release 11.5.10.2 to Release 12.1.3 (zip)
  
• Release 12.0.4 to Release 12.1.3 (zip)
• Release 12.0.6 to Release 12.1.3 (zip)
  
• Release 12.1.1 to Release 12.1.3 (zip)
• Release 12.1.2 to Release 12.1.3 (zip)

[hemanthe]

When I recall year 2009 and my first project to work on upgrade from 11.5.9 to R-12 it was a big time challenge to find out Data model changes between 11i release and R-12 & to convince client’s Audit team, how upgrade will impact on database architecture.

But I am delighted to write here after going through work of Steven & his team has done to get comparison reports of database object definition changes between two EBS releases. It will help us to review the database object definition changes before upgrading instances from one release to another and understand the impact of the database object changes that may affect the customization or business flows.

Really very good tool, now I am just copying the blog of Steven or you can find from.
http://blogs.oracle.com/stevenChan/entry/ebs_data_model_1213

By Steven Chan (Oracle Development) on Feb 17, 2011
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:

• EBS Data Model Comparison Report Overview (Note 1290886.1)
  

This new tool lists the database object definition changes between the following source and target EBS releases:

1. EBS 11.5.10.2 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 11.5.10.2 and 12.1.3:


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

-------
You can watch a good video on report
https://support.oracle.com/CSP/main/article?cmd=show&type=VIDEO&id=1290886.1:overview_video
Select one of the links below to view the data model comparison report for a specific release.

• Release 11.5.9 to Release 12.1.3 (zip)
• Release 11.5.10.2 to Release 12.1.3 (zip)
  
• Release 12.0.4 to Release 12.1.3 (zip)
• Release 12.0.6 to Release 12.1.3 (zip)
  
• Release 12.1.1 to Release 12.1.3 (zip)
• Release 12.1.2 to Release 12.1.3 (zip)