Results for “privacy_attribute_name”
28 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
FND_PRIVACY_ATTRIBUTES_TL is the translated (TL) companion table to the FND_PRIVACY_ATTRIBUTES base table, residing in the APPLSYS schema within the Oracle E-Business Suite Application Object Library (FND). It stores language-specific, user-facing text — the display name and descriptions — for privacy attributes defined in the base table. Privacy attributes are the descriptive metadata elements used by the EBS privacy and security framework to classify and label personal or sensitive data, enabling masking, auditing, and access-control policies in releases such as 12.1.1 and 12.2.2. Because the object is a translation table, one logical privacy attribute corresponds to one row per installed language.
ETRM classifies the object heuristically as standalone in its Data Vault modeling suggestion. A standalone classification indicates that the table can be modeled as a self-contained satellite-style entity, since the only documented foreign key (SECURITY_GROUP_ID → FND_SECURITY_GROUPS) does not impose a strong parent-child hub relationship. In practice, FND_PRIVACY_ATTRIBUTES_TL is best treated as a language satellite attached to the base attribute, keyed by PRIVACY_ATTRIBUTE_CODE plus LANGUAGE.
Key Information Stored
The documented physical schema contains 12 columns. The most significant are:
- PRIVACY_ATTRIBUTE_CODE — the business identifier shared with the base table; part of the unique key.
- LANGUAGE — the installed language code (e.g., US, FR); the second component of the unique key.
- PRIVACY_ATTRIBUTE_NAME — the translatable display name shown to users.
- DESCRIPTION — the translatable long description of the attribute.
- DESCRIPTION_INT — an internal or alternate description field.
- SOURCE_LANG — the language of the source record from which this translation derives.
- SECURITY_GROUP_ID — foreign key to FND_SECURITY_GROUPS, scoping the row to a security group.
- CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — the standard EBS audit columns populated by the WHO columns mechanism.
The business-key candidate is the unique index FND_PRIVACY_ATTRIBUTES_TL_U1 on (PRIVACY_ATTRIBUTE_CODE, LANGUAGE). The metadata does not document a separate surrogate primary key column; PRIVACY_ATTRIBUTE_CODE functions as the logical linkage key to the base table, while LANGUAGE qualifies the translation row.
Common Use Cases and Queries
Typical usage involves joining the translation table to the base table and filtering to the session language. A representative query follows:
SELECT b.privacy_attribute_code, t.privacy_attribute_name, t.description FROM fnd_privacy_attributes b, fnd_privacy_attributes_tl t WHERE b.privacy_attribute_code = t.privacy_attribute_code AND t.language = USERENV('LANG');- Reporting the set of privacy attributes available in each installed language for compliance documentation.
- Auditing missing or stale translations by comparing SOURCE_LANG and LANGUAGE values.
- Validating that SECURITY_GROUP_ID values reference active FND_SECURITY_GROUPS rows.
- Extracting attribute names and descriptions for metadata catalogs or data-lineage tooling.
Related Objects
- FND_PRIVACY_ATTRIBUTES — base table joined on PRIVACY_ATTRIBUTE_CODE.
- FND_SECURITY_GROUPS — referenced by the SECURITY_GROUP_ID foreign key.
- FND_LANGUAGES — provides valid LANGUAGE and SOURCE_LANG codes.
- FND_PRIVACY_ATTRIBUTES_VL — the translated view presenting both base and translated columns.
- FND_SECURITY_GROUPS_VL / FND_SECURITY_GROUPS_TL — related security-group translations.
These objects collectively support privacy metadata retrieval, multilingual display, and security-group-scoped administration within EBS 12.1.1 and 12.2.2.
-
APPS.FND_PRIVACY_ATTRIBUTES_VL·↳ FND_PRIVACY_ATTRIBUTES_B·↳ FND_PRIVACY_ATTRIBUTES_TL·Explore FND module →
-
APPS.FND_PRIVACY_ATTRIBUTES_VL·↳ FND_PRIVACY_ATTRIBUTES_B·↳ FND_PRIVACY_ATTRIBUTES_TL·Explore FND module →
-
APPS.FND_PURPOSE_ATTRIBUTE_LIST_V·↳ FND_PRIVACY_ATTRIBUTES_VL·↳ FND_PURPOSE_ATTRIBUTES·Explore FND module →
-
APPS.FND_PURPOSE_ATTRIBUTE_LIST_V·↳ FND_PRIVACY_ATTRIBUTES_VL·↳ FND_PURPOSE_ATTRIBUTES·Explore FND module →
-
eTRM - FND Tables and Views 12.2.2
No longer used
-
eTRM - FND Tables and Views 12.1.1
No longer used