Search Results certification_required

Overview

WIP_OPERATION_SKILLS_V is a Work in Process (WIP) reporting view owned by the APPS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. The view exposes the skill, competence, and qualification requirements attached to discrete manufacturing operations. Its defining characteristic is the derived SKILL_LEVEL column, which is the attribute most frequently searched for under this object name. That column is not stored in the underlying WIP table; it is constructed at query time by concatenating the rating scale step value and the rating level name (for example, "3-Advanced"), and is forced to NULL when the rating level is absent.

The view is not a base data-entry object. It is a read-only reporting and integration surface used by shop-floor competency reports, manufacturing execution integrations, and custom extensions that need a flat, denormalised representation of operation-level skill requirements without joining four separate tables.

Underlying Base Objects

The view is defined over four objects, all reached through APPS synonyms: WIP_OPERATION_COMPETENCIES (the driving table), PER_COMPETENCES, PER_RATING_LEVELS, and PER_QUALIFICATION_TYPES. WIP_OPERATION_COMPETENCIES holds the transactional link between a WIP entity, an operation sequence number, an organisation, a resource, and the required competence/rating/qualification identifiers. The three PER tables supply the descriptive text for those identifiers.

All three PER joins are outer joins. This is significant: a competence requirement can exist without a matching rating level record, and the view will still return the row, with COMPETENCE, SKILL_LEVEL, or QUALIFICATION set to NULL as applicable.

The WHERE clause enforces consistency between the rating level and the competence. The join is accepted when the rating level belongs to the same rating scale as the competence, or when the rating level is scoped directly to the same competence; it also passes when either side of the comparison is NULL, which preserves outer-joined rows.

LEVEL_ID is a hard-coded literal of 3, a discriminator retained from Oracle's Practice/Competency framework for identifying the source of a requirement. ROW_ID is exposed as WOSK.ROWID.

Key Columns

• ROW_ID — Rowid of the underlying WIP_OPERATION_COMPETENCIES row; the only unique handle in the view.
• LEVEL_ID — Constant 3, indicating an operation-level skill requirement.
• WIP_ENTITY_ID, OPERATION_SEQ_NUM, ORGANIZATION_ID, RESOURCE_ID — The manufacturing context. Together they identify the job or schedule, the operation within its routing, the plant, and the specific resource whose skill requirement is recorded.
• COMPETENCE_ID, COMPETENCE — Identifier and name of the required competence from PER_COMPETENCES.
• CERTIFICATION_REQUIRED — Flag from PER_COMPETENCES indicating whether formal certification is mandatory.
• RATING_LEVEL_ID, SKILL_LEVEL — The required proficiency. SKILL_LEVEL is the derived step-value/name string and is the primary reporting attribute.
• QUALIFICATION_TYPE_ID, QUALIFICATION — Optional qualification type name from PER_QUALIFICATION_TYPES.
• Audit columns — LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY.

Common Use Cases and Queries

Typical uses include shop-floor competency reporting, gap analysis between available operator skills and job requirements, and inbound integration feeds to MES systems requiring flattened skill data.

List all skill requirements for a discrete job:

SELECT WIP_ENTITY_ID, OPERATION_SEQ_NUM, RESOURCE_ID, COMPETENCE, CERTIFICATION_REQUIRED, SKILL_LEVEL, QUALIFICATION FROM APPS.WIP_OPERATION_SKILLS_V WHERE ORGANIZATION_ID = :org_id AND WIP_ENTITY_ID = :wip_entity_id ORDER BY OPERATION_SEQ_NUM, RESOURCE_ID;

Filter only requirements that carry an explicit rating:

SELECT WIP_ENTITY_ID, OPERATION_SEQ_NUM, COMPETENCE, SKILL_LEVEL FROM APPS.WIP_OPERATION_SKILLS_V WHERE ORGANIZATION_ID = :org_id AND SKILL_LEVEL IS NOT NULL;

Identify operations requiring certification:

SELECT DISTINCT WIP_ENTITY_ID, OPERATION_SEQ_NUM, COMPETENCE FROM APPS.WIP_OPERATION_SKILLS_V WHERE ORGANIZATION_ID = :org_id AND CERTIFICATION_REQUIRED = 'Y';

Because SKILL_LEVEL is a formatted string rather than a numeric or identifier column, sorting or grouping by proficiency should be performed on RATING_LEVEL_ID. Report authors should also account for the outer joins and the NULL-tolerant skill level when aggregating results per operation.