Results for “fnd_col_priv_attributes_vl”

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

Overview

FND_COL_PRIV_ATTRIBUTES_VL is a translated (VL) view owned by the APPS schema in the FND — Application Object Library product. It exposes the definition of column-level privacy attributes that Oracle E-Business Suite uses to drive data masking, redaction, and attribute-based security at the individual column level of registered application tables. Because it is a VL view, it joins the base table to its translation table and filters the translated description rows by the session's language, returning exactly one set of display values per privacy attribute.

In Oracle EBS 12.1.1 and 12.2.2 the view is commonly used for reporting, diagnostics, and integration. Administrators and technical consultants query it to confirm which columns have privacy rules attached, which scrambling algorithm applies, and in what column sequence the attributes are evaluated. Downstream integration code also references the view name when extracting privacy configuration for compliance or audit purposes.

Underlying Base Objects

The view is defined over two documented base objects, both exposed through synonyms in the APPS schema:

• FND_COL_PRIV_ATTRIBUTES_B — the base table holding the non-translatable data for each privacy attribute, such as the owning application, table and column identifiers, sequence, descriptive flexfield attributes, DSRAM level and algorithm, and standard WHO columns.
• FND_COL_PRIV_ATTRIBUTES_TL — the translation table holding the language-specific text, primarily the COMMENTS column.

The two tables are joined on the composite key of PRIVACY_ATTRIBUTE_CODE, APPLICATION_ID, TABLE_ID, and COLUMN_ID. The translation side is further restricted by T.LANGUAGE = USERENV('LANG'), which is what makes this a VL view: the caller sees only the row in their current language, with the session language determined by the user environment.

Key Columns

• PRIVACY_ATTRIBUTE_CODE — the unique code identifying the privacy attribute; part of the join key between base and translation tables.
• APPLICATION_ID, TABLE_ID, COLUMN_ID — the identifier triad locating the protected column within a registered application table.
• COLUMN_SEQUENCE — the ordering used when the attributes for a parent definition are processed.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1–ATTRIBUTE15 — the descriptive flexfield segments used to store supplemental, customer-configurable metadata.
• DSCRAM_LEVEL — the data scrambling level, controlling the strength or type of masking applied to the column.
• DSCRAM_ALGO_ID — the identifier of the scrambling algorithm associated with the attribute.
• COMMENTS — the translatable descriptive text sourced from the TL table.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN, OBJECT_VERSION_NUMBER — standard audit and optimistic locking columns.
• ROW_ID — the ROWID of the base table row, aliased for reference.

Common Use Cases and Queries

Typical scenarios include auditing which columns are protected for a given application table, reviewing scrambling configuration before promotions or clones, and building compliance extracts for privacy regulations. The following query lists privacy attributes for a specific application and table:

• SELECT privacy_attribute_code, application_id, table_id, column_id, column_sequence, dscram_level, dscram_algo_id, comments FROM fnd_col_priv_attributes_vl WHERE application_id = :app_id AND table_id = :table_id ORDER BY column_sequence;

A second common form, used to inspect algorithm coverage across the instance, selects the algorithm column aggregated by level:

• SELECT dscram_level, dscram_algo_id, COUNT(*) FROM fnd_col_priv_attributes_vl GROUP BY dscram_level, dscram_algo_id;

Because the view filters on USERENV('LANG'), results reflect the language of the connecting session. Reports that must be language-independent should query the underlying base table FND_COL_PRIV_ATTRIBUTES_B directly.