Search Results bom_operation_skills




Overview
Explore in AI Chat

Overview

BOM_OPERATION_SKILLS is a table in the BOM (Bills of Material) schema of Oracle E-Business Suite, documented as valid in releases 12.1.1 and 12.2.2. It holds the skill, competence, and qualification requirements that a manufacturing operation demands of the resources assigned to perform it. In the Oracle EBS manufacturing model, a routing operation may specify the labor skills required to complete the work; BOM_OPERATION_SKILLS is the intersection object that captures those requirements and links them to the operation, the standard operation, the resource, and the human-resources competence definitions held in the PER and MSD schemas.

The ETRM relationship metadata classifies this object heuristically as standalone within a Data Vault model. In practice it behaves as a link-style or junction structure: it resolves many-to-many relationships between routing operations and the competence and rating definitions owned by Oracle HRMS, rather than acting as a transactional fact or a descriptive satellite. Modelers treating this as a Data Vault artifact may find it useful to represent the operation-to-competence association as a link, with the qualifier attributes carried alongside.

Key Information Stored

The table exposes 13 documented columns. The most functionally significant are:

No surrogate single-column primary key is documented in the supplied metadata; the identifying business key is effectively the combination of the operation sequence, organization, and competence/rating attributes. This composite key structure should be validated against the actual unique index in the target instance before relying on it in ETL logic.

Common Use Cases and Queries

Typical uses include skill-requirement reporting for a routed assembly, validating that assigned resources possess the required competences, and migrating routing skill data between environments. A representative join pattern follows:

  • Join BOM_OPERATION_SKILLS to PER_COMPETENCES on COMPETENCE_ID to resolve skill names.
  • Join to PER_RATING_LEVELS on RATING_LEVEL_ID for proficiency descriptions.
  • Join to WSM_OPERATION_DETAILS on STANDARD_OPERATION_ID for standard operation context.
  • Filter by ORGANIZATION_ID to scope results to a single inventory organization.

Because the table is read-mostly reference data, extracts are commonly driven by LAST_UPDATE_DATE for incremental loads into reporting or data-warehouse layers.

Related Objects

  • MSD_LEVELS — referenced via LEVEL_ID.
  • WSM_OPERATION_DETAILS — referenced via STANDARD_OPERATION_ID.
  • PER_COMPETENCES — referenced via COMPETENCE_ID.
  • PER_RATING_LEVELS — referenced via RATING_LEVEL_ID.
  • BOM_OPERATION_SEQUENCES — the routing operation entity joined via OPERATION_SEQUENCE_ID.
  • BOM_OPERATION_RESOURCES — resource assignments that consume these skill requirements.
  • BOM_ROUTINGS and related routing views — the parent structures giving operational context to each operation sequence.