1. Get rid of all advertisements and get unlimited access to documents by upgrading to Premium Membership. Upgrade to Premium Now and also get a Premium Badge!

Oracle Apps ER Diagrams

Discussion in 'General' started by vamsioracle, Mar 7, 2010.

  1. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Hi All,

    Could some one help me out with ER diagram for Apps All modules. How are module wise tables interlinked. Where can I get this data.

    Regards,
    Vamsi
     
  2. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
  3. apps_expert

    apps_expert Forum Expert

    Messages:
    325
    Likes Received:
    28
    Trophy Points:
    330
    Location:
    Chennai, India
    Re: ER Diagram for Apps

    Hi Vamsi, did you finally get the ER diagram? I need one currently, a detailed one. Could you share if you have it.
     
  4. vamsioracle

    vamsioracle Forum Expert

    Messages:
    98
    Likes Received:
    1
    Trophy Points:
    140
    Re: ER Diagram for Apps

    hey..

    I haven't :-(.. i am searching for the Er diagram.. I remember i had a pdf with module specific ER diagrams, i.e. one for AP , one for GL. but i lost in.. trying very hard to recover.

    I will share it when i get..

    Thanks
    Vamsi
     
  5. Sadik

    Sadik Community Moderator Forum Guru

    Messages:
    1,906
    Likes Received:
    252
    Trophy Points:
    1,455
    Re: ER Diagram for Apps

    Hi guys,

    You should check out the eTRMs at etrm.oracle.com.

    Once you login, you should click on Diagrams and PDF Files in the left. That lists all the available ER diagrams module wise. You can use that to build a complete ER diagram for tables you need.
     
  6. sapnovice

    sapnovice Guest

    The problem with pre-built models is that they never quite have the tables you want. We use a tool called Saphir from Silwood Technology that extracts the table definitions and relationships from the E-Biz data dictionary and then lets you search and subset to the exact set of tables you want. Then you can create a data model of it. We do this in PowerDesigner but I think it does ERwin, etc. (and Visio I think).

    Hope that helps.
     
  7. Malo

    Malo Starter

    Messages:
    1
    Likes Received:
    0
    Trophy Points:
    10
    Location:
    France

    Attached Files: