Oracle Fusion Learning Cloud: OTBI Error: "Nonexistent column" After Updating to 24A
(Doc ID 3016807.1)
Last updated on APRIL 22, 2024
Applies to:
Oracle Fusion Learning Management Cloud Service - Version 11.13.24.01.0 and laterInformation in this document applies to any platform.
Symptoms
When attempting to run an analysis in Oracle Transactional Business Intelligence (OTBI) using the Workforce Learning - Learning Records Real Time subject area after updating to 24A, the following error occurs:
Error during query processing (SQLExecDirectW).
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: 27045. [nQSError: 27045] Nonexistent column: "<Dimension>"."<Column Name>". (HY000)
Where the column identified in the error is an Offering Descriptive Flexfield (DFF).
Searching for the DFF in the subject area, and the DFF no longer displays. After redeploying the DFF and running the ESS Job "Import Oracle Fusion Data Extensions for Transactional Business Intelligence", the Offering DFF still does not display in the Learning Records subject area.
The Offering DFF does display in the Workforce Learning - Learning Management Real Time subject area.
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 |