Search Results oe_doc_sequence_audit

Overview

The OE_DOC_SEQUENCE_AUDIT table is a technical audit table within the Oracle E-Business Suite Order Management (ONT) module. Its primary role is to log and track the creation of document sequences, which are the underlying mechanisms for generating unique order numbers. While it resides in the ONT schema, the table is explicitly utilized by the FND (Foundation) module. This cross-modular usage underscores its function as a core auditing component for a critical system process, ensuring a verifiable trail for the sequences that guarantee order numbering integrity in both EBS 12.1.1 and 12.2.2.

Key Information Stored

While the provided ETRM metadata does not list specific columns, the documented foreign key relationships define its core structure. The table's primary purpose is to link audit records to the master sequence definition and its specific application assignment. The key foreign key columns are DOC_SEQUENCE_ID, which references the FND_DOCUMENT_SEQUENCES table to identify the sequence itself, and DOC_SEQUENCE_ASSIGNMNET_ID, which references the FND_DOCUMENT_SEQUENCE_ASSIGNMENTS table to identify the specific context (e.g., application, category, set of books) where the sequence is used. Typical audit tables in EBS also include standard columns such as CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, and LAST_UPDATED_BY to record who created the sequence and when.

Common Use Cases and Queries

This table is primarily used for diagnostic and compliance auditing rather than operational reporting. Common use cases include tracing the origin of a document sequence used for order numbering, especially during troubleshooting of duplicate or missing order numbers, and validating sequence setup during system audits. A typical query would join to the related Foundation tables to provide a comprehensive audit report.

Sample Query Pattern:
SELECT aud.creation_date,
aud.created_by,
ds.name sequence_name,
dsa.application_id
FROM ont.oe_doc_sequence_audit aud,
fnd_document_sequences ds,
fnd_document_sequence_assignments dsa
WHERE aud.doc_sequence_id = ds.doc_sequence_id
AND aud.doc_sequence_assignment_id = dsa.doc_sequence_assignment_id
ORDER BY aud.creation_date DESC;

Related Objects

The OE_DOC_SEQUENCE_AUDIT table has defined foreign key dependencies on two key Foundation tables, as per the provided relationship data:

• FND_DOCUMENT_SEQUENCES: The audit table references this master table via the column OE_DOC_SEQUENCE_AUDIT.DOC_SEQUENCE_ID. This links each audit record to the specific sequence object that was created.
• FND_DOCUMENT_SEQUENCE_ASSIGNMENTS: The audit table references this assignment table via the column OE_DOC_SEQUENCE_AUDIT.DOC_SEQUENCE_ASSIGNMNET_ID. This links the audit record to the specific context (e.g., for Order Management transactions) where the sequence is applied.

These relationships position OE_DOC_SEQUENCE_AUDIT as a downstream audit entity for the foundational document sequencing setup managed by the FND module.