In OBIEE 12c, Oracle highly recommends to use Fusion Middleware Security Model.
One of the limitations in using initialization blocks is that Data Visualization doesn’t authenticate against init blocks.
Another important note is when migrating to FMW Security, users will not be able to login because the accounts were created in the Web Catalog with initialization blocks are not valid any more. When migrating, you will need to clean up the init block users form the Web Catalog and new valid accounts can then be created.
The below script will remove all the init block users from the Web Catalog cache.
NOTE: PLEASE TAKE A CATALOG BACK UP BEFORE RUNNING THIS SCRIPT. THESE CHANGES CAN NOT BE REVERTED.
To run the script, copy it over to a server and execute it. Script will prompt the Administrator to enter the catalog path.