Results for “skill_provision_id”

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

Overview

OTA_SKILL_PROVISIONS is a transaction table within the Oracle E-Business Suite Learning Management module (OTA). It stores skill and competency provisioning information associated with a specific version of a learning activity. Functionally, the table holds the "other information" type detail — free-form descriptive and analytical data — that an administrator associates with an activity version, most notably tie-backs to analysis criteria used by Oracle Learning Management and Oracle Human Resources competency frameworks.

The table is owned by the OTA schema and is documented as VALID in both Oracle EBS 12.1.1 and 12.2.2. Its ETRM metadata classifies it heuristically as satellite-leaning under a Data Vault modeling interpretation. That classification is a modeling suggestion only: the table behaves as a descriptive satellite attached to an activity-version hub, carrying attributes, timestamps, and audit columns rather than acting as an independent hub or a pure many-to-many link. Primary-key enforcement is provided by OTA_SKILL_PROVISIONS_PK on the SKILL_PROVISION_ID column.

Key Information Stored

The physical schema documented for 12.2.2 contains 32 columns. The most significant are:

• SKILL_PROVISION_ID — the surrogate primary key and the unique index (OTA_SKILL_PROVISIONS_PK). No alternate business-key unique index is documented; the surrogate key is the sole documented uniqueness constraint.
• ACTIVITY_VERSION_ID — foreign key to OTA_ACTIVITY_VERSIONS. This is the parent context: every provision row belongs to one activity version record.
• ANALYSIS_CRITERIA_ID — foreign key to PER_ANALYSIS_CRITERIA, linking the provision to an HR analysis criteria definition used for competency and skills assessment.
• TYPE — classifies the kind of skill provision being recorded.
• COMMENTS — free-text descriptive information supplied by the administrator.
• TSP_INFORMATION_CATEGORY and TSP_INFORMATION1 through TSP_INFORMATION20 — a descriptive flexfield-style attribute set (twenty generic segment columns plus a category discriminator) used to capture customer-defined additional data for the activity version.
• OBJECT_VERSION_NUMBER — the optimistic-locking column used by the Oracle Application Framework to detect concurrent updates.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATION_DATE, CREATED_BY — standard WHO audit columns recording who created and last changed each row and when.

Common Use Cases and Queries

Typical reporting requirements include listing all skill provisions for a given activity version, or tracing which analysis criteria are attached to a course or offering version. A representative join pattern is:

• Provision detail for a version: SELECT sp.skill_provision_id, sp.type, sp.analysis_criteria_id, sp.comments FROM ota_skill_provisions sp WHERE sp.activity_version_id = :version_id
• Criteria resolution: join ota_skill_provisions.analysis_criteria_id to per_analysis_criteria to obtain criteria names and definitions for competency reporting.
• Version roll-up: join ota_skill_provisions.activity_version_id to ota_activity_versions and onward to activity and offering tables to report skill provisions at the catalog level.
• Flexfield extraction: query TSP_INFORMATION_CATEGORY plus the relevant TSP_INFORMATIONn segments when customers have configured additional attributes.
• Audit and change tracking: filter on LAST_UPDATE_DATE to identify recently modified provisions for data-quality checks.

Related Objects

The most significant related objects, based on the documented foreign-key relationships and the surrounding Learning Management schema, are:

• OTA_ACTIVITY_VERSIONS — parent table; joined on OTA_SKILL_PROVISIONS.ACTIVITY_VERSION_ID = OTA_ACTIVITY_VERSIONS.ACTIVITY_VERSION_ID.
• PER_ANALYSIS_CRITERIA — referenced lookup for assessment criteria; joined on ANALYSIS_CRITERIA_ID.
• OTA_ACTIVITIES and OTA_ACTIVITY_OFFERINGS — reached through the version parent to report skill provisions at activity and offering level.
• OTA_SKILL_PROVISIONS_PK — the unique index enforcing the primary key on SKILL_PROVISION_ID.
• Learning Management concurrent programs and the OTA activity version maintenance forms, which create and update rows in this table through the standard OAF-based activity version UI.