OIM Trusted User Delete Reconciliation Job Deletes Non-System OIM User That Were Not Created By That Resource (Doc ID 2577367.1)

Last updated on JULY 26, 2023

Applies to:

Symptoms

The following KM explains in detail how OIM trusted deletion jobs work:

The problem is that OIM's Trusted User Delete Reconciliation Job (for any resource) will delete all non-system OIM Users (i.e. users withOUT usr_data_level = 1 or 2) such as:

- OIM Users created manually via the API or UI

- OIM Users created by other trusted recons

As an aside, below are the values which usr_data_level can have.  A 'null' value in the USR sql table is equal to a '0'.

0 : Data level that indicates that a row can be updated and/or deleted.
1 : Data level that indicates that a row cannot be updated and/or deleted.
2 : Data level that indicates that a row can be updated but not deleted.
3 : Data level that indicates that a row can be deleted but not updated.

Cause

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