Search Results fnd_id_flexs
The FND_ID_FLEXS table in Oracle E-Business Suite (EBS) 12.1.1 or 12.2.2 is a fundamental repository for storing metadata related to Key Flexfields (KFFs), which are customizable data structures used to capture and organize business-specific information. This table serves as the central definition point for all flexfields in the system, providing essential configuration details that determine how flexfields behave across various modules. Below is a detailed analysis of its structure, purpose, and significance in Oracle EBS.
Purpose and Role
Key Flexfields (KFFs) enable organizations to tailor Oracle EBS to their unique business requirements by defining custom data segments. Examples include Accounting Flexfield (GL#), Item Categories, and Location Flexfield. The FND_ID_FLEXS table stores high-level metadata about these flexfields, such as their application context, structure, and validation rules. It acts as a parent table to other flexfield-related tables like FND_ID_FLEX_STRUCTURES and FND_SEGMENT_ATTRIBUTES.Key Columns and Structure
The table comprises critical columns that define flexfield properties:- APPLICATION_ID: Links the flexfield to a specific Oracle EBS application (e.g., GL for General Ledger).
- ID_FLEX_CODE: A unique identifier for the flexfield (e.g., 'GL#' for Accounting Flexfield).
- ID_FLEX_NUM: Distinguishes between multiple structures of the same flexfield.
- ENABLED_FLAG: Indicates whether the flexfield is active (Y/N).
- FREEZE_FLEX_DEFINITION_FLAG: Locks the flexfield definition to prevent modifications.
- DYNAMIC_INSERTS_ALLOWED_FLAG: Controls whether dynamic combinations can be created.
- SHORTHAND_ENABLED_FLAG: Enables shorthand entry for segment values.
- CROSS_VALIDATION_FLAG: Determines if cross-segment validation rules are enforced.
Relationships with Other Tables
The FND_ID_FLEXS table integrates with several related tables to manage flexfield behavior:- FND_ID_FLEX_STRUCTURES: Defines segment structures and their order.
- FND_SEGMENTS: Stores individual segment details like prompts and lengths.
- FND_FLEX_VALIDATION_RULES: Contains validation rules for segment values.
Functional Significance
This table is pivotal for:- Flexfield Setup: Administrators use it to configure flexfields during implementation.
- Data Integrity: Ensures consistent validation and storage of flexfield data.
- Performance: Optimizes flexfield rendering and validation in forms and reports.
Technical Considerations
In Oracle EBS 12.2.2, the table remains largely unchanged from 12.1.1, but performance enhancements in the underlying database may affect queries. Customizations or extensions to flexfields often involve this table, requiring careful management during upgrades or patches.Conclusion
The FND_ID_FLEXS table is a cornerstone of Oracle EBS's flexibility, enabling organizations to adapt the system to complex business needs. Its metadata-driven design ensures consistency across modules while supporting extensive customization. Understanding its structure and relationships is essential for effective EBS administration and development.-
Table: FND_ID_FLEXS
12.1.1
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_ID_FLEXS, object_name:FND_ID_FLEXS, status:VALID, product: FND - Application Object Library , description: Registration information about key flexfields , implementation_dba_data: APPLSYS.FND_ID_FLEXS ,
-
Table: FND_ID_FLEXS
12.2.2
owner:APPLSYS, object_type:TABLE, fnd_design_data:FND.FND_ID_FLEXS, object_name:FND_ID_FLEXS, status:VALID, product: FND - Application Object Library , description: Registration information about key flexfields , implementation_dba_data: APPLSYS.FND_ID_FLEXS ,
-
APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_ID_FLEXS
12.1.1
-
APPS.AK_REGION_PVT dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_SERVER2 dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_WORKFLOW dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_SERVER dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_ID_FLEX_SEGMENTS_PKG dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_ID_FLEX_STRUCTURES_PKG dependencies on FND_ID_FLEXS
12.2.2
-
APPS.HXC_RESOURCE_RULES_UTILS dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_WORKFLOW dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEXS
12.1.1
-
APPS.AZ_FLEX_COMPILER dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_VAL_API dependencies on FND_ID_FLEXS
12.1.1
-
APPS.HXC_RESOURCE_RULES_UTILS dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_DIAGNOSE dependencies on FND_ID_FLEXS
12.2.2
-
APPS.HR_ID_FLEX_INFO dependencies on FND_ID_FLEXS
12.2.2
-
APPS.JA_JAAUFREV_XMLP_PKG dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_EXT dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_ID_FLEX_STRUCTURES_PKG dependencies on FND_ID_FLEXS
12.1.1
-
APPS.HR_ID_FLEX_INFO dependencies on FND_ID_FLEXS
12.1.1
-
APPS.GL_RX_TRIAL_BALANCE_PKG dependencies on FND_ID_FLEXS
12.1.1
-
APPS.PSB_HR_POPULATE_DATA_PVT dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_DIAGNOSE dependencies on FND_ID_FLEXS
12.1.1
-
APPS.HR_DM_INIT dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_SERVER dependencies on FND_ID_FLEXS
12.1.1
-
APPS.JA_JAAUFREV_XMLP_PKG dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_UPGRADE_UTILITIES dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FV_YE_CLOSE dependencies on FND_ID_FLEXS
12.2.2
-
APPS.AZ_FLEX_COMPILER dependencies on FND_ID_FLEXS
12.2.2
-
APPS.XLA_FLEX_UTIL dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FV_YE_CLOSE dependencies on FND_ID_FLEXS
12.1.1
-
APPS.XLA_FLEX_UTIL dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_LOADER_APIS dependencies on FND_ID_FLEXS
12.1.1
-
APPS.HR_ID_FLEX_INFO dependencies on FND_ID_FLEXS
12.1.1
-
APPS.BIS_VG_TYPES dependencies on FND_ID_FLEXS
12.1.1
-
APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEXS
12.1.1
-
APPS.BIS_VG_TYPES dependencies on FND_ID_FLEXS
12.2.2
-
APPS.JA_AU_FA_BAL_CHG dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_XML_PUBLISHER_APIS dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_KEY_API dependencies on FND_ID_FLEXS
12.2.2
-
APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_ID_FLEXS
12.2.2
-
APPS.GL_CHART_OF_ACCOUNTS_API_PKG dependencies on FND_ID_FLEXS
12.2.2
-
APPS.FND_FLEX_LOADER_APIS dependencies on FND_ID_FLEXS
12.2.2
-
APPS.JA_AU_FA_BAL_CHG dependencies on FND_ID_FLEXS
12.1.1
-
APPS.PSB_HR_EXTRACT_DATA_PVT dependencies on FND_ID_FLEXS
12.1.1
-
APPS.JTF_DIAGNOSTIC_COREAPI dependencies on FND_ID_FLEXS
12.1.1