My Oracle Support Banner

OBIA 11g: Errors In Buyer Productivity Dashboard In Procurement (Doc ID 1569839.1)

Last updated on JULY 11, 2022

Applies to:

Business Intelligence Applications Consumer - Version 11.1.1.7.0 and later
Information in this document applies to any platform.

Symptoms

OBIA 11.1.1.7.1

Source system is PeopleSoft FSCM 9.1. - Procurement

There is an issue with Buyer Productivity Dashboard.

No data is displayed for the dashboard and shows the following errors

 

Error
View Display Error
Odbc driver returned an error (SQLExecDirectW).
  Error Details
Error Codes: OPR4ONWY:U9IM8TAC:OI2DL65P:OI2DL65P
State: HY000. Code: 10058. [NQODBC] [SQL_STATE: HY000] [nQSError: 10058] A general error has occurred. [nQSError: 43113] Message returned from OBIS. [nQSError: 90009] An error occurred while querying UI hints from ADF. [nQSError: 46119] Failed to open HTTP connection to server <hostname> at port <port>. [nQSError: 46131] Unresolved host name: <hostname>. Could not get details about the specified host (HY000)
SQL Issued: {call NQSGetQueryColumnInfo('SELECT CAST("Time - Approved Date"."Report Date" AS DATE) FROM "Procurement - Requisitions Real Time"')}
SQL Issued: SELECT CAST("Time - Approved Date"."Report Date" AS DATE) FROM "Procurement - Requisitions Real Time"

 

Cause

To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!


In this Document
Symptoms
Cause
Solution
References


My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.