FlexBiSetup helper table
Module: General Ledger
STRUCTURE_INSTANCE_CODE, STRUCTURE_CODE, STRUCTURE_ID, ENTERPRISE_ID, STRUCTURE_INSTANCE_ID, APPLICATION_ID, STRUCTURE_INSTANCE_NUMBER, KEY_FLEXFIELD_CODE, SEGMENT_LABEL_CODE, SEGMENT_CODE
| 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.