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
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.