Search Results control_attribute_structure

Overview

APPS.FUN_SEQ_ASSIGNMENTS_DFV is a descriptive flexfield (DFV) view in Oracle E-Business Suite Release 12.1.1 and 12.2.2, owned by the APPS schema. It is defined over the underlying synonym FUN_SEQ_ASSIGNMENTS. The view exists to expose the concatenated and decoded key segments of the sequence assignment descriptive flexfield so that downstream processes, concurrent programs, and reporting tools can consume a single, normalized identifier rather than assembling the individual components themselves. In the context of the user's search for "journal_source," this view is significant: JOURNAL_SOURCE is one of the columns exposed, and it is embedded inside the composite concatenated key that the view generates.

The view serves as a bridge between the raw flexfield structure of FUN_SEQ_ASSIGNMENTS and the accounting/sequencing logic that relies on it. It is widely encountered when diagnosing subledger accounting or general ledger journal sequencing, because the CONTROL_ATTRIBUTE_STRUCTURE drives how a specific document or journal is categorized for numbering.

Underlying Base Objects

The documented base object is the synonym FUN_SEQ_ASSIGNMENTS, which resolves to the sequence assignment flexfield table. The view performs no joins; it is a single-table projection that applies DECODE logic to the CONTROL_ATTRIBUTE_STRUCTURE column. The DECODE statements flatten the stored flexfield segments into discrete columns conditioned on the value of CONTROL_ATTRIBUTE_STRUCTURE, and then reassemble them into a composite concatenated string.

The four recognized control attribute structures handled by the view are: XLA_AE_PERIOD_CLOSE, XLA_AE_COMPLETION, GL_JE_POSTING, and GL_JE_PERIOD_CLOSE. Each DECODE returns a value only when the structure matches; otherwise NULL is returned. This design allows a single view to service both Subledger Accounting (XLA) and General Ledger (GL) sequencing requirements.

Key Columns

• ROWID — Standard physical row identifier from the base table.
• CONTROL_ATTRIBUTE_STRUCTURE — The flexfield structure name governing how the remaining segments are interpreted.
• BALANCE_TYPE — Decoded for all four structures; identifies the balance classification (e.g., actual, budget, encumbrance) relevant to sequencing.
• JOURNAL_SOURCE — Decoded for XLA_AE_PERIOD_CLOSE, XLA_AE_COMPLETION, GL_JE_POSTING, and GL_JE_PERIOD_CLOSE. This is the column most relevant to the user's query; it represents the journal source segment used in the concatenated key.
• JOURNAL_CATEGORY — Decoded for the same four structures; the journal category segment.
• DOCUMENT_CATEGORY — Populated only for XLA_AE_COMPLETION; the subledger document category.
• ACCOUNTING_EVENT_TYPE — Populated only for XLA_AE_COMPLETION.
• ACCOUNTING_ENTRY_TYPE — Populated only for XLA_AE_COMPLETION.
• Concatenated key (seventh expression) — A period-separated composite string built from CONTROL_ATTRIBUTE_STRUCTURE, BALANCE_TYPE, JOURNAL_SOURCE, JOURNAL_CATEGORY, and, for XLA_AE_COMPLETION, DOCUMENT_CATEGORY, ACCOUNTING_EVENT_TYPE, and ACCOUNTING_ENTRY_TYPE.

Common Use Cases and Queries

This view is typically queried to inspect or validate how sequence assignments are keyed for a given journal source. A frequent diagnostic pattern is to isolate records by journal source across structures:

• SELECT control_attribute_structure, balance_type, journal_source, journal_category FROM apps.fun_seq_assignments_dfv WHERE journal_source = 'Payables';
• SELECT * FROM apps.fun_seq_assignments_dfv WHERE control_attribute_structure = 'GL_JE_POSTING';
• SELECT control_attribute_structure, balance_type, journal_source FROM apps.fun_seq_assignments_dfv WHERE control_attribute_structure = 'XLA_AE_COMPLETION' AND document_category = 'Payables Invoices';

Because the view returns NULL for segments not applicable to a given structure, filtering on JOURNAL_SOURCE is safe across structures, though values will only appear where the structure's DECODE includes it. The composite key column is useful for auditing uniqueness and for reconciling sequence assignment configuration against expected journal sources during period-close troubleshooting.