Identifying Data Model Changes Between EBS 12.1.3 and Prior EBS Releases

[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 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:
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

Comments:

Hi Steven,

that's just perfect, very helpful. And you published at in the right moment, we just started with upgrading ;)

Thanks a lot to you and your team and this great source of information here.

David.

Posted by David Weber on February 17, 2011 at 05:02 PM PST #

Steven -
Thanks for the post. This utility will be quite helpful as we upgrade from 11i to 12. See you at Collaborate!
Regards,
~ep
Elke Phelps

Posted by Elke Phelps on February 17, 2011 at 11:07 PM PST #

Thanks for sharing Steven, this will be a great asset as we continue working through our required custom reporting object updates (e.g. Discoverer custom folders, SQL Views, etc.) as we move from 11i10.2 -> 12.1.3

Posted by Larry Baugh on February 18, 2011 at 11:18 PM PST #

Very cool. I'm sure my developers will be singing ATG group's praises, which come to think of it is rather disturbing..

Anyhow, are there any plans to offer a master guide on all apps profile options? My functionals were recently asking for such a thing and I can see the usefulness but am unaware of anything like it.

Posted by Jay Weinshenker on February 20, 2011 at 01:50 AM PST #

Jay,

Haven't seen anything along those lines, but I'll pass that feedback to the same team that produced this tool for their consideration.

Regards,
Steven

Posted by Steven Chan on February 21, 2011 at 12:43 AM PST #

Thanks for this. When I compiled a list of database objects being used in our customisations and being different in R12, I had to do this comparison by comparing database objects. Now I'm using the tool to double check changed objects.

I'm taking my hat off to the EBS Release Management team. It wouldn't hurt to have it released earlier though.

One insignificant typo I've noticed: When I click on a URL link to see complete changes for a view, the title of the window which opens reads "Data Maodel Comparison Sample Report". This is in the EBS 11.5.10.2 and EBS 12.1.3 comparison report tool.

Regards
Jozef

Posted by Jozef Hlavaty on February 22, 2011 at 07:48 AM PST #

Hi, Jozef,

I've passed your entire comment along to the team verbatim. They thought that they'd caught that typo in a prior version and are looking into this now.

Regards,
Steven

Posted by Steven Chan on February 23, 2011 at 04:24 AM PST #

Hi,

Unable to download ZIP files from metalink note. Could you please forward the same.

Posted by guest on July 22, 2011 at 02:10 PM PDT #

Hi, Guest,

Sorry, we're not permitted to do that. Files on My Oracle Support are available only to people with access to that system.

Regards,
Steven

Posted by Steven Chan on July 22, 2011 at 03:32 PM PDT #

Hi Steven, the zip files in the note are corrupt. Do you know any other place on Oracle support where i can download them from? Or is there any email ID where I can report the issue and get the solution?

btw, Thanks for the great blog!

Archana

Posted by Archana on July 24, 2011 at 08:32 PM PDT #

Hi, Archana,

I'm sorry to hear that you've encountered an issue with this. We've just verified the files again and cannot reproduce the problem. It appears to be specific to your situation.

Please log a formal Service Request via My Oracle Support (formerly Metalink) to get one of our specialists engaged. Please forward your SR number to me so that I can monitor this.

Regards,
Steven

Posted by Steven Chan on July 25, 2011 at 03:51 AM PDT #

A few others have also reported issues. It turns out that there's an IE-specific problem with My Oracle Support attachments that has just cropped up. The problem doesn't occur with Firefox.

26-jul-2011 Update: Temporary workaround for Internet Explorer Users:

If you are an IE user and do not have alternative, here's a workaround until a fix is available.

1. Download the zip file

2. Extract the file to a folder using any extraction tool (e.g. WinZip, 7zip or WinRar), and extract, open

3. Open the folder, there is one file with no file extension. Attach the extension “.zip” to this file name.

4. Extract the zip file from step 3.

Regards,
Steven

Posted by Steven Chan on July 26, 2011 at 07:45 AM PDT #

The IE downloading bug in My Oracle Support has been fixed now. Thanks for letting us know about this issue.

Regards,
Steven

Posted by Steven Chan on August 25, 2011 at 10:07 AM PDT #

Hi,

The RCD's are great to highlight functional differences - agreed.
The ETRM is great to see what the 12.1.3 underlying DB looks like - agreed.
The new comparison report is a great resource to see the differences bettwen DB objects in a previosu release and R12.1.3 - agreed.

Now - where can I find out what has happened in the Forms/Reports area? i.e. what Forms have been deprecated/removed - what forms have been amended etc.

Just a simple list would be a great start - especially if any extension/customization was based on an existing form (i.e. pre-personalization - or personalization couldn't provide all the required functionality).

Is there anything available? Or are we left to our own devices and simple doing directory compares?

Thanks a lot.

Regards,
Bren

Posted by Brendan on November 01, 2011 at 03:59 AM PDT #

Hi, Bren,

I'm afraid that the RCDs, ETRM, and these reports are the only things that are available today. There may be other tools available in the future, though; stay tuned to this blog for upcoming announcements.

Regards,
Steven

Posted by Steven Chan on November 01, 2011 at 04:26 AM PDT #

Thanks Steven for the metalink document. The feature is simple, neat and informative.
However, there does not seem to be a mapping between objects that were obsoleted and the ones that have been replaced (in the sense ap_accounting_events_all has been replaced with xla_events table). No part of the document states this.
Any idea whether there is a tool already available or is it already hidden in the db as a metadata?
Thank you,
Srini Ramanujam

Posted by Srini Ramanujam on November 10, 2011 at 06:20 AM PST #

Hi Srini, thanks for your feedback! We've looked at that, but unfortunately there is no single place where such mapping information exists. Compiling it is currently a manual process, so it's unlikely to become part of these generated reports. We are continuing to look at ways we can provide other useful information in future reports, so please keep the feedback coming!

Thanks,
Sara

Posted by Sara Woodhull on November 14, 2011 at 03:31 AM PST #

hi,
I was looking for differences in database objects of 12.1.2 and 12.1.3 and i got it. But it's not correct.

I think they are same as that of above 12.1.1 and 12.1.3

Thanks

Posted by guest on April 03, 2012 at 11:01 PM PDT #

Hello, Guest,

Can you provide me with a Service Request number that contains more details about the objects that you believe aren't reported correctly?

Regards,
Steven

Posted by Steven Chan on April 04, 2012 at 04:06 AM PDT #

Hi Steven,

The document is very informative when you check specific table or module. But we are in need of a full report for the whole changes. We start to export the data from web for the prioritized modules but it's time consuming.
Is there any place to get this whole report in one table which is proper to export in excel or in any database?

Thanks,
Melike

Posted by Melike on April 27, 2012 at 05:30 AM PDT #

Hi, Melike,

We don't have an export feature at this point. That's a great idea, and the team that built this tool will consider whether this can be done for a future update. That might be a bit tricky due to the way the reports are built, though, so this feature's inclusion isn't a sure thing.

Good luck with your upgrade.

Regards,
Steven

Posted by Steven Chan on April 30, 2012 at 03:10 PM PDT #

Hi,
Is there a datamodel comparison report available for Oracle EBS 12.2?
Thanks,
Hari

Posted by Hari on June 19, 2012 at 06:36 AM PDT #

Hi, Hari,

EBS 12.2 isn't released yet. We don't have any dates that we can share about that -- stay tuned to this blog for updates on that.

We'll provide more details about data model changes for EBS 12.2 after its release.

Regards,
Steven

Posted by Steven Chan on June 19, 2012 at 09:39 AM PDT #

Hello,

The note id is very helpful.

Can you help me with corresponding replacement object in R12 for 11i objects which are obsolete R12.
As the report just mentions that removed in R12

Regards,
Rajesh Subuddi

Posted by guest on January 10, 2014 at 07:00 AM PST #

Hello, Rajesh,

These reports are the only ones that are available. We don't have any reports specifically about obsolete objects, but it's safe to assume that removed objects are also obsolete.

Regards,
Steven

Posted by Steven Chan on January 10, 2014 at 11:11 AM PST #

Post a Comment:
  • HTML Syntax: NOT allowed
About

Search

Categories
Archives
« April 2014
SunMonTueWedThuFriSat
  
1
4
5
6
7
8
9
10
11
12
13
14
18
19
20
21
22
23
24
25
26
27
28
29
30
   
       
Today