Oracle Analytics Publisher

Home› Oracle Analytics› Oracle Analytics Forums› Oracle Analytics Cloud and Server› Oracle Analytics Publisher

Categories

Welcome to the Oracle Analytics Community: Please complete your User Profile and upload your Profile Picture

Last login of service account

Received Response
16
Views
2
Comments
V P Aravind
V P Aravind Rank 3 - Community Apprentice
in Oracle Analytics Publisher

Summary:

I would like to find when a particular service account last logged in either through UI or through Webservice or both in Oracle ERP Fusion. Is there any SQL query to run BIP report.

Version (include the version you are using, if applicable):

25C

Tagged:

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,
    You should ask in the forum covering your Fusion ERP, because it's a data question and not a technical feature of Publisher.

    It is a parallel and independent forum, covering all the Fusion products, including their data sources (queries etc.) and analysis: https://community.oracle.com/customerconnect

  • RVohra
    RVohra Rank 7 - Analytics & AI Coach

    Can you try this SQL in BIP (if available in your data model):

    SELECT   

     ul.USER_NAME,    ul.EMAIL_ADDRESS,    ul.START_DATE,    lh.LOGIN_DATE,    lh.LOGOUT_DATE,    lh.SESSION_ID,    lh.CLIENT_HOST_NAME,    lh.CLIENT_IP_ADDRESS,    lh.LOGIN_TYPE -- e.g., UI, WebService

    FROM    FND_USER ul    

    JOIN FND_LOGIN_HISTORY lh        ON ul.USER_ID = lh.USER_ID

    WHERE    ul.USER_NAME = :SERVICE_ACCOUNT