Oracle Identity Governance(OIG12c): RQ_COMMENTS_MV and OIM_RECON_CHANGES_BY_RES_MV MATERIALIZED VIEWS Run Into Invalid Status (Doc ID 3077307.1)

Last updated on MARCH 19, 2025

Applies to:

Identity Manager - Version 12.2.1.4.230708 and later
Information in this document applies to any platform.

After applying some IDM SPB patch, the following Materialized Views(MV) could run into invalid status.

RQ_COMMENTS_MV

OIM_RECON_CHANGES_BY_RES_MV

For instance, one may find the following error after July 2023 SPB in patch_oim_wls.log and diagnostics log :

Patching OIM server with SPB

	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

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