My Oracle Support Banner

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 later
Information 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 Codes: OAMP2OPY:OPR4ONWY:U9IM8TAC:U9IM8TAC:U9IM8TAC:OI2DL65P:OI2DL65P
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


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