Tuesday, May 10, 2011

Get the update trigger fields

To get the update field trigger information from the database. Use the below SQL.

select * from lkv where lku_key = (select lku_key from lku where lku_type_string_key = 'Lookup.USR_PROCESS_TRIGGERS' and lku_type = 'l');

This will give you all the triggers on the USR table of OIM. The LKV decoded is the task name you should create under a process. (The tasks info is stored in MIL table)

Similarly for organization, use Lookup.ACT_PROCESS_TRIGGERS.