Search Results fnd_id_flex_segments
Overview
The FND_ID_FLEX_SEGMENTS table is a core repository for key flexfield segment definitions within Oracle E-Business Suite (EBS) 12.1.1 and 12.2.2. Residing in the APPLSYS schema under the Application Object Library (FND) module, it serves as the central table that defines the individual segments comprising a key flexfield structure. Its primary role is to store the setup information for each segment and to maintain the critical correspondence between a flexfield's logical segments and the physical database columns that store their values. This mapping is essential for the flexfield engine to correctly process, validate, and display data.
Key Information Stored
The table's design centers on uniquely identifying a segment within a specific flexfield structure and detailing its properties. The primary key (FND_ID_FLEX_SEGMENTS_PK) consists of APPLICATION_ID, ID_FLEX_CODE, ID_FLEX_NUM, and APPLICATION_COLUMN_NAME, which together pinpoint a specific segment column. Key columns include SEGMENT_NAME for the internal identifier, SEGMENT_NUM for display order, and FLEX_VALUE_SET_ID, which links the segment to its independent list of valid values. The APPLICATION_COLUMN_NAME is crucial, as it stores the name of the actual table column (e.g., SEGMENT1, SEGMENT2) that holds data for this segment. Additional columns control display characteristics, security, indexing, and required flags.
Common Use Cases and Queries
This table is fundamental for technical analysis, troubleshooting, and generating metadata reports for flexfields. A common use case is to retrieve the complete segment configuration for a specific flexfield, such as the Accounting Flexfield (GL#). Developers and administrators often query this table to understand segment-to-column mappings or to identify which value set is assigned to a segment. Sample queries include listing all segments for a structure or finding segments using a specific value set.
- Retrieve segment setup for the Accounting Flexfield:
SELECT segment_name, segment_num, application_column_name, flex_value_set_id FROM fnd_id_flex_segments WHERE application_id = 101 AND id_flex_code = 'GL#' AND id_flex_num = 101 ORDER BY segment_num; - Find all segments using a specific value set:
SELECT a.application_id, a.id_flex_code, a.id_flex_num, a.segment_name FROM fnd_id_flex_segments a WHERE a.flex_value_set_id = &value_set_id;
Related Objects
As indicated by its foreign keys, FND_ID_FLEX_SEGMENTS has integral relationships with several other key flexfield tables. It is a child of FND_ID_FLEX_STRUCTURES, which defines the overall active structure. It references FND_FLEX_VALUE_SETS for validation. Key dependent objects that store additional data for each segment include FND_ID_FLEX_SEGMENTS_TL for translated segment prompts and FND_SEGMENT_ATTRIBUTE_VALUES for segment-level qualifiers. The table is also referenced by FND_FLEXBUILDER_PARAMETERS and FND_FLEX_VALIDATION_RULES, linking it to descriptive flexfield context-sensitive segments and cross-validation rules, respectively.
-
Table: FND_ID_FLEX_SEGMENTS
12.1.1
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_ID_FLEX_SEGMENTS, object_name:FND_ID_FLEX_SEGMENTS, status:VALID, product: FND - Application Object Library , description: Key flexfield segments setup information and correspondences between table columns and key flexfield segments , implementation_dba_data: APPLSYS.FND_ID_FLEX_SEGMENTS ,
-
Table: FND_ID_FLEX_SEGMENTS
12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_ID_FLEX_SEGMENTS, object_name:FND_ID_FLEX_SEGMENTS, status:VALID, product: FND - Application Object Library , description: Key flexfield segments setup information and correspondences between table columns and key flexfield segments , implementation_dba_data: APPLSYS.FND_ID_FLEX_SEGMENTS ,
-
APPS.FUN_TRX_ENTRY_UTIL dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_ACCESS_SETS_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FV_AP_CASH_POS_DTL_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GHR_PD_COVERSHEET_DATA dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.JA_AU_FA_BAL_CHG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FA_RX_SHARED_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_GLXRLSEG_XMLP_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_SECURITY_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FND_FLEX_VAL_API dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.BIS_VG_UTIL dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.PSB_POSITIONS_PVT dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FV_CFS_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_BIS_ALERTS_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.INVCIINT dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.HR_POSITION_API dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_AFF_AWC_API_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FII_BUDGET_INTERFACE_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FV_FACTS_TRX_REGISTER dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FND_FLEX_SERVER1 dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.OKL_ACCOUNTING_UTIL dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FARX_TAX_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.OKL_REPORT_PVT dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_GLCOAM_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.HR_ASSIGNMENT_API dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.PAY_COSTING_KFF_UTIL_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_FLEXFIELDS_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.PQH_GEN_FORM dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FA_RX_FLEX_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.PA_PROJECT_ASSETS_PUB dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.PAY_SG_IRAS_ARCHIVE dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FUN_BAL_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.GL_CALCULATE_TAX2_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.POR_APPRV_WF_UTIL_GRP dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.HR_GRADE_API dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.JA_CN_UTILITY dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FA_RECLASS_UTIL_PVT dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.FV_FACTS1_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.1.1
-
APPS.CSE_ASSET_UTIL_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.GMF_FND_GET_SEGMENT_VAL dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.HR_KFLEX_UTILITY dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.HR_API dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.PQH_GL_POSTING dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.GL_CI_REMOTE_INVOKE_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.JA_CN_ACC_JE_ITEMIZATION_PKG dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.ZX_TDS_RULE_BASE_DETM_PVT dependencies on FND_ID_FLEX_SEGMENTS
12.2.2
-
APPS.GML_PO_GLDIST dependencies on FND_ID_FLEX_SEGMENTS
12.2.2