Oracle Business Intelligence Applications

Home› Oracle Analytics› Oracle Analytics Forums› More Solutions› Oracle Business Intelligence Applications

Categories

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

Getting error while accessing the BI Reports in Procurement Cloud

Received Response
2
Views
4
Comments
Aditya Mathur
Aditya Mathur Rank 1 - Community Starter
in Oracle Business Intelligence Applications

Hi I am getting error while accessing the BI Reports from Browse Catalog in Cloud Procurement Instance.

Error

View Display Error
Odbc driver returned an error (SQLExecDirectW).

  Error Details

Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P

State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 43119] Query Failed: [nQSError: 17001] Oracle Error code: 12154, message: ORA-12154: TNS:could not resolve the connect identifier specified at OCI call OCIServerAttach. [nQSError: 17014] Could not connect to Oracle database. (HY000)

SQL Issued: SET VARIABLE PREFERRED_CURRENCY='Local Currency';SELECT 0 s_0, "Sourcing - Overview"."Supplier"."Supplier Name" s_1, "Sourcing - Overview"."Fact - Sourcing"."Negotiation Realized Savings" s_2, 100*"Sourcing - Overview"."Fact - Sourcing"."Negotiation Realized Savings"/sum("Sourcing - Overview"."Fact - Sourcing"."Negotiation Realized Savings") s_3 FROM "Sourcing - Overview" FETCH FIRST 75001 ROWS ONLY

Edit -Refresh

Answers

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner 
    3265609 wrote:ORA-12154: TNS:could not resolve the connect identifier specified at OCI call

    ^-- Looks like something is very rotten in the state of Denmark^H^H^H^H^H^H^HProcurement Cloud

  • 3264471
    3264471 Rank 1 - Community Starter

    Hello,

    I'm also facing same issue.

    Did you find solution for this issue? Please let me know.

    Thanks

    RK

  • [Deleted User]
    [Deleted User] Rank 2 - Community Beginner

    Seriously. It's TNS errors. Chase them. And if you can't because you don't have sufficient access then raise a severity 1 SR. Cloud shouldn't raise any TNS errors.

  • 3264471
    3264471 Rank 1 - Community Starter

    Thank you Christian.!!

    Will connect with Oracle for this issue.

    Thanks

    RK