Order Management

Get Involved. Join the Conversation.

Topic

    Shyam Singh Patel
    Query SQL Data "Create Direct from Database"
    Topic posted October 9, 2018 by Shyam Singh PatelSilver Trophy: 7,500+ Points, last edited January 18, 2019, tagged Order Management, Order Management Analytics, SCM, Supply Chain Financial Orchestration, Supply Chain Orchestration, Tip 
    113 Views
    Title:
    Query SQL Data "Create Direct from Database"
    Summary:
    Cloud- Query SQL Data "Create Direct from Database" - without limit of 200 Rows
    Content:

    Hi All,

    In Cloud R13 there is one way to run SQL Query direct on the database

    This Process eliminates the 200 Rows issue and gives different download options like Excel, PDF, Powerpoint, XML etc...
    Please follow this Link as updating the image option here is too clumsy 

    https://community.oracle.com/docs/DOC-1027192

    Connection Pool for Different Modules

    HCM_OLTP for HCM, 
    CRM_OLTP for CRM BI reports, 
    FSCM_OLTP for Finance/ERP related BI Reports
    For example:

    HCM - "HCM_OLTP"."Connection Pool"
    CRM - "CRM_OLTP"."Connection Pool"
    FIN and PROC - "FSCM_OLTP"."Connection Pool"
    Transportation Intelligence "Transportation Intelligence"."Connection Pool"

    As per Note 1675101.1 ID

    It's been confirmed via Bug 18652706- ('EXECUTE DIRECT DATABASE REQUESTS' ONLY WORKS FOR BI ADMINISTRATOR ROLE ) that its usage is not supported within the CLOUD for any user, even a user with BI Administrator role.
    Please meet your reporting requirements using the OTBI Subject Areas rather than Direct DB Requests.  
    Alternatively, consider using BI Publisher to meet your reporting requirements.

    The ability to run Direct Database Requests with a user with BI Administrator role will be removed in a future release.

     

    Regards

    Shyam

     

    Please see following Metalink Note ID for all in One solutions
    https://community.oracle.com/docs/DOC-890633

    If you are happy with the Document, please mark as Helpful by doing so this will provide assistance for other people looking for answers to their queries.

     

     

    Version:
    18.10
    Document:
    1.jpg (30KB)
    Document:
    2.png (50KB)
    Document:
    3.jpg (90KB)
    Document:
    4.jpg (72KB)
    Video:
    5.jpg (64KB)