Search Results ota_pvt_frm_thread_users




Overview
Explore in AI Chat

Overview

OTA_PVT_FRM_THREAD_USERS is a table in the OTA (Learning Management) schema of Oracle E-Business Suite, valid across both 12.1.1 and 12.2.2. It stores information about private messages posted by one person to another within the Oracle Learning Management discussion forum infrastructure. Each row represents an association between a forum thread and the individual participants who are granted visibility or access to that private thread.

The table acts as a junction between forum definitions and forum threads on one side, and the individual recipients of private messages on the other. Because it captures the many-to-many relationship between threads and their authorized participants, the metadata's heuristic Data Vault classification treats this as a link table. In Data Vault modeling terms, it is best modeled as a link table capturing the association between a forum thread hub and a person/contact hub, with the message-specific attributes carried as link or satellite attributes.

Key Information Stored

The documented physical schema contains 13 columns. The most operationally significant are:

The table does not expose a documented single-column surrogate primary key in the metadata. Instead, the row is effectively qualified by the combination of FORUM_THREAD_ID, FORUM_ID, and the participant identifiers (PERSON_ID/CONTACT_ID or AUTHOR_PERSON_ID), which serve as business-key candidates for uniqueness within a business group.

Common Use Cases and Queries

Typical queries retrieve the participants of a private thread, or list the private threads visible to a given user.

List participants of a private thread:

SELECT t.forum_thread_id, t.person_id, t.contact_id
FROM   ota_pvt_frm_thread_users t
WHERE  t.forum_thread_id = :thread_id
AND    t.business_group_id = :bg_id;

List private threads visible to a user:

SELECT ft.thread_id, ft.subject
FROM   ota_pvt_frm_thread_users u,
       ota_forum_threads ft
WHERE  u.forum_thread_id = ft.thread_id
AND    u.person_id = :person_id;

Reporting scenarios include auditing private message distribution, identifying inactive private threads, and reconciling thread participation against forum membership. Because the table is a pure relationship store with audit columns, it is well suited to incremental extracts driven by LAST_UPDATE_DATE.

Related Objects

  • OTA_FORUMS_B — Referenced via FORUM_ID; the base forum definition table.
  • OTA_FORUM_THREADS — Referenced via FORUM_THREAD_ID; holds the thread header and message content.
  • OTA_FORUM_MESSAGES — Related message detail for threads, joined via FORUM_THREAD_ID.
  • PER_ALL_PEOPLE_F — Joined on PERSON_ID to resolve participant names.
  • HZ_PARTIES / HZ_RELATIONSHIPS — Joined on CONTACT_ID to resolve external contact recipients.
  • OTA_FORUM_USERS / membership tables — Provide the broader forum access model against which private thread access is layered.

These relationships confirm the table's role as the private-message access link within the OTA Learning Management forum subsystem.