# DW_FLEX_BI_SETUP_H

FlexBiSetup helper table

## Details

Module: General Ledger

## Key Columns

STRUCTURE_CODE, KEY_FLEXFIELD_CODE, STRUCTURE_INSTANCE_ID, APPLICATION_ID, ENTERPRISE_ID, STRUCTURE_INSTANCE_NUMBER, SEGMENT_CODE, SEGMENT_LABEL_CODE, STRUCTURE_INSTANCE_CODE, STRUCTURE_ID

## Columns

Columns
Name | Datatype | Length | Precision | Not Null | Comments | Referred Table | Referred Column
--- | --- | --- | --- | --- | --- | --- | ---
APPLICATION_ID | NUMBER | 38 | 0 | True | Identifier of the Fusion application (e.g., GL# = 101, COST= 801) that owns the KFF. |  |
KEY_FLEXFIELD_CODE | VARCHAR2 | 16 |  | True | System code that identifies which KFF this structure belongs to (e.g., GL# for General Ledger Chart of Accounts, XCC for Budgetary Control, etc.). |  |
STRUCTURE_INSTANCE_NUMBER | NUMBER | 38 | 0 | True | Sequential number assigned to a deployed instance of the structure (useful for ordering multiple instances). |  |
STRUCTURE_CODE | VARCHAR2 | 32 |  | True | User-friendly code given to the structure (e.g., OPERATIONS_ACCOUNTING_FLEX). |  |
STRUCTURE_INSTANCE_CODE | VARCHAR2 | 32 |  | True | User-defined code for the instance (e.g., 102_OPERATIONS_ACCOUNTING_FLEX). |  |
SEGMENT_CODE | VARCHAR2 | 32 |  | True | Unique code of a segment within the instance (e.g., COMPANY, ACCOUNT). |  |
SEGMENT_LABEL_CODE | VARCHAR2 | 32 |  | True | Code of the segment label (qualifier) assigned to this segment (e.g., BALANCING, COST_CENTER). |  |
ENTERPRISE_ID | NUMBER | 38 | 0 | True | Identifier of the enterprise (multi-tenant partition) to which the flexfield definition belongs. Guarantees isolation across tenants. |  |
STRUCTURE_ID | NUMBER | 38 | 0 | True | Primary key of the Key Flexfield structure (the template definition). Uniquely identifies a KFF structure within an enterprise/application/flexfield code. |  |
STRUCTURE_INSTANCE_ID | NUMBER | 38 | 0 | True | Primary key of the KFF structure instance the actual runtime configuration attached to a ledger, legal entity, etc. |  |
SOURCE_RECORD_ID | VARCHAR2 | 999 |  |  | This column is for Oracle Internal use only. Source record identifier |  |
BI_OBJECT_NAME | VARCHAR2 | 256 |  |  | Name of the BI subject-area object that corresponds to the label (used by OTBI to map the segment to a logical column). |  |
BI_ENABLED_FLAG | VARCHAR2 | 16 |  |  | 'Y' = segment is exposed to Oracle BI (OTBI/OBIA) for reporting; 'N' = hidden from BI. |  |
SEGMENT_LABEL_LENGTH | NUMBER | 38 | 0 |  | String length of the SEGMENT_LABEL_CODE value |  |
SEGMENT_LABEL_LENGTH_COMPLIANCE_FLAG | VARCHAR2 | 16 |  |  | 'Y' = complaint with the SEGMENT_LABEL_CODE length guideline i.e. 21. 'N' = Non- complaint. |  |
SEGMENT_LABEL_COMPLIANCE_FLAG | VARCHAR2 | 16 |  |  | 'Y' = complaint with all the standards for naming SEGMENT_LABEL_CODE. 'N' = Non- complaint. |  |
STRUCTURE_ENABLED_FLAG | VARCHAR2 | 16 |  |  | 'Y' = structure is active and can be used; 'N' = disabled. |  |
STRUCTURE_INSTANCE_ENABLED_FLAG | VARCHAR2 | 16 |  |  | 'Y' = instance is active; 'N' = disabled. |  |
PROTECTED_FLAG | VARCHAR2 | 16 |  |  | 'Y' = value set is protected (cannot be modified via UI after deployment). |  |
SECURITY_ENABLED_FLAG | VARCHAR2 | 16 |  |  | 'Y' = data-security policies are enforced on the value set (via Data Security Object). |  |
VALUE_SET_ID | NUMBER | 38 | 0 |  | Foreign key to FND_VS_VALUE_SETS. Links the segment to the value set that supplies its valid values. |  |
VALUE_SET_CODE | VARCHAR2 | 64 |  |  | User-friendly code of the value set (e.g., DEPT_VALUES). |  |
DESCRIPTION | VARCHAR2 | 256 |  |  | Human-readable description of the value set. |  |
VALIDATION_TYPE | VARCHAR2 | 32 |  |  | Type of validation: INDEPENDENT, DEPENDENT, FORMAT, TABLE etc. |  |
VALUE_DATA_TYPE | VARCHAR2 | 32 |  |  | Data type of the values: VARCHAR2, NUMBER, DATE, DATETIME. |  |
VALUE_SUBTYPE | VARCHAR2 | 32 |  |  | Sub-type for special handling (e.g., TEXT, INTEGER, FLOAT). |  |
MAXIMUM_LENGTH | NUMBER | 38 | 0 |  | Maximum character length allowed for values (applies to CHAR data type). |  |
DATA_SECURITY_OBJECT_NAME | VARCHAR2 | 64 |  |  | Name of the Data Security Object that controls row-level security for the values. |  |

Copyright © 2019, 2026, Oracle and/or its affiliates.