Search Results fnd_doc_sequence_assignments




Overview
Explore in AI Chat

Overview

The FND_DOC_SEQUENCE_ASSIGNMENTS table is a core repository table within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It serves as the central assignment engine for document sequencing, a critical control feature that ensures the generation of unique, auditable, and often sequential numbers for key business documents such as invoices, purchase orders, and journal entries. This table defines the specific linkage between a pre-defined document sequence (from FND_DOCUMENT_SEQUENCES) and the application contexts where it is to be applied, thereby governing the numbering behavior for transactional documents across the suite.

Key Information Stored

The table's primary purpose is to store assignment rules. Its key columns include the surrogate primary key DOC_SEQUENCE_ASSIGNMENT_ID. The critical foreign key DOC_SEQUENCE_ID links to the specific sequence definition in FND_DOCUMENT_SEQUENCES. The APPLICATION_ID and CATEGORY_CODE columns work together to define the scope of the assignment, linking to FND_DOC_SEQUENCE_CATEGORIES to identify the type of document (e.g., "Sales Order," "AP Invoice") within a given application. Other columns typically govern assignment parameters such as the effective date range (START_DATE, END_DATE) and assignment-level defaults that can override the base sequence settings, ensuring the numbering logic is correctly applied to the intended business events.

Common Use Cases and Queries

Primary use cases involve auditing, troubleshooting, and reporting on document sequencing setup. Database administrators and functional consultants query this table to verify active assignments, diagnose missing or duplicate document numbers, and understand the sequencing rules for a given transaction type. A common diagnostic query joins to related tables to list all assignments:

  • SELECT fdsa.doc_sequence_assignment_id, fds.name sequence_name, fdsa.application_id, fdsc.name category_name, fdsa.start_date, fdsa.end_date FROM apps.fnd_doc_sequence_assignments fdsa, apps.fnd_document_sequences fds, apps.fnd_doc_sequence_categories fdsc WHERE fdsa.doc_sequence_id = fds.doc_sequence_id AND fdsa.application_id = fdsc.application_id AND fdsa.category_code = fdsc.code AND fdsa.end_date IS NULL;

This identifies all currently active assignments, showing which sequence is applied to which document category. Another critical use is tracing the origin of a generated document number back through the audit tables (e.g., AP_DOC_SEQUENCE_AUDIT) to its root assignment in this table.

Related Objects

FND_DOC_SEQUENCE_ASSIGNMENTS is a central hub in the document sequencing schema. It has a direct foreign key relationship to FND_DOCUMENT_SEQUENCES (the sequence definition) and FND_DOC_SEQUENCE_CATEGORIES (the document type). Crucially, it is referenced as a parent table by numerous audit and user tables across application modules, including AP_DOC_SEQUENCE_AUDIT (Payables), AR_DOC_SEQUENCE_AUDIT (Receivables), OE_DOC_SEQUENCE_AUDIT (Order Management), FND_DOC_SEQUENCE_AUDIT (core), and FND_DOC_SEQUENCE_USERS. These child tables store the runtime audit trail and user-specific overrides for each assignment, making FND_DOC_SEQUENCE_ASSIGNMENTS the definitive source for the assignment rule itself.