Results for “ota_program_memberships_v”

24 results




Overview
Explore in AI Chat

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

Overview

OTA_PROGRAM_MEMBERSHIPS_V is a PL/SQL view owned by the APPS schema in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It belongs to the OTA product family, Oracle Learning Management (OLM), and its documented purpose is to list all members of a learning program event. A program event in OLM is a container that groups one or more offerings or activities under a single curriculum-like structure, and each row this view returns represents one membership record within that container.

The view denormalizes the parent OTA_PROGRAM_MEMBERSHIPS table by joining it to event and activity-version translation tables, so that consumers receive not only the raw membership attributes but also the event title, course start and end dates, and the activity version name in the session's language. This makes it suitable for reporting, concurrent programs, OAF page queries, and integration interfaces that need to enumerate program members without writing the multi-table join themselves. The view is marked VALID in the ETRM metadata, and all DBA references resolve through APPS synonyms rather than direct base-table references.

Underlying Base Objects

The view text is defined over five documented objects:

Because the translation tables are inner-joined with the session-language predicate, rows whose event or version lacks a translation in the current language will not be returned.

Key Columns

  • PROGRAM_MEMBERSHIP_ID — primary key of the membership record.
  • EVENT_ID — the parent program event to which the member belongs.
  • PROGRAM_EVENT_ID — the associated program event identifier exposed directly on the membership row; this is the column referenced by users searching on "program_event_id".
  • GROUP_NAME / GROUP_NAME_MEANING — group code and its decoded meaning from the PROGRAM_MEMBERSHIP_GROUP lookup.
  • ROLE / ROLE_MEANING — role code and its decoded meaning from the PROGRAM_MEMBERSHIP_ROLE lookup.
  • REQUIRED_FLAG — indicates whether the membership is mandatory for the program.
  • SEQUENCE — ordering of members within the program.
  • COMMENTS — free-text notes on the membership.
  • PMM_INFORMATION_CATEGORY and PMM_INFORMATION1–20 — the membership descriptive flexfield context and attribute columns.
  • TITLE, COURSE_START_DATE, COURSE_END_DATE, VERSION_NAME — descriptive columns pulled from the joined event and version translation tables.
  • OBJECT_VERSION_NUMBER, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN, CREATED_BY, CREATION_DATE, ROW_ID — standard concurrency and audit columns.

Common Use Cases and Queries

Typical uses include listing members of a given program event, reporting on required versus optional participants, and joining the view to event or delegate data for curriculum completion reporting. Sample query for a specific program event:

SELECT program_membership_id, event_id, program_event_id,
       group_name_meaning, role_meaning, required_flag, title
FROM   apps.ota_program_memberships_v
WHERE  event_id = :p_event_id
ORDER  BY sequence;

To locate a membership by the program_event_id the user searched on:

SELECT program_membership_id, event_id, group_name_meaning, role_meaning
FROM   apps.ota_program_memberships_v
WHERE  program_event_id = :p_program_event_id;

For flexfield-driven reporting, select PMM_INFORMATION_CATEGORY together with the populated PMM_INFORMATIONn columns, filtering on a known category, so that only the relevant context attributes are returned. Because HR_GENERAL.DECODE_LOOKUP performs a lookup on each row, high-volume extracts should filter on EVENT_ID or PROGRAM_EVENT_ID to limit the driving set before the lookup calls are evaluated.