How to get IT resource Key from OIM using SQL query?

Question

To update child form lookup I need IT resource Key. Is there a SQL query for the same?

score 0 · Accepted Answer · answered Mar 08 '17 at 12:23

0

select ITRESOURCE_KEY from APP_INSTANCE where APP_INSTANCE_NAME ='<AppInstanceName>'

answered Mar 08 '17 at 12:23

Chaitanya K

score 0 · Answer 2 · answered Oct 06 '17 at 06:45

0

It resources keys are stored in table of SVR.

SELECT * FROM SVR

answered Oct 06 '17 at 06:45

Furkan

2 Answers2