2 Replies Latest reply on Apr 21, 2018 12:18 PM by Beauty_and_dBest

    How to get Lincensed Modules count in EBS FND table?

    Beauty_and_dBest

      EBS 12.2

      12c

      OL6

       

       

      In License Module dashboard window,  I see this summary page:

       

       

       

      Which APPS FND table can I select this info via sqlplus?

       

       

      Kind regards,

      jc

        • 1. Re: How to get Lincensed Modules count in EBS FND table?
          Bharat -Oracle

          Hi

           

          SELECT fat.application_name

                ,fa.application_id

                ,decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS

            FROM fnd_product_installations fpi

                ,fnd_application fa

                ,fnd_application_tl fat

          WHERE fpi.application_id = fa.application_id

             AND fat.application_id = fa.application_id

             AND fat.LANGUAGE = 'US';

           

          Best Regards

          Bharat

          • 2. Re: How to get Lincensed Modules count in EBS FND table?
            Beauty_and_dBest

            Thanks Bhar, 

             

            I got it revised

             

            SQL> SELECT decode(fpi.STATUS,'I','Licensed', 'N','Not Licensed','S','Shared','Undetermined') STATUS, count(*)

              2  FROM fnd_product_installations fpi,fnd_application fa,fnd_application_tl fat

              3  WHERE fpi.application_id = fa.application_id AND fat.application_id = fa.application_id

              4  AND fat.LANGUAGE = 'US'

              5  group by status;

             

            STATUS         COUNT(*)

            ------------ ----------

            Licensed            153

            Not Licensed         12

            Shared               11

             

            SQL>

             

             

            Kind regards,