Results for “ota_offerings”

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

Overview

OTA_OFFERINGS is a core transactional table within the Oracle E-Business Suite (EBS) Learning Management module (OTA). In Oracle EBS 12.1.1 and 12.2.2, an offering represents a scheduled, deliverable instance of a course — the child object that inherits the definition and content of its parent course while carrying its own delivery logistics, pricing, capacity, and language attributes. Where a course defines what is taught, an offering defines when, how, to how many, and at what cost it is delivered.

The table is owned by the OTA schema and is documented as VALID in ETRM 12.2.2 with 54 physical columns. From a Data Vault modeling perspective, the mined foreign-key structure suggests this object behaves as a link entity: it sits between the learning-object definition layer and the activity-version layer, resolving associations among offerings, learning objects, activity versions, languages, and resources. Practically, it functions as the operational backbone for enrollment, scheduling, and resource planning in the Learning Management product.

Key Information Stored

The table is uniquely identified by the surrogate primary key OFFERING_ID, enforced through the OTA_OFFERINGS_PK unique index. This single-column index is the only documented business-key candidate; no composite alternate key is exposed in the ETRM metadata, so OFFERING_ID is the authoritative row identifier.

• OFFERING_ID — surrogate primary key; the join anchor for all child tables.
• ACTIVITY_VERSION_ID — foreign key to OTA_ACTIVITY_VERSIONS, tying the offering to a specific versioned activity definition.
• LEARNING_OBJECT_ID — foreign key to OTA_LEARNING_OBJECTS, linking the offering to its underlying learning object and, transitively, to its parent course.
• LANGUAGE_ID / LANGUAGE_CODE — foreign key to CSS_DEF_LANGUAGES_B plus a denormalized language code for the offering's delivery language.
• START_DATE / END_DATE — the effective delivery window of the offering.
• DELIVERY_MODE_ID — reference to the delivery method (for example, instructor-led, self-paced, or web-based).
• DURATION / DURATION_UNITS — the length of the offering and its unit of measure.
• MINIMUM_ATTENDEES / MAXIMUM_ATTENDEES / MAXIMUM_INTERNAL_ATTENDEES — enrollment thresholds used for scheduling and cancellation logic.
• ACTUAL_COST / BUDGET_COST / BUDGET_CURRENCY_CODE — cost tracking fields for financial analysis.
• STANDARD_PRICE / CURRENCY_CODE / PRICE_BASIS — pricing basis and charge amount for the offering.
• VENDOR_ID — external supplier when the offering is outsourced.
• OWNER_ID / BUSINESS_GROUP_ID — ownership and multi-org (business group) partitioning.
• OBJECT_VERSION_NUMBER — optimistic locking column used by the OTA APIs and forms.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE20 — the standard EBS DFF (descriptive flexfield) block for customer extensions.
• CREATED_BY / CREATION_DATE / LAST_UPDATED_BY / LAST_UPDATE_DATE / LAST_UPDATE_LOGIN — standard WHO audit columns.

Common Use Cases and Queries

Typical reporting and integration scenarios include catalog listings of offerings by course, enrollment-capacity analysis, delivery-mode and language distribution, cost-versus-budget variance, and vendor spend on outsourced training. A representative query joins the offering to its learning object and activity version:

• SELECT o.offering_id, o.start_date, o.end_date, o.delivery_mode_id, o.standard_price FROM ota_offerings o WHERE o.business_group_id = :bg AND o.end_date >= SYSDATE;
• SELECT o.offering_id, l.object_title FROM ota_offerings o, ota_learning_objects l WHERE o.learning_object_id = l.learning_object_id;
• SELECT o.offering_id, e.event_id FROM ota_offerings o, ota_events e WHERE o.offering_id = e.offering_id; — to enumerate scheduled events tied to each offering.
• Capacity reports using MINIMUM_ATTENDEES and MAXIMUM_ATTENDEES against actual enrollment counts from OTA_RESOURCE_USAGES.

Related Objects

The following objects are the most significant parents, children, and dependents of OTA_OFFERINGS:

• OTA_LEARNING_OBJECTS — parent referenced by OTA_OFFERINGS.LEARNING_OBJECT_ID; supplies the course/object definition.
• OTA_ACTIVITY_VERSIONS — parent referenced by OTA_OFFERINGS.ACTIVITY_VERSION_ID; supplies the versioned activity structure.
• CSS_DEF_LANGUAGES_B — parent referenced by OTA_OFFERINGS.LANGUAGE_ID; language lookup.
• OTA_EVENTS — child table referencing OTA_OFFERINGS.OFFERING_ID; holds individual scheduled class events.
• OTA_EVENT_ASSOCIATIONS — child table referencing OTA_OFFERINGS.OFFERING_ID; links events and offerings for composite scheduling.
• OTA_RESOURCE_USAGES — child table referencing OTA_OFFERINGS.OFFERING_ID; captures instructors, rooms, and equipment consumed.