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
- Release 12.2.7
- Release 12.2.8
- Release 12.2.9
- Release 12.2.10
- Release 12.2.11
- Release 12.2.12
- Release 12.2.13
Benefits of EBS Data Model Comparison Report
- it helps users to preview the database object definition changes before upgrading their instances from one release to another
- we can understand the impact of the database object changes that may affect the customization or business flows.
- we can focus on what has changed
- Easier to analyze the impact on customizations, planned test coverage
- Differences are viewable for all products in the same report via a 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 a local directory. Open the file “DataModelComparisonReport.html” in your browser from the local directory where you have unzipped the file. The 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) |
|---|---|
| Release 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) |
| Release 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) |
| Release 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) |
| Release 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) |
| Release 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) |
| Release 12.2.7 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.7 (zip) Release 12.1.3 to Release 12.2.7 (zip) Release 12.2.3 to Release 12.2.7 (zip) Release 12.2.4 to Release 12.2.7 (zip) Release 12.2.5 to Release 12.2.7 (zip) Release 12.2.6 to Release 12.2.7 (zip) |
| Release 12.2.8 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.8 (zip) Release 12.0.6 to Release 12.2.8 (zip) Release 12.1.3 to Release 12.2.8 (zip) Release 12.2.3 to Release 12.2.8 (zip) Release 12.2.6 to Release 12.2.8 (zip) Release 12.2.7 to Release 12.2.8 (zip) |
| Release 12.2.9 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.9 (zip) Release 12.0.6 to Release 12.2.9 (zip) Release 12.1.3 to Release 12.2.9 (zip) Release 12.2.3 to Release 12.2.9 (zip) Release 12.2.7 to Release 12.2.9 (zip) Release 12.2.8 to Release 12.2.9 (zip) |
| Release 12.2.10 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.10 (zip) Release 12.0.6 to Release 12.2.10 (zip) Release 12.1.3 to Release 12.2.10 (zip) Release 12.2.3 to Release 12.2.10 (zip) Release 12.2.8 to Release 12.2.10 (zip) Release 12.2.9 to Release 12.2.10 (zip) |
| Release 12.2.11 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.11 (zip) Release 12.0.6 to Release 12.2.11 (zip) Release 12.1.3 to Release 12.2.11 (zip) Release 12.2.3 to Release 12.2.11 (zip) Release 12.2.8 to Release 12.2.11 (zip) Release 12.2.9 to Release 12.2.11 (zip) Release 12.2.10 to Release 12.2.11 (zip) |
| Release 12.2.12 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.12 (zip) Release 12.0.6 to Release 12.2.12 (zip) Release 12.1.3 to Release 12.2.12 (zip) Release 12.2.3 to Release 12.2.12 (zip) Release 12.2.10 to Release 12.2.12 (zip) Release 12.2.11 to Release 12.2.12 (zip) |
| Release 12.2.13 | Release 11.5.10.2 Minimum Baseline (11iMBL) to Release 12.2.13 (zip) Release 12.0.6 to Release 12.2.13 (zip) Release 12.1.3 to Release 12.2.13 (zip) Release 12.2.3 to Release 12.2.13 (zip) Release 12.2.11 to Release 12.2.13 (zip)R elease 12.2.12 to Release 12.2.13 (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 see 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 are 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 that didn’t exist in the source release but exists in the target release or vice versa) are not considered for comparison because all the objects would be new in the target release or removed. The data model comparison report is available only for products that exist in both releases except for 11i IRC and AME products.
(3) In the 12.2 (and onwards) report, I see a checkbox to include data model changes that support Online Patching. 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 at the top of the report.
FYI. The data model changes to support Online Patching include but are 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).
(4) I’m looking for the data model comparison report for a certain release pair. But it is not available. What can I do?
Answer
For every applicable release, Oracle identifies the release pairs that are most commonly used and publishes the reports only for those release pairs because there are simply too many possible combinations of releases to accommodate them all. For release pairs that are not available, we suggest making the best guess effort by going off of the already existing reports. For example, if you look for the report for 12.2.4 to 12.2.8 which is not available, you can make the best guess by going off of the 12.2.4 to 12.2.7 report and then the 12.2.7 to 12.2.8 report. You can also do the test upgrade and compare against before the production upgrade
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