Results for “monitor_options”

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

Overview

IEB_MEDIA_TASK_SOURCES is a table in the IEB (Interaction Blending) product module of Oracle E-Business Suite, owned by the IEB schema. According to the ETRM documentation, its purpose is to record the media sources of Media Manager Servers. Critically, the object carries a status of VALID at the database level but is explicitly annotated as an obsolete table in Oracle's documentation. This distinction matters for anyone performing impact analysis, upgrade remediation, or schema discovery in EBS 12.1.1 or 12.2.2: the physical segment may still exist and appear queryable, while Oracle no longer supports functional dependence on it.

From a data-modeling perspective, the heuristic Data Vault classification mined from the foreign-key structure is satellite-leaning. That is a modeling suggestion rather than an Oracle-declared designation: the table describes attributes qualifying a parent entity — the Media Manager Server — rather than acting as a hub of independent business keys or a pure many-to-many link. The parent it qualifies is IEB_MMS_SERVERS.

Key Information Stored

The documented physical schema for release 12.2.2 contains 13 columns. The most significant are:

• MTS_ID — the surrogate primary key, enforced by the constraint IEB_MEDIA_TASK_SOURCES_PK. This is the only unique identifier documented; no separate business-key unique index is recorded in the metadata.
• MMSSVR_MMSSVR_ID — the foreign key to IEB_MMS_SERVERS, tying each media source row to its owning Media Manager Server. This is the effective business relationship of the row.
• SOURCE_NAME — the descriptive name of the media source, and the closest thing to a natural business identifier on the table.
• ACTIVE_Y_N — a Y/N flag indicating whether the source is enabled.
• MEDIA_TYPE — classification of the media served by that source.
• SOURCE_CONFIG_Y_N — a Y/N indicator of whether the source has been configured.
• MONITOR_OPTIONS — configuration controlling monitoring behaviour for the source.
• SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, supporting multi-org / security-group filtering consistent with standard EBS tables.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS Who columns recording row audit history.

Common Use Cases and Queries

Because the table is obsolete, its principal practical use in a 12.1.1 or 12.2.2 environment is inventory and remediation rather than active reporting. Typical work includes confirming whether the object is referenced by customizations before an upgrade, or checking whether a Media Manager configuration migration left residual rows.

A straightforward inventory query joining the server parent is:

• SELECT s.mts_id, s.source_name, s.media_type, s.active_y_n, m.mmssvr_id FROM ieb.ieb_media_task_sources s, ieb.ieb_mms_servers m WHERE s.mmssvr_mmssvr_id = m.mmssvr_id;

Other practical patterns include counting rows by security group (GROUP BY security_group_id) to scope analysis, filtering on active_y_n = 'Y' to identify sources still flagged as live, and querying FND_OBJECTS or the dependency views to establish whether any concurrent program, function, or form still points at this table before removal. Reporting or data-extraction should not be built on this object, since Oracle has declared it obsolete; downstream dependencies should be re-pointed to whatever object superseded it in the Interaction Blending data model.

Related Objects

The documented relationships identify the following significant objects:

• IEB_MMS_SERVERS — the parent table. Join column: IEB_MEDIA_TASK_SOURCES.MMSSVR_MMSSVR_ID equals IEB_MMS_SERVERS.MMSSVR_ID. This is the primary relationship defining the table as satellite-leaning.
• FND_SECURITY_GROUPS — referenced through SECURITY_GROUP_ID, providing security-group scoping used throughout EBS.
• IEB_MEDIA_TASK_SOURCES_PK — the primary-key constraint on MTS_ID, the only documented unique index.
• The broader IEB Media Manager table family — sibling configuration and task tables in the same schema that reference Media Manager Servers; these should be reviewed together when retiring or assessing this obsolete structure.

No views, APIs, or additional foreign tables are documented for this object in the ETRM metadata; any further dependencies should be confirmed against the live data dictionary in the target environment.