Search Results as_ref_audits

Overview

The table AS_REF_AUDITS is a legacy data object within the Oracle E-Business Suite (EBS) Sales Foundation (AS) module. According to the official ETRM documentation for versions 12.1.1 and 12.2.2, its status is explicitly noted as "No Longer Used" and "Not implemented in this database." This indicates that while the table's definition may exist in the data dictionary for historical or reference purposes, it is not actively populated or maintained by the application's codebase. Its intended role, prior to deprecation, was likely to store audit trail information related to reference data within the Sales module, but this functionality has been superseded or removed in the documented releases.

Key Information Stored

Based on the provided metadata, the primary structural detail known about this table is its primary key constraint, ASF_REF_AUDITS_PK, which is defined on a single column named AUDIT_ID. The column AUDIT_ID would have served as a unique identifier for each audit record. No other columns are documented, reinforcing the table's deprecated and unimplemented status. The lack of implementation details suggests that any historical data model it once represented has been migrated or archived elsewhere in the application schema.

Common Use Cases and Queries

Given the documented status, there are no active use cases for the AS_REF_AUDITS table in Oracle EBS 12.1.1 or 12.2.2. Technical consultants and DBAs should not develop new code, integrations, or reports that reference this object. A sample query to verify its unimplemented status would be a simple record count, which is expected to return zero rows in a standard environment:

• SELECT COUNT(*) FROM AS_REF_AUDITS;

If this query returns a significant number of rows in a production system, it may indicate a highly customized instance or data migration artifact, warranting further investigation. Standard reporting and audit functionality within the Sales Foundation module are served by other, active application tables.

Related Objects

The ETRM metadata does not list any foreign key relationships to or from the AS_REF_AUDITS table. The only documented relationship is its own primary key constraint (ASF_REF_AUDITS_PK on AUDIT_ID). The absence of foreign keys is consistent with a table that is no longer part of the active application data model. Developers and system integrators should consult current application documentation or seeded database constraints to identify the active tables that now handle audit tracking for Sales Foundation reference data, as no dependencies on AS_REF_AUDITS are expected.