EBS Data Model Comparison Report



Oracle provides the  EBS data model comparison report to view the static database object definition changes between two EBS releases

Applicable Releases
•Release 12.1.3
•Release 12.2.2
•Release 12.2.3
•Release 12.2.4
•Release 12.2.5
•Release 12.2.6

Benefits of EBS Data Model Comparison Report

  1. it help users to preview the database object definition changes before upgrading their instances from one release to another
  2. we can understand the impact of the database object changes that may affect the customization or business flows.
  3. we can focus on what has changed
  4. Easier to analyze impact on customizations, planned test coverage
  5. Differences viewable for all products in the same report via simple UI

 

We can view the Per product database object comparison between two releases for the
following object types

-Regular tables, Partitioned tables, Index organized tables, Global temporary tables, Queued tables
–Views, Materialized views, Materialized view logs
–Indexes, Sequences, Advanced queues, Packages, Triggers

How to view the EBS Data Model Comparison Report

Download the zip file and unzip the file into to a local directory. Open the file “DataModelComparisonReport.html” in your browser from the local directory where you have unzipped the file.Top frame will have a product LOV and the left frame will have a table for the summary statistics of differences . Users can select a product and navigate to the database object definition differences for each supported database object type which is displayed in the bottom frame.

Select one of the links below to view the data model comparison report for a specific release:

Applicable Releases Release Pair(s)
 

12.1.3

  • 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)
 

12.2.2

  • Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.2 (zip)
  • Release 12.0.6 to Release 12.2.2 (zip)
  • Release 12.1.3 to Release 12.2.2 (zip)
 

12.2.3

  • Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.3 (zip)
  • Release 12.0.6 to Release 12.2.3 (zip)
  • Release 12.1.3 to Release 12.2.3 (zip)
  • Release 12.2.2 to Release 12.2.3 (zip)
12.2.4
  • Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.4 (zip)
  • Release 12.0.6 to Release 12.2.4 (zip)
  • Release 12.1.3 to Release 12.2.4 (zip)
  • Release 12.2.2 to Release 12.2.4 (zip)
  • Release 12.2.3 to Release 12.2.4 (zip)
12.2.5
  • Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.5 (zip)
  • Release 12.0.6 to Release 12.2.5 (zip)
  • Release 12.1.3 to Release 12.2.5 (zip)
  • Release 12.2.3 to Release 12.2.5 (zip)
  • Release 12.2.4 to Release 12.2.5 (zip)
Release 12.2.6
  • Release 11.5.10.2 Minimum Baseline (11iMBL to Release 12.2.6 (zip)
  • Release 12.0.6 to Release 12.2.6 (zip)
  • Release 12.1.3 to Release 12.2.6 (zip)
  • Release 12.2.3 to Release 12.2.6 (zip)
  • Release 12.2.4 to Release 12.2.6 (zip)
  • Release 12.2.5 to Release 12.2.6 (zip)

Users can select a product and navigate the database object definition differences for each supported database object type.

Important FAQ for EBS Data Model Comparison Report

1)In IE, when I open the “DataModelComparisonReport.html”, I am seeing a yellow bar for running scripts and ActiveX controls. what is this for?

Answer
You are prompted for permission to allow the download of ActiveX controls. Click on the yellow bar and select ” Allow Blocked Content” and then click “Yes” on the confirmation dialog. This will allow you to enable ActiveX controls which is required for rendering the report.

2) I am getting a message saying “Product:<prod>is removed in <release>” or “Product:<prod>is added in <release>”.

Answer
New or removed products (i.e. a product didn’t exist in the source release but exist in the target release or vice versa) are not considered for comparison because all the objects would be all new in the target release or removed from. The data model comparison report is available only for products that exist in both releases except for 11i IRC and AME products.
3) In 12.2 (and onwards) report, I see a checkbox to include data model changes that support Online Patching[3] . What are those changes?

Answer

E-Business Suite Release 12.2 introduces several major new technologies and updates. One of the features is Online Patching, which enables patches to EBS 12.2 to be applied while the system is running. To support the Online Patching feature, there are thousands of automated data model upgrades made during the “online patching enablement” process as part of the EBS 12.2.0 upgrade. Even though these changes are “valid data model changes”, they are not “interesting data model changes” and are filtered out from the report. However, if you want to review the complete data model changes including the automated data model upgrades, you can select the checkbox located in the top of the report.

FYI. The data model changes to support Online Patching include but not limited to:
1.New ZD_EDITION_NAME column with default value is added to seed data tables.
2.New ZD_EDITION_NAME column is added to all unique indexes.
3.New Editioning Views (called TABLE_NAME#) are added for regular tables.
4.New triggers (called TABLE_NAME+) on the Editioning View are added.
5.Trigger’s base object type and name are changed to refer the editioning view instead of the direct table.
6.User Defined Types that are referenced by tables are moved to the APPS_NE schema.
7.Table columns based on User Defined Types now reference the type in APPS_NE schema.
8.Synonyms that pointed to ordinary tables now point to the editioning view instead.
9.Columns for regular tables are revised via new physical columns (called COLUMN_NAME#<n>; where <n> is a revision tag).
10.Global temporary tables are revised via new physical global temporary tables (called TABLE_NAME<n>; where <n> is a revision tag).

Please read the below metalink note for more details

EBS Data Model Comparison Report Overview (Doc ID 1290886.1

Must Read Articles

40 question you must know about R12.2

Service Group changes in R12.2

Adop(Ad online patching utility) explained R12.2

oracle ebs 11i/R12/R12.1/R12.2 Resources


Leave a Reply