Search Results fnd_object_instance_sets_vl

Overview

FND_OBJECT_INSTANCE_SETS_VL is a validation view owned by the APPS schema within the FND — Application Object Library product of Oracle E-Business Suite. It exposes a language-translated, user-facing representation of object instance sets, which are configuration constructs that bind a business object to a named set of instance-level membership rules. In Oracle EBS, object instance sets support flexible security and scoping models, particularly in Application Object Library and dependent products such as Oracle Applications Framework, Oracle Approvals Management, and Oracle Workflow. The "_VL" suffix indicates a validated, translated view that joins a base entity table to its translation table and filters the translation rows to the session's current language using USERENV('LANG'). This design allows reports and integrations to retrieve display names and descriptions in the runtime language without requiring callers to join translation tables themselves.

The view is documented as VALID in ETRM 12.2.2 and remains applicable to 12.1.1, where the same underlying entity and translation tables are used. Its principal role is read-only reporting and integration: it presents instance set metadata, including the optional predicate that governs membership evaluation, together with audit columns and translated descriptive text.

Underlying Base Objects

The view is defined over two base objects, both accessed through synonyms in the APPS schema:

• FND_OBJECT_INSTANCE_SETS — the base entity table (aliased as B) that stores the canonical, non-translated attributes of each instance set, including its identifier, name, associated object identifier, membership predicate, and standard audit columns.
• FND_OBJECT_INSTANCE_SETS_TL — the translation table (aliased as T) that stores language-specific DISPLAY_NAME and DESCRIPTION values, keyed jointly by INSTANCE_SET_ID and LANGUAGE.

The defining query joins the two tables on INSTANCE_SET_ID and restricts T.LANGUAGE to USERENV('LANG'), ensuring each instance set appears once, in the session's language. The SELECT list explicitly projects B.ROWID as ROW_ID alongside the stored and translated columns. This structure is consistent with standard FND translated views, meaning the view inherits the row-level behavior of the base tables and should not be treated as a substitute for the underlying tables in DML operations, since it is not inherently updatable through the join.

Key Columns

• ROW_ID — the ROWID of the base FND_OBJECT_INSTANCE_SETS row, useful for identifying the physical source record.
• INSTANCE_SET_ID — the unique surrogate key identifying each object instance set and the join key to the translation table.
• INSTANCE_SET_NAME — the internal, untranslated name of the instance set.
• OBJECT_ID — the identifier of the FND object to which the instance set applies, linking the set to its governing object definition.
• PREDICATE — the rule expression that determines which instances qualify for membership in the set; this is the functional core of the construct.
• DISPLAY_NAME — the translated, user-facing label for the instance set in the session language.
• DESCRIPTION — the translated descriptive text for the instance set.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard Oracle EBS audit and "who" columns recording creation and last modification context.

Common Use Cases and Queries

This view is typically queried during diagnostics, security reviews, and metadata reporting. A frequent requirement is to list all instance sets for a specific object with their translated names and predicates:

• Retrieve all instance sets with their object association, for example: SELECT instance_set_id, instance_set_name, object_id, display_name, description FROM fnd_object_instance_sets_vl ORDER BY object_id, instance_set_name;
• Filter to a particular object to inspect predicate logic: SELECT instance_set_name, display_name, predicate FROM fnd_object_instance_sets_vl WHERE object_id = :p_object_id;
• Audit recently modified configuration: SELECT instance_set_name, last_updated_by, last_update_date FROM fnd_object_instance_sets_vl WHERE last_update_date > SYSDATE - 30;

Because translation is resolved at query time via USERENV('LANG'), the same query returns locale-appropriate text per session. When the desired language translation is missing, FND translated views may return the base language row depending on translation setup, and consequently consumers should not assume a non-null DISPLAY_NAME for every locale. For structural changes or predicate modifications, the underlying FND_OBJECT_INSTANCE_SETS table must be addressed directly, as the joined view is intended for read access.