Oracle Identity Manager: Query "Resource History Data"
MarkVTJun 7 2012 — edited Jun 7 2012Trying to find out where OIM stores the actual "data" attached to a provisioning task ( i.e. a task in the resource history )...
Have been able ( e.g. for the eBusiness Suite User resource ), to query the resource history, but need to find out what the details of the task are ( e.g. what role actually did get assigned in task "assign role to user" or what role got revoked in "revoke role from user" task...
select usr_login, usr.usr_key, pkg.pkg_name, mil.mil_name, mil.mil_child_table_name, rsc_desc, rsc_Data, osi.*
from oim_oim.usr
, oim_oim.orc
, oim_oim.pkg
, oim_oim.osi
, oim_oim.mil
, oim_oim.rsc
where orc.usr_key = usr.usr_key
and pkg.pkg_key = orc.pkg_key
--and ( pkg_system is null or pkg_system != 1 )
and osi.orc_key = orc.orc_key
and mil.mil_key = osi.mil_key
and rsc.rsc_key = osi.rsc_key
and orc.orc_key =29650
;
Have gotten to the OSI table with this query, so I get the status & description
eBusiness Suite User Create User User created successfully
eBusiness Suite User Reconciliation Update Received Reconciliation Event Processed
eBusiness Suite User Add Role to User UD_EBS_RLS Error occured. Please see the log for details of error.
eBusiness Suite User Add Role to User UD_EBS_RLS Error occured. Please see the log for details of error.
eBusiness Suite User Add Role to User UD_EBS_RLS Error occured. Please see the log for details of error.
eBusiness Suite User Revoke Role from User UD_EBS_RLS Role grant revoked successfully.
eBusiness Suite User Reconciliation Update Received Reconciliation Event Processed
eBusiness Suite User Add Role to User UD_EBS_RLS Role Added successfully
As u can see, I have a "Revoke Role From User" activity, which I can't link to the role getting revoked... the child table ( mil ) says UD_EBS_RLS, but the osi_child_Table_key doesn't exist there...
Any pointers? Directions?
Thx,