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.
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.
No comments:
Post a Comment