Search Results fnd_col_priv_attributes_tl




Overview
Explore in AI Chat

Overview

FND_COL_PRIV_ATTRIBUTES_TL is a translatable (TL) table in the APPLSYS schema of the Oracle E-Business Suite, belonging to the FND — Application Object Library product. It stores language-specific descriptive text for column-level privacy attributes that govern how individual columns in Oracle EBS are treated under data-privacy and masking rules. In Oracle EBS 12.1.1 and 12.2.2 the object is documented as VALID, with 13 physical columns.

Functionally, the table holds the multilingual (translated) portion of column privacy attribute definitions. The corresponding base table (FND_COL_PRIV_ATTRIBUTES_B or its equivalent) holds the language-independent definition, while the _TL table provides the LANGUAGE-scoped text, most notably COMMENTS, for each privacy attribute applied to a specific application, table, and column combination.

From a heuristic Data Vault modeling perspective, the metadata classifies this object as standalone. In practice, it behaves as a satellite attached to a column-privacy-attribute hub/link keyed by privacy attribute, application, table, column, and language — it carries descriptive, time-stamped context (CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN) rather than acting as a relationship link itself. This classification is a modeling suggestion rather than an enforced constraint.

Key Information Stored

The table is keyed by a composite business key rather than a single surrogate column. The documented unique index FND_COL_PRIV_ATTR_TL_U1 identifies the business-key candidates: PRIVACY_ATTRIBUTE_CODE, APPLICATION_ID, TABLE_ID, COLUMN_ID, and LANGUAGE. These five columns together uniquely identify the privacy attribute definition, the owning application, the target database table, the specific column, and the language of the descriptive text.

  • PRIVACY_ATTRIBUTE_CODE — the identifier of the privacy attribute applied to the column.
  • APPLICATION_ID — the FND application that owns the table and column.
  • TABLE_ID — the FND table identifier of the object whose column is being decorated.
  • COLUMN_ID — the FND column identifier within that table.
  • LANGUAGE — the NLS language of the row's translated content.
  • SOURCE_LANG — the source language from which the translated text was derived.
  • COMMENTS — the translated descriptive or comment text for the privacy attribute.
  • CREATED_BY, CREATION_DATE — audit columns recording row creation.
  • LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — audit columns recording the most recent change.
  • SECURITY_GROUP_ID — the security group under which the row is visible; documented to reference FND_SECURITY_GROUPS.

Common Use Cases and Queries

Typical uses include auditing which columns carry privacy-related metadata, generating multilingual documentation of privacy attributes, and supporting data-masking or privacy compliance reporting. A standard pattern joins the _TL table to the base table on the business-key columns and filters on LANGUAGE to retrieve the description in a desired locale.

  • Retrieve translated comments for a specific privacy attribute and language by filtering on PRIVACY_ATTRIBUTE_CODE and LANGUAGE.
  • Join to FND_SECURITY_GROUPS on SECURITY_GROUP_ID to report which security group governs each row.
  • Audit recent changes by ordering on LAST_UPDATE_DATE and LAST_UPDATED_BY.
  • Resolve the owning application, table, and column by joining APPLICATION_ID, TABLE_ID, and COLUMN_ID to the corresponding FND metadata tables.

Related Objects

  • FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID (documented foreign key).
  • The base column-privacy-attributes table — joined on PRIVACY_ATTRIBUTE_CODE, APPLICATION_ID, TABLE_ID, COLUMN_ID.
  • FND_APPLICATION (FND_APPLICATION_TL) — resolves APPLICATION_ID.
  • FND_TABLES — resolves TABLE_ID.
  • FND_COLUMNS — resolves COLUMN_ID.
  • FND_LANGUAGES — resolves LANGUAGE and SOURCE_LANG.