How To Replace Old LOV Values With Active Ones in BI Report?

(Doc ID 2133848.1)

Last updated on JUNE 15, 2016

Applies to:

Oracle Fusion Sales Cloud Service - Version and later
Information in this document applies to any platform.


When a user has disabled few LOV values in the Application, same must not appear in the reports on the old records.


1. Go to Application Composer and Disable some lookup values
2. Go to SUI or Classic UI and see in the dropdown the values are not there anymore
3. Go to that employee X oppties and see that the Field is empty now (which is correct)
4. Go to BI reports and do a report with:

a. Owner

b. Oppty

c. Field (with lookup)

In the BI report, the old disabled LOV values still appear in the old opportunities record. This is incorrect.

How can we overwrite the old values with active LOV values in the BI report?


Sign In with your My Oracle Support account

Don't have a My Oracle Support account? Click to get started

My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms