Results for “p_key_yn”
30 results
AI-generated from documented ETRM metadata — verify critical details on the linked pages.
Overview
XTR_AUDIT_COLUMNS_V is a reporting view owned by the APPS schema in Oracle E-Business Suite, delivered as part of the XTR (Treasury) product family. The view exposes audit configuration metadata that governs how Treasury records are audited at the event level. In the ETRM (Enterprise Treasury and Risk Management) data model, XTR_AUDIT_COLUMNS_V provides a read-only, presentation-oriented layer over the audit definition repository, allowing reports, concurrent programs, and integration interfaces to retrieve which table columns participate in auditing for a given business event, and to distinguish primary key columns from ordinary audited attributes.
The view is documented as VALID in both EBS 12.1.1 and 12.2.2, and its column set is stable across these releases: EVENT, TABLE_COLUMN, P_KEY_YN, COLUMN_TYPE, AUDIT_YN, and COLUMN_TITLE. Because the view performs a simple projection with no joins or filters, it returns exactly the rows present in its base table, preserving the underlying audit configuration without transformation. This makes it a reliable source for metadata-driven audit reporting rather than a transactional data source.
Underlying Base Objects
XTR_AUDIT_COLUMNS_V is defined with the following view text:
- SELECT EVENT, TABLE_COLUMN, P_KEY_YN, COLUMN_TYPE, AUDIT_YN, COLUMN_TITLE FROM XTR_AUDIT_COLUMNS
The single referenced base object is XTR_AUDIT_COLUMNS, which is documented in the ETRM metadata as a SYNONYM resolving to the underlying APPS table. The relationship is therefore a straightforward one-to-one projection: each row in XTR_AUDIT_COLUMNS corresponds to exactly one row in the view. No filtering predicates, aggregation, or outer joins are applied, so the view adds no business logic beyond exposing a stable, named interface. Updates to audit configuration are managed against the base table; the view reflects those changes immediately on the next query. This design is consistent with EBS conventions in which configuration metadata is exposed through simple views to decouple reporting consumers from physical table changes.
Key Columns
The columns exposed by the view, including the frequently searched COLUMN_TYPE, are described below:
- EVENT — Identifies the Treasury business event to which the audit configuration row applies. This is the primary grouping attribute for audit rules.
- TABLE_COLUMN — The name of the table column being evaluated for auditing within the context of the associated event.
- P_KEY_YN — A flag indicating whether the column forms part of the primary key for the audited entity. Values are typically Y or N, and are used to identify record identity columns during audit trail reconstruction.
- COLUMN_TYPE — Classifies the column being audited, for example by data type or functional category. This attribute is commonly queried to filter which columns are treated as key, descriptive, or monetary fields.
- AUDIT_YN — The enablement flag indicating whether the column is currently subject to auditing (Y) or excluded (N).
- COLUMN_TITLE — The user-facing display label for the column, used in report headers and audit inquiry screens.
Common Use Cases and Queries
Typical usage centers on audit configuration reporting and impact analysis before enabling or disabling auditing. Administrators query the view to enumerate audited columns per event, while report developers use COLUMN_TITLE to render readable audit output. A representative query to retrieve all audited columns for a specific event follows:
- SELECT event, table_column, p_key_yn, column_type, column_title FROM apps.xtr_audit_columns_v WHERE event = :event AND audit_yn = 'Y' ORDER BY p_key_yn DESC, table_column;
To isolate primary key columns used for record identification during audit reconstruction:
- SELECT event, table_column, column_title FROM apps.xtr_audit_columns_v WHERE p_key_yn = 'Y';
To review distinct column classifications across all configured events:
- SELECT DISTINCT column_type FROM apps.xtr_audit_columns_v ORDER BY column_type;
Because the view is a direct projection, these queries impose no additional processing cost beyond the base table access. Consumers should apply appropriate EBS security context and use the APPS schema, as granted by standard Treasury responsibility assignments.
-
View: XTR_AUDIT_COLUMNS_V 12.2.2
APPS.XTR_AUDIT_COLUMNS_V·↳ XTR_AUDIT_COLUMNS·Explore XTR module →
-
Created by ORACLE on 27-MAY-96
-
Created by ORACLE on 27-MAY-96
-
View: XTR_AUDIT_COLUMNS_V 12.1.1
APPS.XTR_AUDIT_COLUMNS_V·↳ XTR_AUDIT_COLUMNS·Explore XTR module →
-
VIEW: XTR.XTR_AUDIT_COLUMNS# 12.2.2
-
VIEW: XTR.XTR_AUDIT_COLUMNS# 12.2.2
-
TABLE: XTR.XTR_AUDIT_COLUMNS 12.2.2
-
TABLE: XTR.XTR_AUDIT_COLUMNS 12.1.1
-
PACKAGE BODY: APPS.XTR_AUDIT 12.2.2
-
PACKAGE BODY: APPS.XTR_AUDIT 12.1.1
-
PACKAGE: APPS.XTR_MISC_P 12.1.1
-
PACKAGE: APPS.XTR_MISC_P 12.2.2
-
PACKAGE: APPS.XTR_AUDIT 12.2.2
-
PACKAGE: APPS.XTR_AUDIT 12.1.1
-
PACKAGE BODY: APPS.XTR_AUDIT 12.1.1
-
PACKAGE BODY: APPS.XTR_AUDIT 12.2.2
-
eTRM - XTR Tables and Views 12.2.2
Created on 29-OCT-96
-
eTRM - XTR Tables and Views 12.1.1
Created on 29-OCT-96