nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Oracle Communities

Oracle Analytics and AI

Child Item

OBIEE Report Error

3174977

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 !

Find more posts tagged with

Accepted answers

All comments

Gianni Ceresa

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

I will check on these details and update on this.

Thanks Gianni !

Joel Acha

Hi @3174977

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

The package is in an invalid state and not compiled.
The user setup in the OBIEE connection pool doesn't have the execute privilege on the package
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

+1 to @Joel Acha

cesar.advincula.o

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,