5 Replies Latest reply on Aug 13, 2015 6:33 AM by yoonas

    How many modules are configured

    Mushy

      Hi,

       

      I need a query to check which modules are configured and used for an organization total number of modules configured and are in used any help please

       

       

      Thanks

        • 1. Re: How many modules are configured
          Ajith-Oracle

          You can find out what products are installed in e-Business Suite, and their patch levels, via Oracle Applications Manager.

          You will also find a list of the installed by running the script <adutconf.sql> ($AD_TOP/sql/adutconf.sql), or in the file <applprod.txt>. You can find out the patch level of any product you have installed in e-Business Suite by running the following query via SQL:

          $ sqlplus apps / <pwd>

          SQL> SELECT substr(APPLICATION_SHORT_NAME,1,8) product,
                                    substr(PRODUCT_VERSION,1,14) version,
                                    substr(PATCH_LEVEL,1,11) patch_level,
                     FROM fnd_application a, fnd_product_installations p
                     WHERE a.application_id = p.application_id
                     ORDER BY application_short_name
                     /

          If you know the product code, you can obtain output for individual products with the following SQL:

           

          SQL> SELECT patch_level
                     FROM fnd_product_installations
                     WHERE patch_level LIKE '<product_code>'
                     /
          for example:          WHERE patch_level LIKE 'BIS'

          The product code is the 2- or 3-letter code you see when you search for a patch in Metalink by product family, and in the name of the patchset, e.g. 11i.BIS.L.

          As a double check that the database knows that the product is installed, you can run the following query. It should produce the same answer:

           

          SQL> SELECT fa.application_id id, fa.application_short_name app, fa.application_name, fpi.status,

          fpi.patch_level
                     FROM fnd_application_all_view fa, fnd_product_installations fpi
                     WHERE fa.application_id = fpi.application_id
                     AND fpi.patch_level LIKE '<product_code>'
                     /

           

           

          If you consider your question/issue as answered/solved,

          Please don't forget to mark Correct/Helpful answers in the thread. It helps other Community users to identify the solution quickly !


          Regards,

          Ajith

          • 2. Re: How many modules are configured
            Mushy

            Thanks for your reply but to elaborate it more

             

            Suppose i have three companies setup like A,B,C

             

            I want to check now for A how much total number of modules are configured and currently using

            similarly for B and C

             

             

            Thanks

            • 3. Re: How many modules are configured
              Ajith-Oracle

              This needs to be manually done for each instance.

              • 4. Re: How many modules are configured
                Mushy

                any help to check from query

                • 5. Re: How many modules are configured
                  yoonas

                  Hi,

                  I want to check now for A how much total number of modules are configured and currently using

                  similarly for B and C

                   

                  You get all installed produts information from fnd_product_installations. For licenced products you will find a status of 'I'. As oracle applications are integrated some module uses other modules even if they are not licensed such modules are with a status of 'S'. Modules which are not licensed are with the status of 'N'

                   

                  Tables

                  FND_PRODUCT_INSTALLATIONS

                  FND_APPLICATION

                   

                   

                  You will have to query in each instances if you have different instance for each company(A,B,C)

                   

                  Regards

                  Yoonas