Unable To See DFF's Data In OTBI Subject Area
(Doc ID 2899144.1)
Last updated on MARCH 25, 2024
Applies to:
Oracle Fusion Enterprise Contracts Management Cloud Service - Version 11.13.22.04.0 and laterInformation in this document applies to any platform.
Symptoms
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.
ERROR
-----------------------
Odbc driver returned an error (SQLExecDirectW).
Error Details
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
STEPS
-----------------------
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
Changes
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 |
| Changes |
| Cause |
| Solution |
| References |