Search Results segment_attribute30




Overview
Explore in AI Chat

Overview

GL_CODE_COMBINATIONS_KFV is a key flexfield (KFF) concatenated view registered in the APPLICATION_OBJECTS metadata under the APPS schema and owned by the Oracle General Ledger (GL) product. Its status is VALID. The ETRM documentation describes the object with the terse notation "10SC ONLY," which signals that the view is a site-specific or region-specific customisation rather than a wholly generic seeded object supplied identically to every installation. Its role is to expose the accounting flexfield combination in a single, human-readable concatenated form by joining the individual SEGMENTn columns of the underlying combinations table with the configured segment delimiter.

For reporting, interfaces, and integration layers, the value of this view lies in its convenience: downstream queries, concurrent programs, and third-party extracts can resolve a CODE_COMBINATION_ID into a display-ready account string without each consumer re-implementing the segmentation and padding logic.

Underlying Base Objects

The view is defined over the documented base object GL_CODE_COMBINATIONS, referenced through a synonym. GL_CODE_COMBINATIONS is the core General Ledger table storing every valid and invalid account combination, keyed by CODE_COMBINATION_ID, with the individual accounting segment values held in SEGMENT1 through SEGMENT30. The view adds no storage of its own; it is a pure projection and transformation of that table.

Rather than a fixed concatenation, the view applies a DECODE on CHART_OF_ACCOUNTS_ID to select the appropriate segment layout for the identified charts of accounts (for example, the DOCUMENTED values 50132, 50133 and 50134). The first derived column emits the segments joined by a period delimiter, yielding the display string; a second derived column emits the same segments right-padded with NVL defaults and fixed widths, producing a fixed-length variant suitable for positional parsing. All other base columns are passed through unchanged.

Key Columns

  • CODE_COMBINATION_ID — the primary key and join key into GL_CODE_COMBINATIONS and virtually every accounting transaction table.
  • CHART_OF_ACCOUNTS_ID — identifies the chart of accounts, and drives the DECODE that selects which segment concatenation and padding rules apply.
  • Concatenated segment columns — two anonymous derived expressions: one presenting SEGMENT1..SEGMENTn joined with a delimiter, the other the same segments padded to fixed widths. These are the columns that give the view its "_KFV" purpose.
  • ACCOUNT_TYPE — indicates whether the account is an asset, liability, expense, revenue, or owner's equity account.
  • DETAIL_POSTING_ALLOWED_FLAG and DETAIL_BUDGETING_ALLOWED_FLAG — control whether journal entries and budget amounts may be posted or budgeted directly to the combination.
  • START_DATE_ACTIVE / END_DATE_ACTIVE — the effective date range during which the combination is active.
  • DESCRIPTION and TEMPLATE_ID — the descriptive text and the accounting template, if any, associated with the combination.
  • SEGMENT_ATTRIBUTEn and ATTRIBUTEn — descriptive flexfield and segment attribute columns carried through from the base table.

Common Use Cases and Queries

The most frequent use is resolving identifiers into readable account strings for reports and ad hoc analysis.

  • Account string resolution: SELECT code_combination_id, concatenated_segments FROM gl_code_combinations_kfv WHERE code_combination_id = :id;
  • Populating LOVs or validation lists in custom concurrent programs and forms.
  • Extract and integration feeds where an external system requires the formatted accounting flexfield rather than internal IDs.
  • Filtering by chart of accounts to isolate a specific segment layout.

Because the view applies chart-of-accounts specific DECODE logic, and because the metadata marks it "10SC ONLY," references should be validated against the target instance before relying on it in a migration or upgrade. Where portability is required, the SQL logic may be replicated directly against GL_CODE_COMBINATIONS.