You're almost there! Please answer a few more questions for access to the Applications content. Complete registration
Interested in joining? Complete your registration by providing Areas of Interest here. Register

What table(s) stores the Dynamic Skills SYNONYMS that are configured for each skill?

Summary:

When you configure dynamic Skills under "My Client Groups" —> "Profiles" —> "Item Catalog" (and clicking on the "Oracle Dynamic Skills Library" template type) you can then add/edit skills which depending on configuration allows you to input SYNONYMS for each skill. I can write my own BIP to get the skills but for some reason cannot find where the synonym data is stored. Here is SQL for Skills:

select CIT.*

from

HRT_CONTENT_ITEMS_B CIB,

HRT_CONTENT_ITEMS_TL CIT,

HRT_CONTENT_TYPES_B CTB

where 1=1

AND CIB.CONTENT_ITEM_ID = CIT.CONTENT_ITEM_ID

AND CTB.CONTEXT_NAME = 'SKILL'

Howdy, Stranger!

Log In

To view full details, sign in.

Register

Don't have an account? Click here to get started!