Search Results certification_method

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:

• HRFV_COMPETENCE_PROFILES HCP — the HR competency profile source (person, competence, proficiency, certification and review dates).
• HRFV_REQUIRED_COMPETENCES HRC — the required/core competence definitions, filtered by CORE_COMPETENCE_FLAG = 'Y' and effective-dated against SYSDATE.
• BIL_DIMV_SALESFORCE BDS — the Sales Intelligence salesforce dimension, linking HCP.PERSON_ID to BDS.EMPLOYEE_PERSON_FK to restrict results to sales personnel.

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

• PERSON_ID — identifier of the sales representative; in the placeholder branch derived via TO_NUMBER(FL.LOOKUP_CODE).
• PERSON_NAME / BUSINESS_GROUP_NAME — the representative's name and the HR business group. In the -999 row these are assigned the lookup MEANING.
• COMPETENCE_NAME — the competence description; the column the user searched for.
• COMPETENCE_ID / BUSINESS_GROUP_ID — identifiers used as keys when joining back to detail facts or dimension tables.
• DATE_FROM / DATE_TO — validity dates of the competence profile, mapped to START_DATE_ACTIVE and END_DATE_ACTIVE in the placeholder row.
• PROFICIENCY_LEVEL — the assessed proficiency of the person against the competence.
• PROFICIENCY_RATING_SOURCE / CERTIFICATION_METHOD — source of the rating and the method by which certification was obtained.
• CERTIFICATION_DATE / NEXT_REVIEW_DATE — certification and next review dates.

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.