Search Results foreign_key_id




Overview
Explore in AI Chat

Overview

The FND_FOREIGN_KEY_COLUMNS table is a core metadata repository within the Application Object Library (FND) of Oracle E-Business Suite (EBS). It serves as the central registry for the specific column-level definitions that constitute foreign key relationships between registered application tables. This table does not store application data; instead, it stores the structural metadata that defines how data in one table references data in another. Its primary role is to support the Oracle Application Framework and other EBS components in understanding and enforcing data integrity, enabling features like dynamic LOVs, intelligent data navigation, and referential integrity validation within the application's registered schema.

Key Information Stored

The table records the composition of each foreign key by linking a foreign key definition to its constituent columns. Its structure is defined by composite primary and unique keys, ensuring the precise ordering and uniqueness of columns within a key. The most critical columns are APPLICATION_ID, TABLE_ID, and FOREIGN_KEY_ID, which together uniquely identify a specific foreign key definition as registered in the related FND_FOREIGN_KEYS table. The FOREIGN_KEY_SEQUENCE column dictates the order of columns within a composite foreign key. The COLUMN_ID column references the FND_COLUMNS table to identify the exact table column participating in the relationship. This design allows the system to store multi-column foreign keys accurately.

Common Use Cases and Queries

A primary use case is generating data model documentation or performing impact analysis for schema changes. Developers and DBAs query this table to understand dependencies between EBS entities. For instance, to list all columns for a specific foreign key (identified by its ID), one might execute:

  • SELECT fc.column_name, ffkc.foreign_key_sequence FROM fnd_foreign_key_columns ffkc, fnd_columns fc WHERE ffkc.application_id = fc.application_id AND ffkc.table_id = fc.table_id AND ffkc.column_id = fc.column_id AND ffkc.foreign_key_id = :foreign_key_id ORDER BY ffkc.foreign_key_sequence;

Another common scenario is finding all foreign keys that reference a particular column, which is essential for assessing the ripple effects of modifying that column's data.

Related Objects

FND_FOREIGN_KEY_COLUMNS is intrinsically linked to other core Application Object Library metadata tables. It has a direct foreign key relationship to FND_FOREIGN_KEYS, which provides the high-level definition (name, referenced table). It also references FND_COLUMNS to resolve the specific column details. This table is part of a larger metadata hierarchy that includes FND_TABLES and FND_APPLICATION. These relationships collectively form the comprehensive data dictionary that the EBS framework utilizes to manage application logic and data integrity dynamically.