Search Results bil_dimv_skills




Overview
Explore in AI Chat

Overview

The view BIL_DIMV_SKILLS belongs to the Oracle EBS Sales Intelligence (BIL) product family, a component of the Oracle Sales Analytics / Sales Intelligence reporting layer. In the ETRM 12.1.1 and 12.2.2 documentation the object is classified as Obsolete, and the metadata explicitly states "Not implemented in this database." Its declared purpose is to expose sales representative skills — that is, the competency, proficiency, and certification attributes associated with sales personnel. The view is a dimensional-style reporting view (indicated by the DIMV naming convention used throughout the BIL schemas) intended to feed analytics on workforce capability against the sales organization.

The term surfaced by the user's search, COMPETENCE_NAME, is the descriptive label of a competence held by a salesperson, and is the central column of this view. In the Sales Intelligence star schema, this view would typically serve as a source for a skills or competency dimension, allowing reporting on which sales reps hold which competences and at what proficiency.

Underlying Base Objects

Although the documented "referenced base objects" field is empty, the embedded view text reveals the true lineage. The first branch of a UNION ALL joins three objects:

The second branch of the union draws from FND_LOOKUPS (the Oracle Applications lookup table), selecting rows of LOOKUP_TYPE = 'BIL_VALUE_TYPE' with LOOKUP_CODE = '-999' to supply a "No Competence"/unknown placeholder row, a common pattern for augmenting dimensions with a default member.

Key Columns

Common Use Cases and Queries

Because the view is obsolete and not implemented in modern EBS installations, it is relevant mainly to legacy Sales Intelligence implementations and to documentation or migration efforts. Typical reporting scenarios include competence coverage analysis, proficiency distribution, and certification currency tracking. A representative query is:

SELECT person_name, competence_name, proficiency_level, certification_date
FROM bil_dimv_skills
WHERE competence_name IS NOT NULL
ORDER BY person_name, competence_name;

A proficiency summary might use:

SELECT competence_name, proficiency_level, COUNT(*) reps
FROM bil_dimv_skills
GROUP BY competence_name, proficiency_level;

When working with 12.1.1/12.2.2 environments, the underlying HR competency views (such as HRFV_COMPETENCE_PROFILES) should be queried directly, since BIL_DIMV_SKILLS is not created. Queries against it will return an ORA-00942 error unless the legacy Sales Intelligence patch set has been applied.