Disable OIM Materialized View Creation During OIM Schema Upgrade (Doc ID 2245794.1)

Last updated on MARCH 20, 2017

Applies to:

Identity Manager - Version 11.1.1.3.0 to 11.1.2.3.170117 [Release 11g]
Information in this document applies to any platform.

Symptoms

During OIM upgrade, Materialized view 'OIM_RECON_CHANGES_BY_RES_MV' is created as part script 'oim_mview_recon_changes_by_res.sql' execution.

This Materialized View is used to populate data for OIM Exception report 'Fine Grained Entitlement Exceptions By Resource' only.

As a result of this script execution, OIM Schema Upgrade (or PSA) completion is delayed.

Cause

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