Search Results fnd_doc_sequence_assignments




The FND_DOC_SEQUENCE_ASSIGNMENTS table in Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2 is a critical repository for managing document sequencing assignments across applications. Document sequencing ensures that transactions are numbered sequentially for audit, compliance, and reporting purposes. This table stores metadata defining how sequences are assigned to documents, applications, and categories, serving as a bridge between the FND_DOCUMENT_SEQUENCES and application-specific documents. ### **Key Attributes and Structure** The table contains the following essential columns: - APPLICATION_ID: Identifies the Oracle Application (e.g., GL, AP) associated with the sequence. - DOC_SEQUENCE_ID: Foreign key to FND_DOCUMENT_SEQUENCES, linking to the sequence definition. - CATEGORY_CODE: Classifies document types (e.g., "INVOICE" in Payables). - USAGE_TYPE: Defines the scope (e.g., "A" for Application-level, "C" for Category-level). - AUTO_ASSIGN_FLAG: Determines if sequences are auto-assigned ("Y") or manually assigned ("N"). - START_DATE and END_DATE: Define the active period for the assignment. ### **Functional Role** 1. **Sequence Assignment Logic**: The table dictates how sequences are mapped to transactions. For example, in Oracle Payables, invoices may use a distinct sequence per category (e.g., "STANDARD" vs. "PREPAYMENT"). 2. **Audit and Compliance**: By enforcing sequential numbering, it supports financial audits and regulatory requirements (e.g., SOX). Gaps or duplicates in sequences trigger alerts. 3. **Integration with Workflows**: Assignments integrate with approval workflows, ensuring sequenced documents follow predefined business rules. ### **Technical Implementation** - **Initialization**: Assignments are configured via Oracle Application Developer or system administration screens. - **Validation**: The FND_DOC_SEQUENCE_ASSIGNMENTS_PKG PL/SQL package validates assignments to prevent overlaps or conflicts. - **Performance**: Indexes on APPLICATION_ID, DOC_SEQUENCE_ID, and CATEGORY_CODE optimize query performance. ### **Version-Specific Considerations** - **EBS 12.1.1**: Uses a single-tenant architecture; assignments are instance-wide. - **EBS 12.2.2**: Supports multi-tenancy (Oracle EBS Cloud Architecture), allowing sequence assignments at the PDB (Pluggable Database) level. ### **Common Use Cases** 1. **Invoice Sequencing in Payables**: Ensures invoices are numbered per legal requirements, with gaps flagged for investigation. 2. **Journal Entry Tracking in General Ledger**: Assigns sequential numbers to batches, aiding reconciliation. ### **Maintenance and Troubleshooting** - **Data Fixes**: Use adadmin or direct SQL (with Oracle Support guidance) to correct misconfigured assignments. - **Monitoring**: Query FND_DOC_SEQUENCE_ASSIGNMENTS to verify active assignments and detect expired entries. In summary, FND_DOC_SEQUENCE_ASSIGNMENTS is a foundational component for document control in Oracle EBS, ensuring traceability and compliance while supporting complex business processes.