Search Results fun_seq_assignments_dfv

Overview

FUN_SEQ_ASSIGNMENTS_DFV is a reporting-oriented database view owned by the APPS schema within the FND (Application Object Library) product family. The suffix "DFV" denotes a descriptive flexfield view — a construct Oracle E-Business Suite uses to expose flexfield-enabled attributes in a flattened, denormalized form suitable for inquiry, reporting, and integration. In the context of Oracle EBS 12.1.1 and 12.2.2, this view presents sequencing assignments defined for subledger and general ledger accounting processes, including period close, journal posting, and accounting entry completion. Its principal role is to translate the underlying assignment records into business-meaningful text by normalizing the control attribute structure. Rather than requiring downstream consumers to interpret raw control attribute values, the view applies DECODE logic to surface the balance type, journal source, journal category, document category, accounting event type, and accounting entry type where these are relevant to the associated control attribute structure.

Underlying Base Objects

The view is defined over a single documented base object: FUN_SEQ_ASSIGNMENTS, referenced through a synonym. The base table stores the physical rows describing which sequencing rules apply to which control attribute structures. FUN_SEQ_ASSIGNMENTS_DFV selects a subset of columns from that table while transforming several of them. One column is exposed directly as the table's ROWID, which supports updatable or uniquely identified access patterns common to descriptive flexfield views. The remainder of the projection is derived through DECODE expressions keyed on CONTROL_ATTRIBUTE_STRUCTURE. The recognized structures in the view text are XLA_AE_PERIOD_CLOSE, XLA_AE_COMPLETION, GL_JE_POSTING, and GL_JE_PERIOD_CLOSE. For each, the view determines whether BALANCE_TYPE, JOURNAL_SOURCE, and JOURNAL_CATEGORY should be revealed; for completion-related structures, DOCUMENT_CATEGORY, ACCOUNTING_EVENT_TYPE, and ACCOUNTING_ENTRY_TYPE are additionally surfaced. A final concatenated column builds a composite control attribute identifier tailored to each structure, with the XLA_AE_COMPLETION variant producing the longest fully qualified string.

Key Columns

The view exposes the following material columns:

• ROWID — Identifies the underlying row in FUN_SEQ_ASSIGNMENTS.
• CONTROL_ATTRIBUTE_STRUCTURE — The discriminator that determines how the remaining derived columns are populated; values observed include the XLA and GL structures noted above.
• BALANCE_TYPE — Returned for the recognized structures, NULL otherwise.
• JOURNAL_SOURCE — Returned for the recognized structures, NULL otherwise.
• JOURNAL_CATEGORY — Returned for the recognized structures, NULL otherwise.
• DOCUMENT_CATEGORY — Exposed directly from the base table.
• ACCOUNTING_EVENT_TYPE — Exposed directly from the base table.
• ACCOUNTING_ENTRY_TYPE — Exposed directly from the base table.
• Composite control attribute column — A concatenation built according to the control attribute structure, yielding a fully qualified identifier used to match sequencing assignments to runtime accounting activity.

Common Use Cases and Queries

Typical uses include auditing which sequencing assignments exist per accounting structure, validating that the expected balance type, journal source, and journal category are populated for GL posting and period-close flows, and supporting subledger (XLA) period-close or completion configuration reviews. Analysts often filter the view by control attribute structure to isolate GL versus XLA assignments.

Sample query returning assignments for a specific structure:

• SELECT control_attribute_structure, balance_type, journal_source, journal_category FROM apps.fun_seq_assignments_dfv WHERE control_attribute_structure = 'GL_JE_POSTING';

Sample query enumerating all assignments with their derived attributes:

• SELECT control_attribute_structure, balance_type, journal_source, journal_category, document_category, accounting_event_type, accounting_entry_type FROM apps.fun_seq_assignments_dfv ORDER BY 1;

Because the view performs the DECODE translation internally, these queries avoid replicating business logic and remain consistent across Oracle EBS 12.1.1 and 12.2.2 environments. Access should be restricted to the APPS schema and appropriately authorized responsibilities.