Results for “fnd_doc_sequence_access”

28 results




Overview
Explore in AI Chat

AI-generated from documented ETRM metadata — verify critical details on the linked pages.

Overview

FND_DOC_SEQUENCE_ACCESS is a core Application Object Library (FND) table owned by the APPLSYS schema in Oracle E-Business Suite 12.1.1 and 12.2.2. It stores the access control information that determines which Oracle database users are permitted to consume a given document sequence number. In EBS, document sequences provide gap-free or gapless sequential numbering for business documents such as invoices, journals, and purchase orders. Before a sequence can be assigned to a document, it must be secured so that only authorized database accounts (typically application schema owners or specific Oracle users) can draw numbers from it. FND_DOC_SEQUENCE_ACCESS is the assignment table that binds a sequence definition to one or more authorized Oracle user IDs.

From a data modeling perspective, the ETRM metadata classifies this object heuristically as a link table. This is a modeling suggestion rather than a documented fact: the table resolves a many-to-many relationship between document sequences and Oracle users, and its primary key is composed entirely of the two foreign key columns, which is characteristic of an associative (link) entity in a Data Vault or normalized relational design.

Key Information Stored

The documented physical schema contains eight columns. The most significant are:

  • DOC_SEQUENCE_ID — Foreign key to FND_DOCUMENT_SEQUENCES, identifying the document sequence whose access is being granted. Part of the composite primary key.
  • ORACLE_ID — Foreign key to FND_ORACLE_USERID, identifying the Oracle database user granted access. Part of the composite primary key.
  • SYNONYM_CREATED_FLAG — Indicates whether a synonym for the sequence has been generated for the authorized user, supporting transparent sequence invocation from the user's schema.
  • LAST_UPDATE_DATE — Standard audit column recording the most recent modification timestamp.
  • LAST_UPDATED_BY — Audit column identifying the application user who performed the last update.
  • CREATION_DATE — Audit column recording when the access row was first inserted.
  • CREATED_BY — Audit column identifying the user who created the row.
  • LAST_UPDATE_LOGIN — Audit column capturing the login session associated with the last change.

The surrogate/composite primary key is enforced by the constraint FND_DOC_SEQUENCE_ACCESS_PK over (DOC_SEQUENCE_ID, ORACLE_ID). A unique index, FND_DOC_SEQUENCE_ACCESS_U1, covers the same two columns, confirming that the pair is the business-key candidate: no sequence may be granted twice to the same Oracle user. All other columns are descriptive or audit-only.

Common Use Cases and Queries

DBAs and functional consultants query this table to audit document sequence security, particularly after sequence assignment errors such as "APP-xxxxx: You do not have access to sequence." Typical reporting scenarios include listing all users authorized for a given sequence, and identifying sequences with no access grants.

Sample query to list authorized users for a sequence:

  • SELECT a.doc_sequence_id, u.oracle_username, a.synonym_created_flag FROM fnd_doc_sequence_access a, fnd_oracle_userid u WHERE a.oracle_id = u.oracle_id AND a.doc_sequence_id = :seq_id;
  • To find sequences without access grants: SELECT ds.doc_sequence_id, ds.name FROM fnd_document_sequences ds WHERE NOT EXISTS (SELECT 1 FROM fnd_doc_sequence_access a WHERE a.doc_sequence_id = ds.doc_sequence_id);
  • To reconcile audit changes: filter on LAST_UPDATE_DATE to review recent security modifications.

These queries support security reviews, migration validation between 12.1.1 and 12.2.2 environments, and troubleshooting of sequence assignment failures.

Related Objects

  • FND_DOCUMENT_SEQUENCES — Parent definition table; joined on DOC_SEQUENCE_ID. Holds the sequence name, type, and numbering attributes.
  • FND_ORACLE_USERID — Parent lookup of Oracle database users; joined on ORACLE_ID. Resolves the authorized account identity.
  • FND_DOC_SEQUENCE_ASSIGNMENTS — Associates document sequences with application entities such as tables and columns; complements the access model.
  • FND_DOC_SEQUENCE_CATEGORIES — Categorizes document sequences and commonly joins to FND_DOCUMENT_SEQUENCES rather than directly to this table.
  • FND_DOC_SEQUENCE_AUDIT — Records consumed sequence values; indirectly related through the shared sequence ID.

Together these objects form the document sequence security and numbering subsystem within FND.