Store Custom Flex Attribute Extension

In Scope

Technical: STORE_CFA_EXT | ID: OR-FND-STORE_CFA_EXT-STORE_CUSTOM_FLEX_ATTRIBUTE_EXTENSION

This is the custom attribute extension table for the entity STORE.

See how this object fits into Foundation Data

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Sequencing
Stage 2
Typical Sources
ERPLegacy

Classification

Object Type
dictionary

Target Structure

Load Approach
Table
Target Objects
STORE_CFA_EXT

Field Definitions(5)

Rules & Considerations(32)

validation

constraint

Sample Load Data(4)

Example values from field definitions

STORERPK
1
GROUP_IDRPK
1
DATE_21
2026-01-01
DATE_22
2026-01-01
DATE_23
2026-01-01
DATE_24
2026-01-01
DATE_25
2026-01-01
CREATE_ID
SAMPLE
NUMBER_11
1
NUMBER_12
1
NUMBER_13
1
NUMBER_14
1
NUMBER_15
1
NUMBER_16
1
NUMBER_17
1
NUMBER_18
1
NUMBER_19
1
NUMBER_20
1
VARCHAR2_1
SAMPLE
VARCHAR2_2
SAMPLE
VARCHAR2_3
SAMPLE
VARCHAR2_4
SAMPLE
VARCHAR2_5
SAMPLE
VARCHAR2_6
SAMPLE
VARCHAR2_7
SAMPLE
VARCHAR2_8
SAMPLE
VARCHAR2_9
SAMPLE
LAST_UPD_ID
SAMPLE
VARCHAR2_10
SAMPLE
CREATE_DATETIME
2026-01-01
LAST_UPD_DATETIME
2026-01-01

default

STORERPK
1003
GROUP_IDRPK
1000000003
DATE_21
2026-01-03
DATE_22
2026-01-03
DATE_23
2026-01-03
DATE_24
2026-01-03
DATE_25
2026-01-03
CREATE_ID
APP_USER_ID
NUMBER_11
3
NUMBER_12
3
NUMBER_13
3
NUMBER_14
3
NUMBER_15
3
NUMBER_16
3
NUMBER_17
3
NUMBER_18
3
NUMBER_19
3
NUMBER_20
3
VARCHAR2_1
Store Cfa Ext-002-ALT
VARCHAR2_2
Store Cfa Ext-002-ALT
VARCHAR2_3
Store Cfa Ext-002-ALT
VARCHAR2_4
Store Cfa Ext-002-ALT
VARCHAR2_5
Store Cfa Ext-002-ALT
VARCHAR2_6
Store Cfa Ext-002-ALT
VARCHAR2_7
Store Cfa Ext-002-ALT
VARCHAR2_8
Store Cfa Ext-002-ALT
VARCHAR2_9
Store Cfa Ext-002-ALT
LAST_UPD_ID
APP_USER_ID
VARCHAR2_10
Store Cfa Ext-002-ALT
CREATE_DATETIME
2026-01-03
LAST_UPD_DATETIME
2026-01-03

default

STORERPK
1005
GROUP_IDRPK
1000000005
DATE_21
2026-01-05
DATE_22
2026-01-05
DATE_23
2026-01-05
DATE_24
2026-01-05
DATE_25
2026-01-05
CREATE_ID
USERENV
NUMBER_11
5
NUMBER_12
5
NUMBER_13
5
NUMBER_14
5
NUMBER_15
5
NUMBER_16
5
NUMBER_17
5
NUMBER_18
5
NUMBER_19
5
NUMBER_20
5
VARCHAR2_1
Store Cfa Ext-003-EDGE
VARCHAR2_2
Store Cfa Ext-003-EDGE
VARCHAR2_3
Store Cfa Ext-003-EDGE
VARCHAR2_4
Store Cfa Ext-003-EDGE
VARCHAR2_5
Store Cfa Ext-003-EDGE
VARCHAR2_6
Store Cfa Ext-003-EDGE
VARCHAR2_7
Store Cfa Ext-003-EDGE
VARCHAR2_8
Store Cfa Ext-003-EDGE
VARCHAR2_9
Store Cfa Ext-003-EDGE
LAST_UPD_ID
USERENV
VARCHAR2_10
Store Cfa Ext-003-EDGE
CREATE_DATETIME
2026-01-05
LAST_UPD_DATETIME
2026-01-05

Rule Validation Summary

Source Rule Count
42
Governed Rule Count
32