Results for “ce_doc_sequence_audit”

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

Overview

CE_DOC_SEQUENCE_AUDIT is a Cash Management (CE) schema table that records the assignment of document sequence values to Cash Management transactions in Oracle E-Business Suite 12.1.1 and 12.2.2. It functions as a document sequencing audit table, providing the auditable linkage between a document sequence definition and each individual sequence value consumed by a transaction. Because Document Sequencing is a statutory requirement in several countries, this table preserves the immutable record of which number was consumed, when, and by whom, supporting both fiscal reporting and internal controls.

From a data modeling perspective, the ETRM metadata classifies this object as satellite-leaning. In Data Vault terms, the table behaves as a satellite attached to the document sequence hub (FND_DOCUMENT_SEQUENCES), capturing descriptive and transactional attributes (the sequence value and audit columns) rather than defining the business key itself. This classification is heuristic and should be treated as a modeling suggestion, not a normative statement from Oracle.

Key Information Stored

• DOC_SEQUENCE_ID — Foreign key to FND_DOCUMENT_SEQUENCES. Identifies the document sequence definition that generated the value. Part of the composite primary key.
• DOC_SEQUENCE_VALUE — The actual sequence number assigned to the transaction. Part of the composite primary key and the business-key candidate.
• DOC_SEQUENCE_ASSIGNMENT_ID — Foreign key to FND_DOC_SEQUENCE_ASSIGNMENTS. Links the audit row to the specific sequence assignment (the combination of sequence, category, and application context).
• CREATION_DATE — Timestamp of when the audit record was created, i.e., when the sequence value was consumed.
• CREATED_BY — The application user or process that created the audit record.

The primary key is CE_DOC_SEQUENCE_AUDIT_PK, defined on (DOC_SEQUENCE_ID, DOC_SEQUENCE_VALUE). A unique index, CE_DOC_SEQUENCE_AUDIT_U1, covers the same column pair, reinforcing the natural business key: a given sequence value must be unique within its sequence definition. The table contains five documented columns in total.

Common Use Cases and Queries

Typical uses include statutory audit reporting, gap analysis of consumed sequence numbers, reconciliation of Cash Management documents against their assigned sequence values, and troubleshooting of document numbering issues (for example, missing or duplicated numbers).

A representative query joins the audit table to the sequence definition to list all values consumed for a given sequence:

• SELECT a.doc_sequence_value, a.creation_date, a.created_by FROM ce_doc_sequence_audit a WHERE a.doc_sequence_id = :seq_id ORDER BY a.doc_sequence_value;

To detect gaps between the minimum and maximum consumed value for a sequence:

• SELECT MIN(doc_sequence_value) min_v, MAX(doc_sequence_value) max_v, COUNT(*) cnt, (MAX(doc_sequence_value)-MIN(doc_sequence_value)+1)-COUNT(*) gaps FROM ce_doc_sequence_audit WHERE doc_sequence_id = :seq_id;

Reporting scenarios include period-end audit extracts by CREATION_DATE and CREATED_BY, and joins to FND_DOC_SEQUENCE_ASSIGNMENTS to attribute consumed values to a specific assignment and category.

Related Objects

• FND_DOCUMENT_SEQUENCES — joined on DOC_SEQUENCE_ID; defines the sequence header (name, type, initial value) and is the hub this satellite attaches to.
• FND_DOC_SEQUENCE_ASSIGNMENTS — joined on DOC_SEQUENCE_ASSIGNMENT_ID; maps the sequence to a category, application, and numbering context.
• CE_STATEMENT_HEADERS and CE_STATEMENT_LINES — Cash Management statement documents whose sequence assignment benefits from auditing against this table.
• CE_BANK_ACCOUNTS — referenced indirectly through statement and payment processing that consumes sequences.
• FND_DOC_SEQUENCE_CATEGORIES — provides category context for the assignments referenced by DOC_SEQUENCE_ASSIGNMENT_ID.

Together, these relationships make CE_DOC_SEQUENCE_AUDIT a critical audit-facing satellite within the Cash Management document sequencing framework.