Results for “locked_flag”

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

Overview

FND_PRIVACY_ATTRIBUTES_B is a core configuration table in the Oracle E-Business Suite Application Object Library (FND), owned by the APPLSYS schema. It stores the definition of privacy attributes that the EBS Data Privacy and Data Vault framework uses to identify, classify, and protect sensitive data elements across the application. Each row describes a single privacy attribute — a logical name that the framework maps to physical columns in application tables — together with metadata governing how that attribute should be treated for personally identifiable information (PII), sensitivity, locking, and descrambling behavior.

In Oracle EBS 12.1.1 and 12.2.2, this table underpins the Data Privacy feature set that helps organizations comply with privacy regulations (for example, GDPR and CCPA) by allowing administrators to declare which fields contain sensitive personal data. The "_B" suffix denotes the base (language-independent) table; translated or descriptive elements typically reside in an associated "_TL" table. From a data-modeling perspective, the mined metadata classifies FND_PRIVACY_ATTRIBUTES_B heuristically as a standalone entity, suggesting it behaves as a hub-like reference table rather than a link or satellite. The single foreign key to FND_SECURITY_GROUPS indicates the table participates in the multi-tenant security group model.

Key Information Stored

The table contains 30 documented columns. The most significant include:

• PRIVACY_ATTRIBUTE_CODE — the business-key candidate, protected by the unique index FND_PRIVACY_ATTRIBUTES_B_U1. This is the human-readable identifier used to reference the attribute throughout the framework.
• PRIVACY_ATTRIBUTE_TYPE — classifies the nature of the attribute, guiding how the framework interprets it.
• SENSITIVITY — records the sensitivity level assigned to the attribute, informing protection and masking decisions.
• PII_FLAG — indicates whether the attribute is considered personally identifiable information.
• LOCKED_FLAG — signals that the attribute definition is locked against modification.
• DSCRAM_LEVEL and DSCRAM_ALGO_ID — control descrambling level and algorithm used by the Data Vault scrambling mechanism.
• SECURITY_GROUP_ID — the foreign key linking the attribute to a security group in FND_SECURITY_GROUPS.
• OBJECT_VERSION_NUMBER, CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, and LAST_UPDATE_LOGIN — standard EBS audit and optimistic-locking columns.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — the standard DFF (descriptive flexfield) columns enabling extensible attribute metadata.

The primary key is the surrogate key on the attribute record, while PRIVACY_ATTRIBUTE_CODE serves as the unique business key.

Common Use Cases and Queries

Typical scenarios include auditing which attributes are flagged as PII, generating compliance reports, and validating security-group assignments before enabling Data Vault scrambling.

• List all PII attributes: SELECT PRIVACY_ATTRIBUTE_CODE, PRIVACY_ATTRIBUTE_TYPE, SENSITIVITY FROM FND_PRIVACY_ATTRIBUTES_B WHERE PII_FLAG = 'Y';
• Find locked attributes: SELECT PRIVACY_ATTRIBUTE_CODE, LOCKED_FLAG FROM FND_PRIVACY_ATTRIBUTES_B WHERE LOCKED_FLAG = 'Y';
• Join to security groups: SELECT p.PRIVACY_ATTRIBUTE_CODE, g.SECURITY_GROUP_NAME FROM FND_PRIVACY_ATTRIBUTES_B p, FND_SECURITY_GROUPS g WHERE p.SECURITY_GROUP_ID = g.SECURITY_GROUP_ID;
• Inspect descrambling configuration: query DSCRAM_LEVEL and DSCRAM_ALGO_ID to reconcile with Data Vault setup.

Related Objects

• FND_SECURITY_GROUPS — referenced via SECURITY_GROUP_ID; the principal foreign-key relationship.
• FND_PRIVACY_ATTRIBUTES_TL — likely translation/description companion for language-dependent text.
• FND_PRIVACY_ATTRIBUTE_USAGES — maps attributes to physical columns (framework usage).
• FND_DATA_VAULT_* objects — descrambling and vault configuration consuming DSCRAM_LEVEL/DSCRAM_ALGO_ID.
• FND_DF_FLEXFIELDS — relevant where ATTRIBUTE_CATEGORY flexfield metadata is interpreted.

These relationships confirm FND_PRIVACY_ATTRIBUTES_B as the reference hub anchoring EBS privacy and Data Vault configuration.