My Oracle Support Banner

After Performing Extract, Transform,Load (ETL) Some Column Values Are Displayed as 'UNDEFINED' on Oracle Business Intelligence (OBI) reports (Doc ID 2792312.1)

Last updated on JULY 22, 2021

Applies to:

Oracle Product Lifecycle Analytics - Version 3.6.1 and later
Information in this document applies to any platform.

Symptoms


ACTUAL BEHAVIOR

Some attributes are not loaded in OPLA tables after ETL
Due to this these column values are displayed as 'UNDEFINED' on the Oracle Business Intelligence (OBI) reports


EXPECTED BEHAVIOR

The column values should be displayed correctly in OBI Reports after ETL is performed.


STEPS

The issue can be reproduced at will with the following steps:
1. Upgrade OBI 11g to 12c
2. Run the OBI Report
3. Some columns do not have values and shown as 'UNDEFINED'

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


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