Results for “jtf_um_subscriptions_vl”
50+ results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
JTF_UM_SUBSCRIPTIONS_VL is a multi-lingual (MLS) view owned by the APPS schema within the JTF – CRM Foundation product. It exposes subscription definitions maintained by the Oracle User Management (UM) framework, which governs self-service registration, delegated administration, and notification subscriptions in Oracle E-Business Suite. Because it is a "VL" (view with language) object, it joins the base table with its translation table and narrows results to the language of the current session via USERENV('LANG'). For reporting and integration, the view therefore presents one row per subscription with its translated name and description, avoiding the need for callers to explicitly join the base and translation tables.
Its status is VALID in both Oracle EBS 12.1.1 and 12.2.2, and no structural changes to the documented column list are noted between these releases. The object is commonly referenced when auditing which subscriptions exist, whether they are enabled, and when they are available to end users.
Underlying Base Objects
The view is defined over two synonyms: JTF_UM_SUBSCRIPTIONS_B (the base table holding language-independent attributes) and JTF_UM_SUBSCRIPTIONS_TL (the translation table holding SUBSCRIPTION_NAME and DESCRIPTION). The join condition is:
- B.SUBSCRIPTION_ID = T.SUBSCRIPTION_ID — links each base subscription to its translated text.
- T.LANGUAGE = USERENV('LANG') — restricts output to the session language.
All columns except the translated text are drawn from the _B table; SUBSCRIPTION_NAME and DESCRIPTION come from the _TL table. ROW_ID is exposed from the base table's ROWID, allowing downstream tools to identify the physical row.
Key Columns
- SUBSCRIPTION_ID — Primary identifier for the subscription; the join key between base and translation rows.
- SUBSCRIPTION_KEY — Internal key used to reference the subscription definition.
- SUBSCRIPTION_NAME / DESCRIPTION — Language-specific display name and description from the _TL table.
- AVAILABILITY_CODE — The column most relevant to the user's search; indicates the availability context assigned to the subscription (for example, how the subscription is exposed at logon or to specific populations).
- LOGON_DISPLAY_FREQUENCY — Controls how often the subscription is surfaced to users at logon.
- ENABLED_FLAG — Indicates whether the subscription is currently active.
- PARENT_SUBSCRIPTION_ID — Self-referencing parent, supporting hierarchical subscription structures.
- APPROVAL_ID — References the approval workflow configuration associated with the subscription.
- AUTH_DELEGATION_ROLE_ID — Role used for authorization delegation.
- EFFECTIVE_START_DATE / EFFECTIVE_END_DATE — Validity window for the subscription.
- Audit columns — CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, APPLICATION_ID, SECURITY_GROUP_ID.
Common Use Cases and Queries
Typical uses include reporting on enabled subscriptions, filtering by availability behavior, and tracing parent-child subscription hierarchies in the User Management framework.
List active subscriptions with their translated names:
- SELECT subscription_id, subscription_key, subscription_name, availability_code, enabled_flag FROM jtf_um_subscriptions_vl WHERE enabled_flag = 'Y';
Filter specifically on availability behaviour (matching the user's search term):
- SELECT subscription_id, subscription_name, availability_code, logon_display_frequency FROM jtf_um_subscriptions_vl WHERE availability_code IS NOT NULL ORDER BY availability_code, subscription_name;
Review subscription hierarchies:
- SELECT child.subscription_name AS child_name, parent.subscription_name AS parent_name FROM jtf_um_subscriptions_vl child, jtf_um_subscriptions_vl parent WHERE child.parent_subscription_id = parent.subscription_id;
Because the view enforces the session-language predicate, queries return text in USERENV('LANG'); users requiring all translations must query JTF_UM_SUBSCRIPTIONS_TL directly.
-
MLS view for JTF_UM_SUBSCRIPTIONS_B and JTF_UM_SUBSCRIPTIONS_TL
APPS.JTF_UM_SUBSCRIPTIONS_VL·↳ JTF_UM_SUBSCRIPTIONS_B·↳ JTF_UM_SUBSCRIPTIONS_TL·Explore JTF module →
-
MLS view for JTF_UM_SUBSCRIPTIONS_B and JTF_UM_SUBSCRIPTIONS_TL
APPS.JTF_UM_SUBSCRIPTIONS_VL·↳ JTF_UM_SUBSCRIPTIONS_B·↳ JTF_UM_SUBSCRIPTIONS_TL·Explore JTF module →
-
12.2.2 FND Design Data 12.2.2
-
12.1.1 FND Design Data 12.1.1
-
12.1.1 DBA Data 12.1.1
-
12.2.2 DBA Data 12.2.2