Search Results fnd_document_sequences




The FND_DOCUMENT_SEQUENCES table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for managing document sequencing functionality, which ensures compliance with legal and financial reporting requirements. Document sequencing provides a mechanism to assign unique, sequential numbers to transactions, invoices, receipts, and other business documents, maintaining an audit trail and preventing gaps or duplicates. This table serves as the foundation for configuring, storing, and tracking these sequences across modules like General Ledger (GL), Accounts Payable (AP), and Accounts Receivable (AR).

Key Attributes of FND_DOCUMENT_SEQUENCES

The table structure includes the following key columns:
  • DOC_SEQUENCE_ID: Primary key, uniquely identifying each document sequence.
  • APPLICATION_ID: Associates the sequence with an EBS application (e.g., GL, AP).
  • NAME: User-defined name for the sequence (e.g., "AP_INVOICE_SEQ").
  • TYPE: Defines the sequence type (e.g., "AUTO" for automatic numbering).
  • START_DATE and END_DATE: Active period for the sequence.
  • LAST_NUMBER: Tracks the last assigned sequence number.
  • STATUS: Indicates whether the sequence is "ACTIVE" or "INACTIVE".

Functional Role in Oracle EBS

Document sequencing is mandatory in many jurisdictions for audit compliance. The FND_DOCUMENT_SEQUENCES table enables:
  • Automatic Numbering: Assigns sequential numbers to transactions without manual intervention.
  • Gap Prevention: Ensures no missing numbers, even if transactions are deleted or voided.
  • Audit Trail: Logs sequence assignments in related tables like FND_DOCUMENT_SEQUENCE_ASSIGN.
  • Cross-Module Consistency: Supports sequences for invoices, journals, receipts, etc., across financial modules.

Integration with Other Components

The table interacts with:
  • FND_DOCUMENT_SEQUENCE_CATEGORIES: Defines categories (e.g., "Invoice") for sequences.
  • FND_DOCUMENT_SEQUENCE_ASSIGN: Maps sequences to specific applications or responsibilities.
  • GL_DOCUMENT_SEQUENCES: Stores accounting-specific sequence data.

Technical Considerations

  • Concurrency Control: Oracle uses row-level locking to prevent duplicate assignments during high-volume transactions.
  • Performance: Indexes on DOC_SEQUENCE_ID and APPLICATION_ID optimize query performance.
  • Customization: Sequences can be extended via APIs like FND_DOCUMENT_SEQUENCE_SYSTEM.

Common Use Cases

  • Invoice Numbering: AP modules use sequences to generate unique invoice numbers.
  • Journal Entry Tracking: GL assigns sequential numbers to journal batches.
  • Legal Compliance: Ensures adherence to fiscal regulations requiring non-reusable, contiguous numbers.

Conclusion

The FND_DOCUMENT_SEQUENCES table is a cornerstone of Oracle EBS's document management framework, providing robust, auditable, and compliant sequencing for financial transactions. Its integration with core modules and extensible design makes it indispensable for organizations operating in regulated environments.