Search Results fnd_doc_sequence_categories




Overview
Explore in AI Chat

Overview

The FND_DOC_SEQUENCE_CATEGORIES table is a core repository for document category definitions within the Oracle E-Business Suite Application Object Library (FND). It serves as the master reference for categorizing different types of documents that require sequential numbering via the Document Sequence functionality. This table enables the logical grouping of transactions, such as invoices, purchase orders, or journal entries, allowing for the assignment of unique, auditable, and often gapless numbering sequences specific to each category. Its role is foundational to the document sequencing architecture, providing the classification layer upon which specific sequence assignments are built.

Key Information Stored

The table stores the essential metadata that defines a document category. Its structure is centered on a composite primary key. The key columns are APPLICATION_ID, which identifies the owning Oracle EBS application module (e.g., Payables, Receivables), and CODE, which is the internal unique identifier for the category within that application. While the provided metadata does not list all columns, typical columns in this table include NAME and DESCRIPTION for the category's display name and explanatory text. The table's design ensures that category codes are uniquely scoped within their parent application, preventing conflicts across different functional areas of the system.

Common Use Cases and Queries

This table is primarily referenced for setup, auditing, and troubleshooting document sequencing. Common scenarios include identifying all available categories for a specific application or tracing the definition of a category used in a transaction. A frequent query involves joining with the assignment table to review the complete sequencing setup.

  • Listing all document categories for the General Ledger application (APPLICATION_ID=101):
    SELECT code, name FROM apps.fnd_doc_sequence_categories WHERE application_id = 101;
  • Finding the category definition for a specific transaction type:
    SELECT dsc.* FROM apps.fnd_doc_sequence_categories dsc WHERE dsc.application_id = :app_id AND dsc.code = :category_code;

Related Objects

The FND_DOC_SEQUENCE_CATEGORIES table has a direct parent-child relationship with several key objects in the document sequencing schema. As per the provided metadata, the primary foreign key relationship is with the FND_DOC_SEQUENCE_ASSIGNMENTS table. The assignments table uses the composite key (APPLICATION_ID, CATEGORY_CODE) to link a specific document category to an actual database sequence and define its operational rules (e.g., automatic or manual numbering). Furthermore, this category table is referenced by various product-specific document entities (like invoices or journals) which store the CATEGORY_CODE in their transaction headers to associate each document with its numbering category and sequence.