Skip to Main Content

Security Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Custom Lookup table (other than LKU/LKV)

User648867-OracleNov 13 2008 — edited Nov 17 2008
Hi,

I know there are bunch of discussions about lookups, and sorry if this is a repeat question. My question is around populating lookup values that represent the groups in our target system. The usual method is to have a SchedulerTask that calls on the tcLookupOperationsIntf to load these groups into OIM DB which finally settles down in LKU/LKV tables. The problem I have is there could be 1000s of groups out in the target system and is it recommended to dump all of these in the standard OIM lookup tables? Is it efficient? If not, how do I create a custom lookup table, populate with group data, and manage it just like OIM does with regards to indexing, sequence ids etc. Do I have to write my own SQLs or OIM has any interfaces to handle these values?

Has anyone done similar things? Please let me know

Thanks a lot
SK
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Dec 15 2008
Added on Nov 13 2008
8 comments
1,118 views