My Oracle Support Banner

How To Fetch Employee and Assignment Skill Based On Skill Items , Which Are Stored on S_EMP_SKILL_IT Table (Doc ID 2793181.1)

Last updated on OCTOBER 06, 2021

Applies to:

Siebel CRM - Version 16.11 [IP2016] and later
Information in this document applies to any platform.


 Out of box , Data based on Employee's positions and associated skills and skill items can be exported using UI.

To export data for positions and associated skills and skill items,

- Navigate to the Administration - Group screen, Positions view.

- Drill down on a position record to go to the list view and display associated skill and skill item data.

- Note the button in the top applet labeled Export Skill Data.

Employee 's  Assignment skills are store in S_EMP_SKILL table and assignment skill items in S_EMP_SKILL_IT table. As per requirement need to fetch Employee data who has specific Assignment Skill Items .

How to fetch Employee based on Assignment Skill Items not based on Assignment skill not based on Position?


To view full details, sign in with your My Oracle Support account.

Don't have a My Oracle Support account? Click to get started!

In this Document

My Oracle Support provides customers with access to over a million knowledge articles and a vibrant support community of peers and Oracle experts.