How To Replace Old LOV Values With Active Ones in BI Report?
Last updated on JUNE 15, 2016
Applies to:Oracle Fusion Sales Cloud Service - Version 22.214.171.124.0 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:
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