Search Results ota_chats_b

Overview

OTA_CHATS_B is the base table for the chat feature within the Oracle E-Business Suite Learning Management module (OTA). It stores the definitional header records for chat sessions, which are used to support online, real-time communication between one or more users. Chats may be associated with a category or class, positioning the table as a scheduling and configuration anchor for interactive learning events. The table resides in the OTA schema and is documented as VALID in both EBS 12.1.1 and 12.2.2.

Based on the foreign key topology, the heuristic Data Vault classification for this object is hub-leaning. This suggests a modeling approach in which OTA_CHATS_B functions as a central hub keyed by CHAT_ID, with dependent transactional and descriptive detail distributed to satellite and link tables such as OTA_CHATS_TL (translations), OTA_CHAT_MESSAGES (message content), and OTA_OPEN_FC_ENROLLMENTS (learner association). This classification is a modeling suggestion derived from the referential structure, not a mandated design.

Key Information Stored

The table contains fourteen documented columns. The most significant are:

CHAT_ID — Surrogate primary key and the sole unique index (OTA_CHATS_B_PK). It uniquely identifies each chat definition and is the join column referenced by all dependent tables.
BUSINESS_GROUP_ID — Multi-organization / business group discriminator that scopes rows to an operating unit or HR business group context.
OBJECT_VERSION_NUMBER — Optimistic locking column used by the OAF framework to detect concurrent updates.
PUBLIC_FLAG — Indicates whether the chat is publicly accessible or restricted.
START_DATE_ACTIVE and END_DATE_ACTIVE — The date range during which the chat is active and available.
START_TIME_ACTIVE and END_TIME_ACTIVE — The intra-day active window for the chat session.
TIMEZONE_CODE — Time zone governing the active date and time boundaries.
CREATED_BY, CREATION_DATE, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns tracking record provenance and modification history.

Only CHAT_ID is documented as a unique index, so it is the sole business-key candidate at the base-table level; descriptive business identifiers are held in the translation table.

Common Use Cases and Queries

Typical uses include listing active chats for a class, auditing chat configuration, and reporting on chat schedules. A representative query retrieves currently active chats within a business group:

Join OTA_CHATS_B to OTA_CHATS_TL on CHAT_ID to obtain display names and descriptions in the desired language.
Filter on START_DATE_ACTIVE, END_DATE_ACTIVE, START_TIME_ACTIVE, and END_TIME_ACTIVE relative to SYSDATE, adjusting for TIMEZONE_CODE, to identify live or upcoming sessions.
Filter on PUBLIC_FLAG to separate public from restricted chats.
Aggregate OTA_CHAT_MESSAGES rows grouped by CHAT_ID to measure participation volume.
Join to OTA_OPEN_FC_ENROLLMENTS on CHAT_ID to correlate chats with open flexible-credit enrollments.

Related Objects

The following objects reference OTA_CHATS_B via CHAT_ID and represent its principal dependencies:

OTA_CHATS_TL — Translation table holding language-specific chat names and descriptions; joined on CHAT_ID.
OTA_CHAT_MESSAGES — Stores individual chat messages; joined on CHAT_ID.
OTA_OPEN_FC_ENROLLMENTS — Associates chats with open enrollment records; joined on CHAT_ID.
OTA_EVENT_ASSOCIATIONS — Links chats to events; joined on CHAT_ID.

Together these tables form the chat subsystem within Learning Management, with OTA_CHATS_B acting as the central definitional anchor.

Table: OTA_CHATS_B 12.1.1
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHATS_B, object_name:OTA_CHATS_B, status:VALID, product: OTA - Learning Management , description: Chat can belongs to a category or class. Chat can be used to communicate between one or more user online and real time. , implementation_dba_data: OTA.OTA_CHATS_B ,
Table: OTA_CHATS_B 12.2.2
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHATS_B, object_name:OTA_CHATS_B, status:VALID, product: OTA - Learning Management , description: Chat can belongs to a category or class. Chat can be used to communicate between one or more user online and real time. , implementation_dba_data: OTA.OTA_CHATS_B ,
VIEW: OTA.OTA_CHATS_B# 12.2.2
owner:OTA, object_type:VIEW, object_name:OTA_CHATS_B#, status:VALID,
APPS.OTA_CHA_SHD SQL Statements 12.1.1
VIEW: APPS.OTA_CHATS_VL 12.1.1
VIEW: OTA.OTA_CHATS_B# 12.2.2
APPS.OTA_CHA_SHD SQL Statements 12.2.2
VIEW: APPS.OTA_CHATS_VL 12.2.2
SYNONYM: APPS.OTA_CHATS_B 12.2.2
owner:APPS, object_type:SYNONYM, object_name:OTA_CHATS_B, status:VALID,
SYNONYM: APPS.OTA_CHATS_B 12.1.1
owner:APPS, object_type:SYNONYM, object_name:OTA_CHATS_B, status:VALID,
APPS.OTA_CHT_BUS SQL Statements 12.2.2
APPS.OTA_CHT_BUS SQL Statements 12.1.1
APPS.OTA_CHA_BUS SQL Statements 12.1.1
APPS.OTA_CHA_INS SQL Statements 12.1.1
APPS.OTA_CHA_INS SQL Statements 12.2.2
APPS.OTA_CHA_BUS SQL Statements 12.2.2
Table: OTA_OPEN_FC_ENROLLMENTS 12.2.2
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_OPEN_FC_ENROLLMENTS, object_name:OTA_OPEN_FC_ENROLLMENTS, status:VALID, product: OTA - Learning Management , description: This stores the enrollment for all category based chat and forum. , implementation_dba_data: OTA.OTA_OPEN_FC_ENROLLMENTS ,
TABLE: OTA.OTA_CHATS_B 12.1.1
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHATS_B, object_name:OTA_CHATS_B, status:VALID,
Table: OTA_CHAT_MESSAGES 12.1.1
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHAT_MESSAGES, object_name:OTA_CHAT_MESSAGES, status:VALID, product: OTA - Learning Management , description: This hold the messages which have been posted to the chat by external or internal learner. , implementation_dba_data: OTA.OTA_CHAT_MESSAGES ,
Table: OTA_CHATS_TL 12.2.2
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHATS_TL, object_name:OTA_CHATS_TL, status:VALID, product: OTA - Learning Management , description: This table is used for storing the translation definition of chat. , implementation_dba_data: OTA.OTA_CHATS_TL ,
TABLE: OTA.OTA_CHATS_B 12.2.2
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHATS_B, object_name:OTA_CHATS_B, status:VALID,
Table: OTA_OPEN_FC_ENROLLMENTS 12.1.1
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_OPEN_FC_ENROLLMENTS, object_name:OTA_OPEN_FC_ENROLLMENTS, status:VALID, product: OTA - Learning Management , description: This stores the enrollment for all category based chat and forum. , implementation_dba_data: OTA.OTA_OPEN_FC_ENROLLMENTS ,
View: OTA_CHATS_VL 12.1.1
owner:APPS, object_type:VIEW, fnd_design_data:OTA.OTA_CHATS_VL, object_name:OTA_CHATS_VL, status:VALID, product: OTA - Learning Management , implementation_dba_data: APPS.OTA_CHATS_VL ,
Table: OTA_CHATS_TL 12.1.1
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHATS_TL, object_name:OTA_CHATS_TL, status:VALID, product: OTA - Learning Management , description: This table is used for storing the translation definition of chat. , implementation_dba_data: OTA.OTA_CHATS_TL ,
Table: OTA_CHAT_MESSAGES 12.2.2
owner:OTA, object_type:TABLE, fnd_design_data:OTA.OTA_CHAT_MESSAGES, object_name:OTA_CHAT_MESSAGES, status:VALID, product: OTA - Learning Management , description: This hold the messages which have been posted to the chat by external or internal learner. , implementation_dba_data: OTA.OTA_CHAT_MESSAGES ,
PACKAGE: APPS.OTA_CHT_BUS 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_CHT_BUS, status:VALID,
PACKAGE: APPS.OTA_CHT_BUS 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_CHT_BUS, status:VALID,
View: OTA_CHATS_VL 12.2.2
owner:APPS, object_type:VIEW, fnd_design_data:OTA.OTA_CHATS_VL, object_name:OTA_CHATS_VL, status:VALID, product: OTA - Learning Management , implementation_dba_data: APPS.OTA_CHATS_VL ,
PACKAGE BODY: APPS.OTA_CHA_DEL 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_DEL, status:VALID,
PACKAGE: APPS.OTA_LEARNER_ACCESS_UTIL 12.1.1
owner:APPS, object_type:PACKAGE, object_name:OTA_LEARNER_ACCESS_UTIL, status:VALID,
PACKAGE BODY: APPS.OTA_CHT_SHD 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHT_SHD, status:VALID,
PACKAGE BODY: APPS.OTA_CHT_SHD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHT_SHD, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_SHD 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_SHD, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_SHD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_SHD, status:VALID,
TRIGGER: APPS.OTA_CHATS_B_WHO 12.2.2
owner:APPS, object_type:TRIGGER, object_name:OTA_CHATS_B_WHO, status:VALID,
TRIGGER: APPS.OTA_CHATS_B_WHO 12.1.1
owner:APPS, object_type:TRIGGER, object_name:OTA_CHATS_B_WHO, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_UPD 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_UPD, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_UPD 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_UPD, status:VALID,
PACKAGE: APPS.OTA_LEARNER_ACCESS_UTIL 12.2.2
owner:APPS, object_type:PACKAGE, object_name:OTA_LEARNER_ACCESS_UTIL, status:VALID,
PACKAGE BODY: APPS.OTA_CHT_BUS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHT_BUS, status:VALID,
PACKAGE BODY: APPS.OTA_CHT_BUS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHT_BUS, status:VALID,
PACKAGE BODY: APPS.OTA_COI_BUS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_COI_BUS, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_DEL 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_DEL, status:VALID,
PACKAGE BODY: APPS.OTA_TIMEZONE_UPGRADE 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_TIMEZONE_UPGRADE, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_BUS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_BUS, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_INS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_INS, status:VALID,
PACKAGE BODY: APPS.OTA_TIMEZONE_UPGRADE 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_TIMEZONE_UPGRADE, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_BUS 12.2.2
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_BUS, status:VALID,
PACKAGE BODY: APPS.OTA_COI_BUS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_COI_BUS, status:VALID,
PACKAGE BODY: APPS.OTA_CHA_INS 12.1.1
owner:APPS, object_type:PACKAGE BODY, object_name:OTA_CHA_INS, status:VALID,