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.

Get OIM table field key

In the OIM API code, we need to use the field key rather than the actual database table field name. (example : "Users.First Name" or "Organizations.Created By")

All these are stored in the LKU table of OIM. Execute the below SQL to extract the complete list.

SELECT LKU_FIELD, LKU_TYPE_STRING_KEY FROM LKU WHERE LKU_TYPE='f' ORDER BY LKU_FIELD;

The part before the underscore in the LKU_FIELD indicates the table name.