OBIEE Report Error — Oracle Analytics

Oracle Analytics Cloud and Server

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

Categories

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

OBIEE Report Error

Received Response
32
Views
5
Comments
3174977
3174977 Rank 5 - Community Champion
edited Aug 13, 2024 7:06PM in Oracle Analytics Cloud and Server

Hi All,

when we are running a report we are getting an error as below.

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: 6576, message: ORA-06576: not a valid function or procedure name at OCI call OCIStmtExecute: call apps.fnd_global.apps_initialize(1159, 20432, 275, 0,-1). [nQSError: 17011] SQL statement execution failed. (HY000)
Any thoughts on this.
Thanks !

Answers

  • Gianni Ceresa
    Gianni Ceresa Mod

    Hi,

    That's an Oracle DB error:

    3174977 wrote:

ORA-06576: not a valid function or procedure name at OCI call OCIStmtExecute: call apps.fnd_global.apps_initialize(1159, 20432, 275, 0,-1)

    Is your report supposed to call that procedure? Is the user connecting to the DB allowed to call that procedure?

    It's not really OBIEE's fault but more something to check in your DB (based on what account OBIEE uses to connect to it).

  • 3174977
    3174977 Rank 5 - Community Champion

    I will check on these details and update on this.

    Thanks Gianni !

  • Joel
    Joel Rank 8 - Analytics Strategist

    Hi @3174977

    a quick Google indicates that this (apps.fnd_global) is an Oracle Ebusiness suite package. This could mean a couple of things:

    1. The package is in an invalid state and not compiled.
    2. The user setup in the OBIEE connection pool doesn't have the execute privilege on the package
    3. There could be a missing synonym

    check on the database that the user setup in the connection pool has access to this package

  • Thomas Dodds
    Thomas Dodds Rank 8 - Analytics Strategist

    +1 to @Joel Acha

  • cesar.advincula.o
    cesar.advincula.o Rank 6 - Analytics Lead

    Apps.fnd_global there are parts of function of a.profile of users for Oracle business suite, these function set the org_I'd, ledger_id , etc. I know your issue it's a call of oci, however as saying good practice these function is more suitable to be part.of etl/elt process, returning to your issue, you.should use evaluate function(obi answer function).and pass the parameters that you should.pass.

    Kind regards,