Results for “ota_cert_cat_inclusions”

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

Overview

OTA_CERT_CAT_INCLUSIONS is a Learning Management table in the OTA schema within Oracle E-Business Suite 12.1.1 and 12.2.2. It defines the membership relationship between a certification and a certification category usage, effectively stating that a given certification belongs within a particular type of category. This is a core construct in the Oracle Training Administration (OTA) certification model, enabling certifications to be grouped, classified, and reported along category lines rather than treated as free-standing definitions.

From a dimensional modeling perspective, the heuristic Data Vault classification for this object is standalone. Because the table is not tied to parent hubs through documented foreign-key dependencies, it is best modeled as an independent link-style relationship table whose composite business key defines the association itself. Analysts designing conformed dimensions around certifications should treat this table as the intersection that binds a certification to a category usage rather than as a dependent child of either entity.

Key Information Stored

The table carries 32 documented columns. The most significant for functional and reporting work are:

• CERTIFICATION_ID — identifies the certification included in the category; part of the unique business key.
• CATEGORY_USAGE_ID — identifies the category usage to which the certification is assigned; part of the unique business key.
• START_DATE_ACTIVE and END_DATE_ACTIVE — define the effective date range during which the inclusion is active, supporting date-tracked reporting.
• PRIMARY_FLAG — indicates whether the inclusion is the primary category assignment for the certification.
• OBJECT_VERSION_NUMBER — supports optimistic locking for concurrent updates.
• CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — the standard EBS WHO columns for auditability.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE20 — the standard DFF/extension columns reserved for descriptive flexfield storage.

The unique index OTA_CERT_CAT_INCLUSIONS_UK1 on (CERTIFICATION_ID, CATEGORY_USAGE_ID) is the documented business-key candidate, enforcing that a certification may appear only once per category usage. No separate surrogate single-column primary key is documented, so the composite unique key serves as the effective key of record.

Common Use Cases and Queries

Typical scenarios include listing all certifications tied to a category usage, identifying the primary category for a certification, and producing point-in-time reports filtered by active date range. A representative query follows:

SELECT cci.CERTIFICATION_ID,
       cci.CATEGORY_USAGE_ID,
       cci.PRIMARY_FLAG,
       cci.START_DATE_ACTIVE,
       cci.END_DATE_ACTIVE
FROM   OTA.OTA_CERT_CAT_INCLUSIONS cci
WHERE  TRUNC(SYSDATE) BETWEEN cci.START_DATE_ACTIVE
                          AND NVL(cci.END_DATE_ACTIVE, TRUNC(SYSDATE))
AND    NVL(cci.PRIMARY_FLAG, 'N') = 'Y';

Reporting uses include certification catalog extracts, category utilization analysis, and feeds into downstream learning compliance dashboards. Because the table is standalone, joins to certification and category usage master data are performed on CERTIFICATION_ID and CATEGORY_USAGE_ID directly rather than through documented FK constraints.

Related Objects

• Certification definition tables linked via CERTIFICATION_ID, providing the certification master attributes.
• Category usage tables linked via CATEGORY_USAGE_ID, supplying the category type context.
• OTA certification APIs and concurrent programs that create, update, or expire inclusions using the WHO and OVN columns.
• DFF value sets associated with ATTRIBUTE_CATEGORY and the ATTRIBUTE1–20 segments.
• Learning management reporting views that expose certification-to-category relationships for BI Publisher and OBIEE.

Because the documented relationship data marks this table as standalone, integrators should validate referential integrity to certification and category usage masters outside the database-enforced constraint set.