Results for “program_membership_role”

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

Overview

APPS.OTA_PROGRAM_MEMBERSHIPS_V is a reporting view in the Oracle E-Business Suite (EBS) Learning Management (OTA) module, available in both 12.1.1 and 12.2.2. It presents the members of a learning program, exposing each membership record alongside its associated event and activity version descriptive attributes. The view is the primary read interface for consumer-facing reporting and integration concerning program membership, and it is the object returned when searching on the term "program_membership_group"—a reference to the GROUP_NAME column and the PROGRAM_MEMBERSHIP_GROUP lookup type that classifies it.

The view serves a normalization purpose: rather than requiring callers to join the program membership table to event, event translation, and activity version translation tables, and then to separately resolve lookup codes, the view delivers a flat, denormalized result set with decoded lookup meanings and language-filtered titles already applied. This makes it well suited to concurrent-program extracts, OBIEE or Discoverer reporting layers, and inbound/outbound integration interfaces where translated descriptions are required.

Underlying Base Objects

The view is owned by APPS and is defined over the following documented base objects:

• OTA_PROGRAM_MEMBERSHIPS (synonym) — the driving table, aliased PMM; supplies the membership identifier, group, role, sequence, comments, and descriptive flexfield columns.
• OTA_EVENTS (synonym) — aliased EVT; supplies course start and end dates and the activity version reference.
• OTA_EVENTS_TL (synonym) — aliased ENT; supplies the language-specific event title, restricted to the session language.
• OTA_ACTIVITY_VERSIONS_TL (synonym) — aliased TAV; supplies the language-specific version name.
• HR_GENERAL (package) — invoked as HR_GENERAL.DECODE_LOOKUP to translate the GROUP_NAME and ROLE lookup codes into user-facing meanings.

Joins are established on PMM.EVENT_ID = EVT.EVENT_ID, ENT.EVENT_ID = EVT.EVENT_ID, and EVT.ACTIVITY_VERSION_ID = TAV.ACTIVITY_VERSION_ID. Both translation tables are constrained by LANGUAGE = USERENV('LANG'), ensuring a single row per membership for the caller's language context.

Key Columns

• PROGRAM_MEMBERSHIP_ID — primary identifier for the membership record; ROWID is also exposed.
• EVENT_ID / PROGRAM_EVENT_ID — the member event and its parent program event.
• GROUP_NAME — the reserved-by lookup code classified by lookup type PROGRAM_MEMBERSHIP_GROUP; the decoded meaning is returned by HR_GENERAL.DECODE_LOOKUP('PROGRAM_MEMBERSHIP_GROUP', PMM.GROUP_NAME). This is the column most directly associated with the "program_membership_group" search term.
• ROLE — lookup code classified by PROGRAM_MEMBERSHIP_ROLE, with its decoded meaning also returned.
• REQUIRED_FLAG — indicates whether the membership is mandatory for the program.
• SEQUENCE — ordering of the member within the program.
• COMMENTS — free-text notes.
• TITLE, VERSION_NAME — translated event title and activity version name.
• COURSE_START_DATE, COURSE_END_DATE — scheduled delivery window for the member event.
• PMM_INFORMATION_CATEGORY through PMM_INFORMATION20 — descriptive flexfield context and attribute columns.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard audit and concurrency columns.

Common Use Cases and Queries

Typical applications include listing all members of a program event grouped by membership group or role, generating enrollment rosters with translated titles, and validating required memberships prior to program completion.

SELECT program_membership_id,
       event_id,
       program_event_id,
       group_name,
       role,
       required_flag,
       sequence,
       title,
       version_name,
       course_start_date,
       course_end_date
FROM   apps.ota_program_memberships_v
WHERE  program_event_id = :p_program_event_id
ORDER  BY sequence;

Filtering by decoded group meaning supports administrative and audit reporting:

SELECT p.program_membership_id,
       p.title,
       hr_general.decode_lookup('PROGRAM_MEMBERSHIP_GROUP', p.group_name) group_meaning
FROM   apps.ota_program_memberships_v p
WHERE  hr_general.decode_lookup('PROGRAM_MEMBERSHIP_GROUP', p.group_name) = :p_group_meaning;

Because translations are filtered by USERENV('LANG'), reports executed through concurrent programs inherit the responsibility's language setting; callers requiring all languages must query OTA_EVENTS_TL directly instead of this view.