Thank you for supporting the Cloud Customer Connect Community in 2024. It's a gift to work with you!

Look back
You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

Create Direct Database Query issue - R13

edited Mar 7, 2019 3:31AM in Reporting and Analytics for ERP 14 comments

Content

Hello,

I am new for Oracle Fusion BI and would like to run simple query to check this functionality but i couldn't able to find Connection Pool.

How to find connection pool. It SAAS environment . I am facing below error when i tried with simple query.

/*

Odbc driver returned an error (SQLExecDirectW).
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. (HY000)
State: HY000. Code: 43113. [nQSError: 43113] Message returned from OBIS. (HY000)
State: HY000. Code: 27022. [nQSError: 27022] Unresolved Connection Pool object: "FUSIONDB". (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('EXECUTE PHYSICAL CONNECTION POOL "FUSIONDB" select * from ap_invoices_all')}

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!