Results for “fnd_objects_u2”

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

Overview

FND_OBJECTS is a core table in the Oracle E-Business Suite Application Object Library (FND) product, residing in the APPLSYS schema and holding status VALID in both 12.1.1 and 12.2.2. The table registers the "objects of data elements that can be secured in data security grants." Initially, an object corresponds to a database table or view, but the table has since been generalized to represent any securable entity within the EBS data security model. Each row defines an object that can be granted or restricted through the Oracle User Management and data security frameworks, forming the metadata backbone for object-level access control across the suite.

From a data-modeling perspective, FND_OBJECTS exhibits the characteristics of a hub entity: it carries a single-column surrogate primary key and is referenced by numerous dependent tables through foreign keys. It is best treated as a reference or master object whose rows are relatively stable and whose associations are expressed in satellite and link tables.

Key Information Stored

The table is documented with 55 columns in the 12.2.2 physical schema. The most significant are:

• OBJECT_ID — the surrogate primary key defined by the FND_OBJECTS_PK constraint.
• OBJ_NAME — the developer-facing object name; a business-key candidate via the FND_OBJECTS_U2 unique index (OBJ_NAME, ZD_EDITION_NAME).
• APPLICATION_ID — the owning application, linking the object to the FND application registry.
• DATABASE_OBJECT_NAME — the underlying database table or view that is being secured.
• PK1_COLUMN_NAME through PK5_COLUMN_NAME — up to five primary-key columns used to uniquely identify a row within the secured object.
• PK1_COLUMN_TYPE through PK5_COLUMN_TYPE — the corresponding data types of those key columns.
• IREP_NAME, IREP_OBJECT_TYPE, IREP_PRODUCT — metadata describing the object in the Integrated Repository, including its repository type and originating product.
• IREP_DESCRIPTION, IREP_STANDARD, IREP_STANDARD_VERSION — descriptive and standards-conformance attributes for repository-managed objects.
• OPEN_INTERFACE_FLAG — indicates whether the object is exposed through an open interface.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard audit columns maintained by the EBS who-columns convention.
• ZD_EDITION_NAME — the editioning column supporting online patching and edition-based redefinition in 12.2.x.

The FND_OBJECTS_U1 unique index (OBJECT_ID, ZD_EDITION_NAME) enforces uniqueness in conjunction with the edition dimension, while FND_OBJECTS_U2 (OBJ_NAME, ZD_EDITION_NAME) confirms OBJ_NAME as the natural business key.

Common Use Cases and Queries

FND_OBJECTS is queried primarily during security diagnostics and metadata reporting. A typical pattern resolves the object name to its primary key for downstream grant lookups:

• SELECT object_id, obj_name, database_object_name FROM fnd_objects WHERE obj_name = :name;
• Joining to IBC_GRANTS or IBC_OBJECT_PERMISSIONS on OBJECT_ID to inspect which roles or users hold data security grants.
• Joining to FND_OBJECTS_TL on OBJECT_ID to retrieve translated, user-facing object descriptions.
• Using OBJECT_ID to identify an object before registering a new grant through the User Management or Functional Administrator responsibility.
• Auditing which database tables or views are exposed as securable objects, via DATABASE_OBJECT_NAME and APPLICATION_ID.

Because the table spans all applications, filtering by APPLICATION_ID is recommended for performance and relevance.

Related Objects

The following tables reference FND_OBJECTS through the OBJECT_ID column and are the most significant dependents:

• FND_OBJECTS_TL — translated name and description rows (OBJECT_ID).
• FND_FORM_FUNCTIONS — associates form functions with a secured object (OBJECT_ID).
• IBC_GRANTS — primary data security grant records (OBJECT_ID).
• IBC_OBJECT_PERMISSIONS — per-object permission assignments (OBJECT_ID).
• IBC_OBJECT_GRANT_GROUPS — grant groupings for objects (OBJECT_ID).
• HZ_DSS_ENTITIES — Trading Community data security entities (OBJECT_ID).
• IGS_SC_OBJECTS and IGS_SC_OBJ_GRANTS — student-system securable objects and their grants (OBJECT_ID).
• AMW_OBJECT_OPINION_TYPES — object opinion type mapping (OBJECT_ID).

Together these relationships confirm FND_OBJECTS as the central hub for object-level data security across the E-Business Suite.