Search Results fnd_view_columns




Overview
Explore in AI Chat

Overview

The FND_VIEW_COLUMNS table is a core metadata repository within the Oracle E-Business Suite (EBS) Application Object Library (AOL). It serves as the central registry for all columns belonging to application views that are registered with the Oracle Application Object Library. This table is fundamental to the framework's ability to understand and manage the structure of application views dynamically. Its role is to provide a standardized, queryable catalog of view metadata, which is essential for various EBS runtime processes, development tools, and administrative utilities that need to introspect or manipulate view definitions programmatically.

Key Information Stored

The table stores descriptive and structural metadata for each column in a registered view. Its primary key (FND_VIEW_COLUMNS_PK) uniquely identifies a column using the combination of APPLICATION_ID, VIEW_ID, and COLUMN_SEQUENCE. A unique key (FND_VIEW_COLUMNS_UK1) also enforces uniqueness on APPLICATION_ID, VIEW_ID, and COLUMN_NAME. While the full column list is not detailed in the provided metadata, typical columns in such a repository include APPLICATION_ID (identifying the owning product), VIEW_ID (linking to the parent view in FND_VIEWS), COLUMN_NAME, COLUMN_SEQUENCE (for ordering), and descriptive attributes like PROMPT, DESCRIPTION, and ENABLED_FLAG. This structure allows the system to maintain a normalized, version-independent reference to view columns.

Common Use Cases and Queries

This table is primarily accessed for metadata discovery and validation. Common use cases include generating dynamic user interfaces or reports based on view structures, validating custom code or integrations against the official view schema, and performing impact analysis for changes. A typical query retrieves all columns for a specific view to understand its composition:

  • SELECT column_name, column_sequence FROM apps.fnd_view_columns WHERE application_id = 0 AND view_id = 12345 ORDER BY column_sequence;

Another frequent pattern is joining with FND_VIEWS to get a complete picture of a view and its columns for documentation or support troubleshooting:

  • SELECT v.view_name, c.column_name, c.column_sequence FROM apps.fnd_views v, apps.fnd_view_columns c WHERE v.application_id = c.application_id AND v.view_id = c.view_id AND v.view_name = 'MY_CUSTOM_VIEW';

Related Objects

The FND_VIEW_COLUMNS table has a direct and critical foreign key relationship with the FND_VIEWS table, which is the master registry for application views. As documented, the foreign key from FND_VIEW_COLUMNS references FND_VIEWS using the columns (APPLICATION_ID, VIEW_ID). This enforces referential integrity, ensuring every registered column belongs to a valid, registered view. Therefore, FND_VIEWS is the primary parent object. Other AOL objects, such as FND_FORM_FIELDS or various Oracle Application Framework (OAF) metadata tables, may indirectly reference or utilize the column definitions stored here for UI rendering and validation purposes.