Unable To See DFF's Data In OTBI Subject Area
(Doc ID 2899144.1)
Last updated on SEPTEMBER 28, 2022
Applies to:Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.22.04.0 and later
Information in this document applies to any platform.
On : 11.13.22.04.0 version, Supplier Reports
When attempting to see data in OBIEE report, we are able to see reports.
the following error occurs.
Odbc driver returned an error (SQLExecDirectW).
Error Codes: OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P
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: 43119. [nQSError: 43119] Query Failed: (HY000)
State: HY000. Code: 17001. [nQSError: 17001] Oracle Error code: 1427, message: ORA-01427: single-row subquery returns more than one row at OCI call OCIStmtFetch. (HY000)
State: HY000. Code: 17012. [nQSError: 17012] Bulk fetch failed. (HY000)
SQL Issued: SET VARIABLE PREFERRED_CURRENCY='User Preferred Currency 1';SELECT 0 s_0, "Enterprise Contracts - Contracts Real Time"."Contract Header Details"."ContractHeaderFlexfield_SERVICE_OWNE_v" s_1 FROM "Enterprise Contracts - Contracts Real Time" FETCH FIRST 75001 ROWS ONLY
The issue can be reproduced at will with the following steps:
1. Open BI Reports
2. Open Subject Area
3. Select DFF Columns to create reports in combination of OOTB columns
4. Open report
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