Results for “fv_ye_group_sequences”

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

Overview

FV_YE_GROUP_SEQUENCES is a Federal Financials (FV) application table in Oracle E-Business Suite Release 12.1.1 and 12.2.2. It stores sequence information for each Year-End (YE) processing group, providing the ordered sequence definitions that drive how a group's accounts are processed during federal year-end close and reporting cycles. The table resides in the FV schema and is documented as VALID in the ETRM metadata for 12.2.2.

Under a Data Vault modeling heuristic mined from the foreign-key structure, FV_YE_GROUP_SEQUENCES is classified as satellite-leaning. In this interpretation, GROUP_ID functions as a parent reference to the FV_YE_GROUPS hub or grouping construct, while the table's own descriptive attributes (sequence identifier, sequence number, set of books, and audit/attribute columns) describe the state of each sequence. This classification is a modeling suggestion only; the physical implementation remains a standard Oracle EBS transactional table with surrogate and business-key unique indexes.

Key Information Stored

The table contains 25 documented columns. The most significant are summarized below, with surrogate and business-key identifiers distinguished as documented.

• SEQUENCE_ID — The surrogate primary key, enforced by unique index FV_YE_GROUP_SEQUENCES_U1. It uniquely identifies each sequence record.
• GROUP_ID — Foreign key to FV_YE_GROUPS, associating the sequence with its owning year-end group.
• SEQUENCE — The ordinal sequence value within a group. It participates with GROUP_ID in unique index FV_YE_GROUP_SEQUENCES_U2 (GROUP_ID, SEQUENCE), making this pair the business-key candidate that guarantees unique ordering per group.
• SET_OF_BOOKS_ID — Identifies the ledger or set of books under which the sequence applies, anchoring the record to a specific accounting configuration.
• LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN — Standard WHO audit columns capturing the most recent modification and the user/session responsible.
• CREATION_DATE, CREATED_BY — Standard WHO audit columns capturing record creation.
• ATTRIBUTE_CATEGORY and ATTRIBUTE1 through ATTRIBUTE15 — The standard Oracle descriptive flexfield (DFF) columns, providing extensible, context-sensitive storage for customer-specific sequence attributes.

Common Use Cases and Queries

Typical uses center on year-end processing configuration and reporting: listing the sequences defined for a group, validating sequence ordering, and joining sequences to the accounts they drive.

• Listing sequences for a group in order:

  SELECT sequence_id, group_id, sequence, set_of_books_id
  FROM   fv.fv_ye_group_sequences
  WHERE  group_id = :p_group_id
  ORDER  BY sequence;

• Joining sequences to their accounts via FV_YE_SEQUENCE_ACCOUNTS to report account coverage per sequence.
• Joining to FV_YE_GROUPS to resolve the group name and attributes for each sequence.
• Audit reporting on configuration changes using LAST_UPDATE_DATE and LAST_UPDATED_BY.
• Extracting DFF attribute values (ATTRIBUTE_CATEGORY and ATTRIBUTE1–15) for downstream federal reporting.

Related Objects

• FV_YE_GROUPS — Parent table referenced by GROUP_ID; defines the year-end groups to which sequences belong.
• FV_YE_SEQUENCE_ACCOUNTS — Child table referencing SEQUENCE_ID from FV_YE_GROUP_SEQUENCES; holds the accounts associated with each sequence.
• FV_YE_GROUP_SEQUENCES_U1 — Unique index on SEQUENCE_ID (surrogate primary key).
• FV_YE_GROUP_SEQUENCES_U2 — Unique index on (GROUP_ID, SEQUENCE), the documented business-key candidate.
• GL_SETS_OF_BOOKS / FND ledger views — Resolve SET_OF_BOOKS_ID to the associated ledger definition.