What to do when entitlement is deleted but it appeares active in LKV and Ent_list tables
I have an issue where entitlements from a connected system got deleted in catalog.
there were no changes from target system and on OIM system, but the entitlements just got deleted. I have checked the Oracle documentation and found what could be the issue, but its not same issue. its strange that the entitlements only get deleted in Catalog table but not in LKV or ENT list...
This is the response from an SQL query that Oracle suggested to check.
Query:
SELECT
c.entity_key,
c.entity_display_name,
c.is_deleted,
e.ent_list_key,
e.ent_display_name,