Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Oracle Identity Manager: Query "Resource History Data"

MarkVTJun 7 2012 — edited Jun 7 2012
Trying 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,
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 5 2012
Added on Jun 7 2012
3 comments
914 views