Search Results audit_date

Overview

CSS_DEF_AUDIT_COLUMNS_VL is a language-enabled (VL) database view that belongs to the CSS – Support product family in Oracle E-Business Suite. In the documented metadata for ETRM 12.2.2, the view carries the designation "Obsolete" and is explicitly flagged in the source record as "Not implemented in this database." This status is significant: although the view is catalogued in the ETRM repository, it does not exist as a deployed object in the reference environment, and no owner or referenced base objects are formally documented. The view would therefore not be available for querying through standard reporting or integration mechanisms in a stock 12.1.1 or 12.2.2 installation.

Functionally, the view is designed to present rows describing audit columns associated with defect records maintained within the CSS – Support module. It combines a base table (the "B" or base entity table) with a translation table (the "TL" or translated language table) to expose language-specific values. The "_VL" suffix indicates that the view joins the base and translation tables, filtering translations by the session language, and exposes a ROW_ID column derived from the base table's ROWID for use by Oracle Forms and other tools that require a row identifier.

Underlying Base Objects

The view text references two underlying objects: CSS_DEF_AUDIT_COLUMNS_B and CSS_DEF_AUDIT_COLUMNS_TL. The "_B" table holds the base, language-independent columns, while the "_TL" table stores translated descriptive values such as OLD_VALUE and NEW_VALUE, keyed by language. The join is performed on AUDIT_COLUMN_ID, with a predicate restricting the translation row to T.LANGUAGE = USERENV('LANG'), which returns the translation matching the current session language.

Although the view is documented as obsolete and not implemented, the structure follows the standard EBS MLS (Multi-Lingual Support) pattern. Neither base table appears elsewhere in the documented metadata, and no owner is recorded, so the exact schema in which these objects reside cannot be confirmed from ETRM alone. In installations where the CSS – Support module was active prior to its deprecation, these tables would have existed under the corresponding product schema.

Key Columns

• ROW_ID — the ROWID from the base table, used as a unique row identifier by Oracle Forms and ADF tooling.
• AUDIT_COLUMN_ID — the primary key linking the base and translation records.
• OBJECT_VERSION_NUMBER — the optimistic locking version counter for the row.
• AUDIT_DATE — the timestamp of the audit event, and the column most relevant to the user's search term "audit_date."
• AUDIT_HISTORY_ID — the foreign key to the parent audit history record.
• DEFECT_ID — the identifier of the defect to which the audit column belongs.
• UPDATED_BY_ID — the identifier of the user or process that performed the update.
• COLUMN_NAME — the name of the audited column.
• OLD_VALUE / NEW_VALUE — the translated before-and-after values captured at audit time.
• CREATED_BY, CREATION_DATE, LAST_UPDATED_BY, LAST_UPDATE_DATE, LAST_UPDATE_LOGIN — standard EBS who-columns for audit trail purposes.

Common Use Cases and Queries

The intended use case for this view is to reconstruct the audit history of defect records in CSS – Support, filtering by the audit timestamp or defect identifier. Because the object is flagged as obsolete and not implemented, queries against it will fail with ORA-00942 unless the underlying tables have been retained from a legacy implementation.

A representative query, had the view been deployed, would resemble the following:

SELECT audit_column_id, defect_id, column_name, old_value, new_value, audit_date
FROM css_def_audit_columns_vl
WHERE audit_date >= :start_date
AND audit_date < :end_date
ORDER BY audit_date DESC;

In practice, consultants encountering this view during a 12.1.1 to 12.2.2 upgrade should treat it as retired and confirm its absence in the database before designing any report or integration around it. Where audit history of defects remains a requirement, the replacement is typically found in the current defect management schema rather than in the CSS – Support legacy tables.