Supplier Management

Get Involved. Join the Conversation.

Topic

    Soumya Parhi
    How to track Supplier Logins , that are through the supplier...Answered
    Topic posted August 7, 2018 by Soumya ParhiGold Trophy: 10,000+ Points, last edited December 6, 2018, tagged Audit, Fusion, Security, Supplier User Account, Tip 
    104 Views, 10 Comments
    Title:
    How to track Supplier Logins , that are through the supplier portal ?
    Summary:
    Supplier Portal Login Audit
    Content:

    Good People,

    How to track the supplier logins form supplier portals ?

    Thanks,

    Soumya

    Document:
    Document:

    Best Comment

    Soumya Parhi

    Hi Piyush,

    I got it using How to Generate Fusion Application User Login Audit Report Using BI Publisher (Doc ID 2190558.1) .This is working awesome :)

    Thanks a ton for looking in to my question.

    Warmest Regards,

    Soumya

    Comment

     

    • Sunny Todkari

      Not aware of any such functionality available.

    • Piyush Singh

      That is right, we do not track supplier logins through Portal.

      Thanks,

      Piyush

    • Soumya Parhi

      Can we use the User Login Audit report ?

      Thanks,

      Soumya

    • Piyush Singh

      Hi Soumya,

      Can you share more information on the User Login Audit report that you are referring to?

      Thanks,

      Piyush

      • Soumya Parhi

        Hi Piyush,

        I got it using How to Generate Fusion Application User Login Audit Report Using BI Publisher (Doc ID 2190558.1) .This is working awesome :)

        Thanks a ton for looking in to my question.

        Warmest Regards,

        Soumya

    • Joost Hogerwerf

      Hi Soumya,

      I'm interested in exactly the same functionality (creating a report on supplier contact login).

      I can't find the document anywhere which you are referring to. Where did you find this? Can you share it?

      Thanks and kind regards,

      Joost

      • Soumya Parhi

        Hi Joost,

        I have now uploaded the details to the main post. You can download and use.

        Thanks,

        Soumya

        P.S. Please rate the Post if this helps.

    • Joost Hogerwerf

      Thanks a lot Soumya!

      I used it to as basis to create a specific supplier portal user login report which also shows the supplier the contact is related to:

      Select
      U.USERNAME
      ,HZP1.PARTY_NAME as NAME
      ,HZP2.PARTY_NAME as SUPPLIER
      ,TO_CHAR(A.LAST_LOGIN_DATE, 'DD-MM-YYYY') as LAST_LOGIN
      ,TO_CHAR(U.CREATION_DATE, 'DD-MM-YYYY') as USER_CREATION_DATE
      from
      FUSION.ASE_USER_LOGIN_INFO A
      , FUSION.PER_USERS U
      , HZ_PARTIES HZP1
      , HZ_PARTIES HZP2
      , HZ_RELATIONSHIPS HZR
      where
      1=1
      and A.USER_GUID = U.USER_GUID
      and U.USERNAME not like 'FUSION_APPS_%'
      and U.USERNAME not in ('weblogic_idm', 'oamAdminUser', 'IDROUser')
      and A.LAST_LOGIN_DATE IS NOT NULL
      and U.USER_GUID = HZP1.USER_GUID
      and HZP1.PARTY_ID = HZR.OBJECT_ID
      and HZR.SUBJECT_ID = HZP2.PARTY_ID
      order by A.LAST_LOGIN_DATE desc

       

      Kind regards,

      Joost