Search Results fnd_doc_sequence_users




Overview
Explore in AI Chat

Overview

The FND_DOC_SEQUENCE_USERS table is a core data object within the Application Object Library (FND) module of Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. It functions as a junction table that defines the specific user-level assignments for document sequences. Document sequences are a critical EBS feature for generating unique, auditable numbers for transactions like invoices, purchase orders, and journal entries. This table, owned by the APPLSYS schema, operationalizes the security and assignment rules by linking individual users to specific document sequence assignments, thereby controlling which users can generate numbers from which sequences within a given assignment context.

Key Information Stored

The table's structure centers on a composite primary key that uniquely identifies a user's permission for a specific sequence assignment. The key columns are DOC_SEQUENCE_ID, which references the master sequence definition in FND_DOCUMENT_SEQUENCES; DOC_SEQUENCE_ASSIGNMENT_ID, which references the application and category context defined in FND_DOC_SEQUENCE_ASSIGNMENTS; and USER_ID, which identifies the individual user. There are no other columns documented in the provided metadata, indicating that the table's sole purpose is to maintain these assignment relationships. The presence of a user in this table for a given DOC_SEQUENCE_ID and DOC_SEQUENCE_ASSIGNMENT_ID signifies that the user is authorized to use that sequence within that assigned context.

Common Use Cases and Queries

This table is primarily accessed for auditing, troubleshooting, and administrative reporting related to document sequencing security. A common operational query is to list all document sequences a specific user can access, which involves joining to FND_DOCUMENT_SEQUENCES and FND_DOC_SEQUENCE_ASSIGNMENTS to get descriptive names and context. Conversely, administrators may query to find all users assigned to a particular sequence to review security before modifying or obsoleting the sequence. Sample SQL to find accessible sequences for a user would be:

  • SELECT fu.user_name, fds.name seq_name, fdca.application_id
    FROM fnd_doc_sequence_users fdsu,
    fnd_document_sequences fds,
    fnd_doc_sequence_assignments fdca,
    fnd_user fu
    WHERE fdsu.user_id = fu.user_id
    AND fdsu.doc_sequence_id = fds.doc_sequence_id
    AND fdsu.doc_sequence_assignment_id = fdca.doc_sequence_assignment_id
    AND fu.user_name = 'OPERATIONS_USER';

Related Objects

The table maintains defined foreign key relationships with two other core FND tables, forming an integral part of the document sequencing data model. The relationships, as per the provided metadata, are:

  • FND_DOCUMENT_SEQUENCES: The column FND_DOC_SEQUENCE_USERS.DOC_SEQUENCE_ID references this table to link the user assignment to the master sequence definition.
  • FND_DOC_SEQUENCE_ASSIGNMENTS: The column FND_DOC_SEQUENCE_USERS.DOC_SEQUENCE_ASSIGNMENT_ID references this table to link the user to the specific application and category context where the sequence is active.

The table's primary key, FND_DOC_SEQUENCE_USERS_PK, enforces uniqueness on the combination of these three foreign key columns (DOC_SEQUENCE_ID, DOC_SEQUENCE_ASSIGNMENT_ID, USER_ID).