Search Results fnd_objects




Overview
Explore in AI Chat

Overview

The FND_OBJECTS table is a core repository within the Application Object Library (FND) that defines the master list of securable data elements across Oracle E-Business Suite. It serves as the foundational registry for the Data Security framework, enabling the creation of fine-grained access control policies. Initially, an object typically represents a database table or view, but the framework can extend to other entities. Each record in this table defines a distinct object to which security grants can be applied, thereby centralizing the administration of data-level permissions and separating security logic from application code.

Key Information Stored

The table's primary key is OBJECT_ID, a unique numeric identifier for each securable object. While the provided metadata does not list all columns, standard columns in FND_OBJECTS include OBJECT_NAME (the internal name), APPLICATION_ID (identifying the owning product), and PACKAGE_NAME (the PL/SQL package implementing the object's security policy). The table also stores metadata such as the base database table or view name, description, and configuration flags that control how the object's security policies are evaluated and enforced. The related FND_OBJECTS_TL table provides translated names and descriptions for multilingual implementations.

Common Use Cases and Queries

A primary use case is auditing the universe of securable objects or troubleshooting Data Security policies. Developers and administrators query this table to understand available objects, their implementation details, and their relationships. For example, to list all objects related to a specific module or table, one might execute: SELECT object_name, description FROM apps.fnd_objects WHERE table_name = '<TABLE_NAME>';. Another common scenario involves joining FND_OBJECTS with grant tables like IBC_GRANTS to analyze existing data security assignments. The search for "igs_sc_objects" indicates a specific integration point, as IGS_SC_OBJECTS is a foreign key table, linking Student Central (IGS) security objects to the central FND_OBJECTS registry.

Related Objects

FND_OBJECTS is a central hub referenced by numerous security and configuration tables across different E-Business Suite products. As shown in the metadata, key foreign key relationships include:

  • FND_OBJECTS_TL: Holds translated descriptive information.
  • FND_FORM_FUNCTIONS: Links form functions to data security objects.
  • IBC_GRANTS, IBC_OBJECT_PERMISSIONS: Core tables for storing actual data security grants and permissions.
  • IGS_SC_OBJECTS, IGS_SC_OBJ_GRANTS: Part of the Student Central security model, extending the Data Security framework to education-specific entities.
  • AMW_OBJECT_OPINION_TYPES, HZ_DSS_ENTITIES: Used by Application Management and Trading Community Architecture for risk and security assessments.
This network of relationships underscores the table's critical role as the system of record for securable entities.