Results for “resource_skill_id”

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

AHL_RESOURCE_SKILLS is a table in the AHL schema, belonging to the Complex Maintenance Repair and Overhaul (AHL) product family in Oracle E-Business Suite, documented under ETRM for releases 12.1.1 and 12.2.2. Its stated purpose is to store the relationship between an ASO (Application Service Object) resource and Human Resources' skill type, skill level, and certification data. The ETRM description notes that the object is intended to become obsolete in a subsequent release, so implementations should treat it as a transitional structure rather than a long-term integration point. In heuristic Data Vault terms — mined from its foreign key topology — the table presents as a link, resolving a many-to-many association between maintenance resources and HR competency definitions.

Key Information Stored

The table carries 28 documented columns. The most significant are:

• RESOURCE_SKILL_ID — surrogate primary key, enforced by the AHL_RESOURCE_SKILLS_PK constraint. This is the value users typically search on.
• AHL_RESOURCE_ID — foreign key to AHL_RESOURCES, identifying the maintenance resource that holds the qualification.
• COMPETENCE_ID — foreign key to PER_COMPETENCES, referencing the HR competency (skill type) definition.
• RATING_LEVEL_ID — foreign key to PER_RATING_LEVELS, capturing the proficiency or skill level attained.
• QUALIFICATION_TYPE_ID — foreign key to PER_QUALIFICATION_TYPES, indicating the nature of the qualification (for example, certification versus competency).
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-organization data segregation.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the Oracle Application Framework (OA Framework) to detect concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard WHO audit columns present across EBS transactional tables.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard extensibility (DDF) flexfield columns for customer-specific enrichment.

No alternate unique index is documented beyond the primary key, so the business key is effectively the composite of AHL_RESOURCE_ID, COMPETENCE_ID, and QUALIFICATION_TYPE_ID alongside the rating context. The surrogate RESOURCE_SKILL_ID should be treated as a system-generated identifier rather than a business-meaningful value, and joins should generally be driven from the foreign key columns instead.

Common Use Cases and Queries

Typical reporting scenarios include determining which resources hold a given competency, which certifications are approaching expiry, and how skill coverage maps against maintenance work requirements. A common lookup pattern retrieves all skills for one resource:

• SELECT rs.resource_skill_id, rs.ahl_resource_id, rs.competence_id, rs.rating_level_id, rs.qualification_type_id FROM ahl_resource_skills rs WHERE rs.ahl_resource_id = :resource_id;

To resolve descriptive names, join outward to the HR tables:

• SELECT r.ahl_resource_id, c.competence_name, l.rating_level_name FROM ahl_resource_skills rs JOIN per_competences c ON rs.competence_id = c.competence_id JOIN per_rating_levels l ON rs.rating_level_id = l.rating_level_id WHERE rs.ahl_resource_id = :resource_id;

Security-group-filtered queries should restrict on SECURITY_GROUP_ID using the standard FND security profile mechanism. Blame/audit reporting can use LAST_UPDATE_DATE and LAST_UPDATED_BY, while OBJECT_VERSION_NUMBER supports integration routines that must avoid stale updates.

Related Objects

• AHL_RESOURCES — parent resource master; joined on AHL_RESOURCE_SKILLS.AHL_RESOURCE_ID = AHL_RESOURCES.AHL_RESOURCE_ID.
• PER_COMPETENCES — HR competency definitions; joined on COMPETENCE_ID.
• PER_RATING_LEVELS — HR rating/skill-level definitions; joined on RATING_LEVEL_ID.
• PER_QUALIFICATION_TYPES — HR qualification type lookup; joined on QUALIFICATION_TYPE_ID.
• FND_SECURITY_GROUPS — multi-organization security grouping; joined on SECURITY_GROUP_ID.
• PER_ALL_PEOPLE_F — frequently joined indirectly through AHL_RESOURCES when reporting the person behind a resource and their associated competencies.

Because the table is flagged for obsolescence, developers should avoid embedding its columns in new customizations and instead consider the successor HR competency structures for future releases.