1 Reply Latest reply on Jun 7, 2015 6:16 AM by Pk

    Modules Utilization Report in EBS

    2718594

      Hi,

       

      We have 500 users which use different modules in Oracle ERP.

      I would like to know if I can get an Utilization Report or Script to know How many users are accessing each module

       

       

      Regards,

      Mahesh

        • 1. Re: Modules Utilization Report in EBS
          Pk

          Here is the SQL to get the list of users with applications assigned.

           

          SELECT DISTINCT

            FA.APPLICATION_NAME

          , FU.USER_NAME

          FROM

          FND_USER_RESP_GROUPS_ALL FURGA,

          FND_USER FU,

          FND_USER FUCB,

          FND_USER FULUB,

          FND_USER FULUL,

          FND_APPLICATION_VL FA,

          FND_RESPONSIBILITY_TL FRTL,

          FND_SECURITY_GROUPS FSG

          WHERE

          FURGA.USER_ID = FU.USER_ID

          AND FURGA.CREATED_BY = FUCB.USER_ID

          AND FURGA.LAST_UPDATED_BY = FULUB.USER_ID

          AND FURGA.LAST_UPDATE_LOGIN = FULUL.USER_ID

          AND FURGA.RESPONSIBILITY_APPLICATION_ID = FA.APPLICATION_ID

          AND FURGA.RESPONSIBILITY_ID = FRTL.RESPONSIBILITY_ID

          AND FRTL.LANGUAGE = 'US'

          AND FURGA.SECURITY_GROUP_ID = FSG.SECURITY_GROUP_ID

          ;

           

          Please mark Correct/helpful accordingly.