Oracle Forums Community of Oracle Professionals including Fusion/Cloud Application Consultants, ERP Experts, Oracle Apps Functional Consultants, Apps DBAs, DBAs, Cloud DBAs, Technical Consultants, Fusion Middleware Experts, SQL, PL/SQL Developers and Project Managers. Welcome to OraERP.com Social Community, a friendly and active community of Oracle Technology Professionals who believe that technology can ‘make the world a better place’. By joining Oracle ERP Community you will have the ability to Post Topics, Receive our Newsletter, subscribe to threads and access many other special features. Registration is Quick and Simple.
Get unlimited access to Oracle Tutorials, Articles, eBooks, Tools and Tips by upgrading to "Premium Membership".
Oracle Training

Thread Rating:
  • 27 Vote(s) - 2.78 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases
#1
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:

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:
[Image: 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
-------
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)
Reply
Thanks given by:
#2
(05-31-2011, 04:47 PM)Kashif Manzoor Wrote: 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:


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:
[Image: 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
-------
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)
Reply
Thanks given by:


Possibly Related Threads...
Thread Author Replies Views Last Post
  Oracle Fusion Cloud Application Logical and Relational Data Model Diagrams Hassanmalik 1 587 08-24-2017, 07:01 PM
Last Post: sammy
  Difference Between Fusion Procurement Business Units versus EBS Suite Operating Units Sneha Rahul 0 473 07-28-2017, 09:14 PM
Last Post: Sneha Rahul
  Overview of Oracle iProcurement (EBS R12) Mark Donald 1 4,738 09-03-2015, 06:06 PM
Last Post: Kashif Manzoor
  Oracle Financials - Data Flow From SLA to GL admin 1 36,098 08-13-2015, 04:53 PM
Last Post: Kashif Manzoor
  Oracle EBS R12 Financials Configurations Summary Presentation M Irfan 0 1,634 06-10-2015, 04:00 AM
Last Post: M Irfan
  Oracle EBS R12 Financials Configurations Summary M Irfan 0 1,151 06-10-2015, 03:53 AM
Last Post: M Irfan
  Oracle EBS R12.1.3 Upgrade from 11i Detailed DBA Tasks with Downtime required Kashif Manzoor 0 1,193 01-19-2015, 09:56 PM
Last Post: Kashif Manzoor
  eBook: Installation of Oracle EBS 12.2 Kashif Manzoor 2 5,557 06-12-2014, 11:52 PM
Last Post: Kashif Manzoor
Rainbow Data Load Template for HRMS fanni339 0 2,683 06-22-2013, 03:13 PM
Last Post: fanni339



Users browsing this thread: 1 Guest(s)
Get Premium Membership Get Oracle Tutorials, Tips! Post a Question!