3 Replies Latest reply on May 23, 2011 10:14 AM by 854289

    Physical Data Model For GL

    user652652
      Hi Experts,

      I am new to Oracle Apps, I need Data Model for GL tables..from wherer we can get it.



      Please suggest !

      Regards
      S
        • 1. Re: Physical Data Model For GL
          Srini Chavali-Oracle
          Data models are available at https://etrm.oracle.com

          You will need a valid MOS account to access this site.

          HTH
          Srini
          • 2. Re: Physical Data Model For GL
            S.PDASH
            Hi,
            As you aware major part of GL is based on Chart of Account, Calander (GL Period) and Currency, you can check all tables related to these.

            You can use below query to get those tables :

            select from all_tables where table_name like 'GL%' and owner='GL'*
            and table_name not like 'GL_ALLOC%' and table_name not like 'GL_CONS%'

            Please do refer the doc suggested by the other expert in this thread..

            Regards,
            S.P DASH

            N.B : We believe you put a GL question in a wrong folder/Thread (Procurement) :).. you could have received a better response had it been in Finance folder.. :)
            • 3. Re: Physical Data Model For GL
              854289
              There is a tool called Saphir from Silwood Technology that is all about discovering metadata from packaes like EBiz. It lets you scope the set of tables you want and then export to things like Designer, Visio and ERwin.