Search Results fnd_object_instance_sets_vl

Overview

The APPS.HZ_DSS_SEL_ENTITIES_V view is a reporting and integration object within the Oracle E-Business Suite Receivables (AR) product family. It exposes the relationship between Data Security Set (DSS) groups and the entities that may be secured under them, presenting a consolidated, denormalized view of group-to-entity assignments and their selected status. The view is particularly relevant in Oracle EBS 12.1.1 and 12.2.2 environments where Data Security and Management (DSM) or Data Security Set configuration is used to restrict user access to specific records based on entity-level hierarchies.

The name of the view — "selected entities" — indicates its purpose: it lists the complete universe of entities defined in HZ_DSS_ENTITIES alongside a computed SELECTED_FLAG that indicates whether each entity is currently secured for a given DSS group. This makes the view a natural source for user interfaces, concurrent programs, and inbound/outbound integrations that need to render or evaluate selected versus unselected security entities. Because it is owned by APPS and defined as a view over the HZ DSS tables, it is accessible to reporting tools, OAF pages, and PL/SQL APIs operating under standard EBS responsibilities.

Underlying Base Objects

The view is defined over five documented base objects:

• HZ_DSS_GROUPS_B (SYNONYM) — Supplies DSS_GROUP_CODE, the data security set group key.
• HZ_DSS_ENTITIES (SYNONYM) — Supplies the entity definitions (ENTITY_ID, OBJECT_ID, INSTANCE_SET_ID, and STATUS).
• HZ_DSS_SECURED_ENTITIES (SYNONYM) — Correlated subqueries against this table drive SELECTED_FLAG, OBJECT_VERSION_NUMBER, and HSE_STATUS.
• FND_OBJECTS_VL (VIEW) — Outer-joined on OBJECT_ID to provide the translatable OBJ_NAME, DISPLAY_NAME, and DESCRIPTION.
• FND_OBJECT_INSTANCE_SETS_VL (VIEW) — Outer-joined on INSTANCE_SET_ID to provide INSTANCE_SET_NAME and its display/description overrides.

The outer joins (FO.OBJECT_ID (+) = HDE.OBJECT_ID and FOIS.INSTANCE_SET_ID (+) = HDE.INSTANCE_SET_ID) ensure that entities are returned even if their object or instance set has not been registered or translated. The driving tables are HZ_DSS_GROUPS_B and HZ_DSS_ENTITIES, so the row count reflects the Cartesian product of all groups and all entities, filtered only by the join mechanics above.

Key Columns

• DSS_GROUP_CODE — Identifier of the Data Security Set group; the primary grouping key for security assignments.
• ENTITY_ID — Surrogate key of the DSS entity; used to correlate with HZ_DSS_SECURED_ENTITIES.
• SELECTED_FLAG — Computed as NVL(..., 'N'): returns 'Y' when a matching active row (STATUS = 'A') exists in HZ_DSS_SECURED_ENTITIES, otherwise 'N'. This is the column users most frequently query.
• OBJECT_VERSION_NUMBER — Optimistic locking value from the secured-entity row; null when the entity is not selected.
• HSE_STATUS and HDE_STATUS — Statuses from the secured-entity row and the base entity row respectively, allowing users to distinguish active selection from active definition.
• OBJ_NAME, INSTANCE_SET_NAME, ENTITY_DISPLAY_NAME, ENTITY_DESCRIPTION — Human-readable descriptors, with instance-set overrides taking precedence via NVL.

Common Use Cases and Queries

Typical consumption includes diagnostics of DSS configuration, building LOVs for secured-entity maintenance pages, and data migration between environments. A common diagnostic returns all entities not yet selected for a group:

• SELECT dss_group_code, entity_id, obj_name, entity_display_name FROM hz_dss_sel_entities_v WHERE selected_flag = 'N';
• SELECT dss_group_code, COUNT(*) FROM hz_dss_sel_entities_v WHERE selected_flag = 'Y' GROUP BY dss_group_code;
• SELECT dss_group_code, entity_id, object_version_number, hse_status FROM hz_dss_sel_entities_v WHERE dss_group_code = :p_group AND selected_flag = 'Y';

These patterns support access review, troubleshooting of "missing entity" issues, and reconciliation of secured-entity rows against the master entity definition.