Results for “cac_task_rs_groups_sec”

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

Overview

CAC_TASK_RS_GROUPS_SEC is a security-oriented view in the Oracle E-Business Suite CRM Foundation (JTF) schema, exposed for reporting and integration consumers that need to read resource group definitions under a secured data model. In Oracle EBS 12.1.1 and 12.2.2, the CRM Foundation module supplies the shared infrastructure used by resource manager, territory manager, and task manager components. The view presents the same logical column set as the base resource groups entity, but its naming and placement in the CAC_TASK_RS_GROUPS_SEC namespace indicate that it is intended to be consumed within secured or filtered contexts, particularly where role-based security groups govern visibility of resource group records.

Because the ETRM metadata records this object as "Not implemented in this database," the view is documentation-only in the referenced environment. It may exist conditionally in installations where the relevant resource security components are licensed and configured, but it is not guaranteed to be present in every EBS instance. Integration and reporting developers should therefore verify object existence in their target environment before referencing it.

Underlying Base Objects

The documented metadata lists no referenced base objects, but the view definition text explicitly selects from the single base table JTF_RS_GROUPS_B. That table is the "B" (base) table of the resource groups entity in the CRM Foundation schema, holding the language-independent business data for resource groups.

The view is a direct column projection from JTF_RS_GROUPS_B; it introduces no joins and no translation lookup. Consequently the row cardinality matches the base table, and the view is best understood as a secured or secured-friendly presentation layer over resource group definitions rather than as a derived or aggregated dataset.

Key Columns

• GROUP_ID — Primary identifier of the resource group; the join key used by dependent resource and membership tables.
• GROUP_NUMBER — The user-facing group number used for identification in CRM screens.
• EXCLUSIVE_FLAG — Indicates whether the resource group is exclusive; this is the column most commonly sought by users searching on this term, and it governs membership semantics within resource manager.
• START_DATE_ACTIVE / END_DATE_ACTIVE — Effective date range of the group; used to determine whether a group is currently active.
• ACCOUNTING_CODE — Accounting classification associated with the group.
• EMAIL_ADDRESS — Contact email for the group.
• SECURITY_GROUP_ID — The secured security group identifier; the column that distinguishes this view from a plain base-table read and drives multi-organization visibility filtering.
• OBJECT_VERSION_NUMBER — Optimistic locking version, relevant to programmatic updates.
• ATTRIBUTE1 through ATTRIBUTE15 and ATTRIBUTE_CATEGORY — DFF (descriptive flexfield) columns for customer-defined extensions.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — Standard WHO audit columns.

Common Use Cases and Queries

Typical usage involves reporting on resource group configuration, auditing exclusive versus non-exclusive groups, and feeding secured group lists into integration pipelines.

SELECT group_id, group_number, exclusive_flag,
       start_date_active, end_date_active
FROM   cac_task_rs_groups_sec
WHERE  exclusive_flag = 'Y'
AND    (end_date_active IS NULL OR end_date_active > SYSDATE);

To enumerate currently active groups:

SELECT group_number, security_group_id
FROM   cac_task_rs_groups_sec
WHERE  TRUNC(SYSDATE) BETWEEN NVL(start_date_active, SYSDATE)
                          AND NVL(end_date_active, SYSDATE);

Before deploying any query, confirm the view exists in the target instance by querying ALL_VIEWS, since the ETRM documentation records it as not implemented in the reference database.