It's All About the Platform.

  • BI
    May 26, 2016

Logical and Relational Data Model Diagrams For Fusion Applications

Richard Bingham
Senior Development Manager


In this article we covered the changes to the delivery of content to support integration development work,
as Oracle Enterprise Repository was retired. Since then we've been asked how to access the data model
diagrams which were useful when working in BI Publisher to develop various point-solutions.


So we are pleased to offer the same PDF files for download. Due to size limitations these are available in the following ZIP files:

  • All Logical Data Model Diagrams here
  • Relational Data Model Diagrams for product names A to G
  • Relational Data Model Diagrams for product names H to O
  • Relational Data Model Diagrams for product names P to Z
We hope you find these useful once again.

Join the discussion

Comments ( 14 )
  • Sarah Friday, June 10, 2016

    Thanks for making these available again

  • Micha Monday, December 19, 2016

    Hi Richard,

    it seems that the module Absence Management (ANC) is missing entirely from these zip files. Could you add it, please?



  • guest Wednesday, December 21, 2016

    Hi Richard

    It's not available again... could you please make it available again?



  • Oliver Steinmeier Wednesday, December 21, 2016

    Hi Wira - what is "it" -- I tried the four links in the article and they all worked for me.

    Hi Micha - not sure that we can get them if they weren't originally published, but will look into it.



    Fusion Apps Developer Relations

  • Oliver Tuesday, January 3, 2017

    Micha, just to confirm, the diagrams are not available for Absence Management. Sorry.

    Best regards,


    Fusion Apps Developer Relations

  • Ashish Harbhajanka Friday, May 19, 2017
    I tried to navigate to all the four links but it says Error.

    Any plans to have them back.

    Kind Regards
  • Richard Bingham Friday, May 19, 2017
    Please try again. This was due to redirects are not yet active post migration.
  • Ashish Harbhajanka Friday, May 26, 2017
    Thanks Richard, I am able to access the links now.
  • Ian Friday, May 26, 2017
    Hi Richard,

    Firstly, thanks for this and your other very useful posts.

    I was wondering if you are able to get more recent versions of these (since r12 for example).

    In addition, do you know if there have been many changes since you released these?

    Like Micha (above) I am also working on absence on my current project and these would be especial useful so its a shame that these are not available!

    Thanks again

  • Richard Bingham Friday, May 26, 2017
    Hi Ian
    We do not have any updated documents available I am afraid. Kind regards,
  • Mark Bilger Thursday, August 17, 2017
    While the individual logical subject area models are useful, it would be even more helpful if Oracle published an overall logical model. I am specifically interested in HCM due to Exelon's current project to deploy. Thank you - Mark
  • Hany Thursday, February 22, 2018
    The time stamp on the files is 2011. Are these upto date?
  • Oliver Steinmeier Friday, February 23, 2018

    I think the timestamps vary a bit; some of them are from 2013 or later.

    That said, I don't think they are actively being maintained anymore, which is why they were removed from the replacement site for OER. As the products evolve, they will unfortunately become less accurate (though the core structures of products tend to remain fairly static in my experience).

    Best regards,
    Oliver Steinmeier
    Fusion Apps Developer Relations
  • Anish Tuesday, July 3, 2018
    The relation data models and logical model are helped us.
Please enter your name.Please provide a valid email address.Please enter a comment.CAPTCHA challenge response provided was incorrect. Please try again.