Search Results fnd_seqnum




Overview
Explore in AI Chat

Overview

FND_SEQNUM is the Oracle E-Business Suite document sequence engine. Document sequences provide gapless, auditable numbering for business documents such as invoices, journals, purchase orders, payments, and receipts, supporting statutory legal numbering requirements in many jurisdictions. The package body APPS.FND_SEQNUM implements the runtime logic behind the Administrative Document Sequences functionality. It resolves which sequence applies to a given document category and entity, retrieves the next available value, and records usage. The package is tightly coupled to the Document Sequences setup schema, reading definitions from FND_DOCUMENT_SEQUENCES and their assignment records, and it dispatches to underlying database sequences or internal counters depending on whether a sequence is defined as gapless, automatic, or manual. Because it is invoked by numerous EBS products during transaction entry and posting, the package reports a status of VALID and is referenced by 47 other packages, making it a critical shared component of the EBS application foundation layer.

Key Procedures and Functions

Tables Accessed

Usage Notes

FND_SEQNUM is rarely called directly by end users. It is invoked programmatically by EBS forms and concurrent programs during document entry and posting, where the calling product requests the next sequence value after confirming the applicable assignment via a system or manual sequence definition. Custom code may call GET_NEXT_SEQUENCE and ASSIGN_DOC_SEQ when extending EBS functionality with new document types. Administrative setup, including DEFINE_DOC_SEQ and ASSIGN_DOC_SEQ, is normally performed through the Document Sequences responsibility rather than direct API invocation. Because the package creates and consumes database sequences and writes audit records, deployments that customise numbering should account for the transactional behaviour of gapless versus automatic sequences.