Integrations and Extensions

Enterprise Resource Planning

Topic

    Pinaki Das
    Cloud instance name
    Topic posted March 26, 2019 by Pinaki DasRed Ribbon: 250+ Points, tagged Financials, Fusion Applications Integration, Procurement, Project Portfolio Management, SaaS Integration 
    225 Views, 4 Comments
    Title:
    Cloud instance name
    Summary:
    Query to fetch cloud instance name
    Content:

    Table: ASK_DEPLOYED_DOMAINS

    Schema: FUSION_SETUP

    The field EXTERNAL_VIRTUAL_HOST stores the external link

    Condition: DEPLOYED_DOMAIN_NAME='FADomain' (Check the domain name and replace the value)

    select         DEPLOYED_DOMAIN_ID,

     DEPLOYED_DOMAIN_NAME,

     EM_HOME_URL,

     INTERNAL_VIRTUAL_HOST,

     INTERNAL_VIRTUAL_PORT,

     EXTERNAL_VIRTUAL_HOST,

     EXTERNAL_VIRTUAL_PORT,

     JMX_PORT,

     NODE_MANAGER_PORT,

     ADMIN_HOST,

     ADMIN_PORT,

     LOGICAL_DOMAIN_ID,

     NODE_MANAGER_PROTOCOL,

     ADMIN_SERVER_NAME,

     APPLICATION_CLOUD_ID,

     INTERNAL_SERVER_PROTOCOL,

     EXTERNAL_SERVER_PROTOCOL,

     ADMIN_SERVER_PROTOCOL,

     OBJECT_VERSION_NUMBER,

     ENTERPRISE_ID,

     CREATION_DATE,

     CREATED_BY,

     LAST_UPDATED_BY,

     LAST_UPDATE_DATE,

     LAST_UPDATE_LOGIN

    From        ASK_DEPLOYED_DOMAINS

    Where  DEPLOYED_DOMAIN_NAME='FADomain'

    Version:
    18C

    Comment