Showing posts with label trigger. Show all posts
Showing posts with label trigger. Show all posts

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.