Results for “fnd_primary_key_columns”

50+ results




Overview
Explore in AI Chat

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

Overview

FND_PRIMARY_KEY_COLUMNS is a metadata repository table in the APPLSYS schema, owned by the FND – Application Object Library product. It stores the individual columns that participate in the primary and unique key definitions registered with Oracle Application Object Library, one row per key column. Each row links a key definition held in FND_PRIMARY_KEYS to the specific column defined in FND_COLUMNS, thereby describing the physical composition and ordering of a registered key. The table is central to EBS metadata-driven behavior, since the Application Object Library uses these registrations to generate and validate primary key constraints, support the Oracle Forms and OA Framework scaffolding, and drive generic delete, audit, and concurrency logic.

Under its documented 12.2.2 physical schema, the table comprises eleven columns. Within a Data Vault modeling suggestion, the metadata mining classifies this object heuristically as a link, as it resolves many-to-many associations between key definitions and column definitions while carrying descriptive ordering attributes.

Key Information Stored

The columns below are drawn directly from the documented ETRM metadata and constitute the meaningful content of the table.

  • APPLICATION_ID — the application owning the registered table; part of both the primary key and foreign keys.
  • TABLE_ID — identifies the registered database table within the application; part of both the primary key and foreign keys.
  • PRIMARY_KEY_ID — identifies the key definition in FND_PRIMARY_KEYS to which this column belongs.
  • COLUMN_ID — identifies the column definition in FND_COLUMNS that participates in the key; constrained by the unique index FND_PRIMARY_KEY_COLUMNS_UK1 and _U2.
  • PRIMARY_KEY_SEQUENCE — the ordinal position of the column within the key. This is the attribute most commonly associated with the search term "primary_key_sequence" and determines constraint column order.
  • ZD_EDITION_NAME — the editioning column supporting EBS 12.2 online patching; it qualifies the unique indexes _U1 and _U2.
  • LAST_UPDATE_DATE, LAST_UPDATED_BY, CREATION_DATE, CREATED_BY, LAST_UPDATE_LOGIN — standard Oracle EBS who-columns recording creation and last modification audit information.

The surrogate primary key FND_PRIMARY_KEY_COLUMNS_PK is defined on (APPLICATION_ID, TABLE_ID, PRIMARY_KEY_ID, PRIMARY_KEY_SEQUENCE). Business-key candidates are reflected by FND_PRIMARY_KEY_COLUMNS_UK1 and _U1 on (APPLICATION_ID, TABLE_ID, PRIMARY_KEY_ID, PRIMARY_KEY_SEQUENCE, ZD_EDITION_NAME) and by _U2 on (APPLICATION_ID, TABLE_ID, PRIMARY_KEY_ID, COLUMN_ID, ZD_EDITION_NAME), ensuring a column is not duplicated within the same key and sequence.

Common Use Cases and Queries

Typical scenarios include reconstructing the ordered column list for a registered primary key, auditing which columns back a given key definition, and diagnosing constraint-generation failures when metadata is inconsistent.

  • Retrieving an ordered key: SELECT primary_key_sequence, column_id FROM fnd_primary_key_columns WHERE application_id = :app AND table_id = :tbl AND primary_key_id = :pk ORDER BY primary_key_sequence;
  • Joining to FND_COLUMNS to resolve column names for documentation and impact analysis.
  • Comparing registered key composition across editions using ZD_EDITION_NAME in a 12.2 environment.
  • Reporting to identify keys with unusually many columns or gaps in sequence numbering.

Related Objects

  • FND_PRIMARY_KEYS — parent of the key definition; joined on (APPLICATION_ID, TABLE_ID, PRIMARY_KEY_ID).
  • FND_COLUMNS — provides the referenced column; joined on (APPLICATION_ID, TABLE_ID, COLUMN_ID).
  • FND_TABLES — supplies table context for TABLE_ID.
  • FND_PRIMARY_KEY_COLUMNS_UK1 / _U1 / _U2 — unique indexes enforcing key-column uniqueness.
  • FND_PRIMARY_KEY_COLUMNS_PK — the primary key constraint on (APPLICATION_ID, TABLE_ID, PRIMARY_KEY_ID, PRIMARY_KEY_SEQUENCE).
  • FND_APPLICATION — resolves APPLICATION_ID to an application short name.