Search Results fnd_document_sequences_ap_v




Overview
Explore in AI Chat

Overview

FND_DOCUMENT_SEQUENCES_AP_V is a reporting view owned by the APPS schema in Oracle E-Business Suite. It is registered under the Payables (AP) product and exposes document sequence assignments that are relevant to Oracle Payables. The view is documented in ETRM metadata as originating from Release 10SC, and it remains present in the EBS 12.1.1 and 12.2.2 data models as a legacy compatibility object.

The view presents a joined, denormalized picture of the document sequencing configuration that Payables uses to number documents such as invoices, payments, and related accounting entries. Rather than requiring a report or integration to join the underlying sequence, category, assignment, and system parameter tables manually, the view surfaces the sequence name, category name and code, the associated table name, and the relevant organization and set of books identifiers in a single row. Because it is a view and not a table, it carries no storage of its own; it always reflects the current state of the underlying configuration tables.

The object is primarily a query and reporting aid. It allows developers, DBAs, and functional consultants investigating the "doc_sequence_name" attribute to resolve which sequence is assigned to a given document category for a given operating unit or set of books.

Underlying Base Objects

The documented base objects referenced by FND_DOCUMENT_SEQUENCES_AP_V are:

The view joins these objects on DOC_SEQUENCE_ID, CATEGORY_CODE, APPLICATION_ID = 200 (Payables), and set of books, and filters for assignment method code 'M' or NULL. It also restricts rows to assignments that are currently effective, testing whether SYSDATE falls between the assignment START_DATE and END_DATE, with NVL defaults that treat missing dates as open-ended. Note that the documented SQL concatenates a space to the sequence identifier, an implementation detail that can affect direct joins against FND_DOCUMENT_SEQUENCES.

Key Columns

  • DOC_SEQUENCE_NAME — the name of the assigned document sequence; the attribute most commonly searched.
  • DOC_SEQUENCE_ID — the internal identifier of the sequence.
  • DOC_CATEGORY_NAME — the descriptive name of the document category.
  • DOC_CATEGORY_CODE — the category code used for internal matching.
  • DESCRIPTION — free-text description of the category.
  • TABLE_NAME — the base table associated with the category, indicating the document type being numbered.
  • ORG_ID — the operating unit context from AP_SYSTEM_PARAMETERS.
  • SET_OF_BOOKS_ID — the ledger/set of books context for the assignment.

Common Use Cases and Queries

Typical uses include reconciling which sequence numbers a Payables document type, validating sequencing setup during implementation, and auditing effective-dated assignments. A representative query retrieves sequence assignments by name or category:

SELECT doc_sequence_name, doc_category_name, doc_category_code, table_name, org_id, set_of_books_id FROM apps.fnd_document_sequences_ap_v WHERE doc_sequence_name = :p_sequence_name;

Because the view already filters for application 200 and current effective dates, results reflect only active Payables sequencing. For historical or cross-application analysis, query the underlying FND_DOC_SEQUENCE_ASSIGNMENTS table directly.