Search Results minor_id_column_name

Overview

The FII_FA_CAT_SEGMENTS table, owned by the FII schema, stores the Asset Category key flexfield structure configuration for Oracle E-Business Suite. Its role is to record, for each flexfield structure, how the major and minor qualified segments are set up — specifically the column names, table names, validation types, and SQL fragments that the flexfield builder uses to resolve segment values when the underlying value sets are table-based.

Within the Oracle Assets data model, this is a low-volume, setup-oriented configuration table rather than a transactional or accounting fact table. It governs the presentation and validation behaviour of the Asset Category flexfield (the flexfield behind the asset category, book, and related asset attribute combinations). Because changes to this table alter how segment values are looked up, it is treated as reference data maintained through the flexfield setup and concurrent program infrastructure rather than by direct DML.

Applying heuristic Data Vault classification, the object is best modelled as a standalone satellite keyed by its flexfield structure identifier. The metadata records no functional foreign-key parents, and the physical schema includes the standard WHO audit columns (CREATION_DATE, CREATED_BY, LAST_UPDATE_DATE, LAST_UPDATED_BY, LAST_UPDATE_LOGIN), which are characteristic of a descriptive satellite rather than a hub or a link.

Key Information Stored

The table is uniquely identified by FLEX_STRUCTURE_ID through the unique index FII_FA_CAT_SEGMENTS_U1, which also serves as the primary key candidate. The remaining columns are descriptive attributes organised into two symmetrical groups, one per segment role:

• FLEX_STRUCTURE_ID — the key flexfield structure defining column; the surrogate primary key and the join key to dependent objects.
• MAJOR_SEG_NAME / MINOR_SEG_NAME — the column names of the major and minor segments within the flex combination table.
• MAJOR_VAL_TYPE_CODE / MINOR_VAL_TYPE_CODE — the validation type used by each segment's value set, determining whether the segment is validated against a table, an independent list, or a lookup.
• MAJOR_TABLE_NAME / MINOR_TABLE_NAME — the source table used for the segment when the value set is table-based.
• MAJOR_VALUE_COLUMN_NAME / MINOR_VALUE_COLUMN_NAME — the column supplying the displayed segment value from that source table.
• MAJOR_ID_COLUMN_NAME / MINOR_ID_COLUMN_NAME — the column supplying the internal segment identifier.
• MAJOR_ADD_WHERE_CLAUSE / MINOR_ADD_WHERE_CLAUSE — additional SQL WHERE fragments restricting the rows returned for each segment.
• DEPENDANT_VALUE_SET_FLAG — indicates whether the minor segment's value set is dependent on the major segment.

The recorded business-key candidate is the flexfield structure identifier; the segment name and table/column attributes are descriptive configuration rather than alternate keys.

Common Use Cases and Queries

Typical usage centres on documenting and troubleshooting the Asset Category flexfield setup, and on generating metadata-driven SQL that reproduces the flexfield's value lookup. A frequent access pattern retrieves the full definition for a structure:

• Configuration review — SELECT flex_structure_id, major_seg_name, minor_seg_name, major_val_type_code, minor_val_type_code FROM fii.fii_fa_cat_segments WHERE flex_structure_id = :structure_id;
• Table-based value set inventory — filter on rows where MAJOR_TABLE_NAME or MINOR_TABLE_NAME is not null to identify segments resolved against database tables, then inspect MAJOR_VALUE_COLUMN_NAME and MAJOR_ID_COLUMN_NAME to understand the lookup columns.
• Dynamic query generation — concatenate MAJOR_TABLE_NAME, MAJOR_VALUE_COLUMN_NAME, MAJOR_ID_COLUMN_NAME, and MAJOR_ADD_WHERE_CLAUSE to build a validated list of values for the major segment; repeat with the MINOR_* columns.
• Dependency analysis — check DEPENDANT_VALUE_SET_FLAG to confirm whether the minor segment value set must be filtered by the chosen major value, which affects the design of dependent LOVs and any downstream reporting joins.
• Impact analysis — join to FII_FA_CAT_DIMENSIONS on FLEX_STRUCTURE_ID to determine which asset category dimensions are affected by a change to the flexfield structure.

Related Objects

The documented dependency information identifies FII_FA_CAT_DIMENSIONS as the principal dependent object; the relationship is maintained through the FLEX_STRUCTURE_ID column, which is a foreign key in that table referencing the primary key of FII_FA_CAT_SEGMENTS. Additional objects that interact with this configuration data, based on the broader Oracle Assets flexfield infrastructure, include:

• FII_FA_CAT_DIMENSIONS — stores the asset category dimension definitions and references FII_FA_CAT_SEGMENTS.FLEX_STRUCTURE_ID.
• FND_FLEX_VALUES and FND_FLEX_VALUE_SETS — define the value sets and validation types recorded in the *_VAL_TYPE_CODE columns.
• FND_ID_FLEX_STRUCTURES — holds the flexfield structure definition that FLEX_STRUCTURE_ID identifies.
• FND_FLEX_VALIDATION_TABLES — relates to the table-based validation configuration captured by the *_TABLE_NAME and *_VALUE_COLUMN_NAME columns.
• FA_CATEGORIES and the asset category flexfield combination table — consume the segment configuration when presenting the Asset Category flexfield to users.