Address Custom Flex Attribute Extension
In ScopeTechnical: ADDR_CFA_EXT | ID: OR-FND-ADDR_CFA_EXT-ADDRESS_CUSTOM_FLEX_ATTRIBUTE_EXTENSION
This is the custom attribute extension table for the entity ADDR.
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
- ADDR_CFA_EXT
Field Definitions(5)
Rules & Considerations(33)
constraint
validation
Sample Load Data(4)
| _scenario | ADDR_KEYRPK | GROUP_IDRPK | DATE_21 | DATE_22 | DATE_23 | DATE_24 | DATE_25 | CREATE_ID | NUMBER_11 | NUMBER_12 | NUMBER_13 | NUMBER_14 | NUMBER_15 | NUMBER_16 | NUMBER_17 | NUMBER_18 | NUMBER_19 | NUMBER_20 | VARCHAR2_1 | VARCHAR2_2 | VARCHAR2_3 | VARCHAR2_4 | VARCHAR2_5 | VARCHAR2_6 | VARCHAR2_7 | VARCHAR2_8 | VARCHAR2_9 | LAST_UPD_ID | VARCHAR2_10 | CREATE_DATETIME | LAST_UPD_DATETIME |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | 1 | 1 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | 2026-01-01 | SAMPLE | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | 2026-01-01 |
| default | 3 | 1000000003 | 2026-01-03 | 2026-01-03 | 2026-01-03 | 2026-01-03 | 2026-01-03 | APP_USER_ID | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | 3 | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | Addr Cfa Ext-002-ALT | APP_USER_ID | Addr Cfa Ext-002-ALT | 2026-01-03 | 2026-01-03 |
| default | 5 | 1000000005 | 2026-01-05 | 2026-01-05 | 2026-01-05 | 2026-01-05 | 2026-01-05 | USERENV | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | 5 | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | Addr Cfa Ext-003-EDGE | USERENV | Addr Cfa Ext-003-EDGE | 2026-01-05 | 2026-01-05 |
Example values from field definitions
- ADDR_KEYRPK
- 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
- ADDR_KEYRPK
- 3
- 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
- Addr Cfa Ext-002-ALT
- VARCHAR2_2
- Addr Cfa Ext-002-ALT
- VARCHAR2_3
- Addr Cfa Ext-002-ALT
- VARCHAR2_4
- Addr Cfa Ext-002-ALT
- VARCHAR2_5
- Addr Cfa Ext-002-ALT
- VARCHAR2_6
- Addr Cfa Ext-002-ALT
- VARCHAR2_7
- Addr Cfa Ext-002-ALT
- VARCHAR2_8
- Addr Cfa Ext-002-ALT
- VARCHAR2_9
- Addr Cfa Ext-002-ALT
- LAST_UPD_ID
- APP_USER_ID
- VARCHAR2_10
- Addr Cfa Ext-002-ALT
- CREATE_DATETIME
- 2026-01-03
- LAST_UPD_DATETIME
- 2026-01-03
default
- ADDR_KEYRPK
- 5
- 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
- Addr Cfa Ext-003-EDGE
- VARCHAR2_2
- Addr Cfa Ext-003-EDGE
- VARCHAR2_3
- Addr Cfa Ext-003-EDGE
- VARCHAR2_4
- Addr Cfa Ext-003-EDGE
- VARCHAR2_5
- Addr Cfa Ext-003-EDGE
- VARCHAR2_6
- Addr Cfa Ext-003-EDGE
- VARCHAR2_7
- Addr Cfa Ext-003-EDGE
- VARCHAR2_8
- Addr Cfa Ext-003-EDGE
- VARCHAR2_9
- Addr Cfa Ext-003-EDGE
- LAST_UPD_ID
- USERENV
- VARCHAR2_10
- Addr Cfa Ext-003-EDGE
- CREATE_DATETIME
- 2026-01-05
- LAST_UPD_DATETIME
- 2026-01-05
Rule Validation Summary
- Source Rule Count
- 38
- Governed Rule Count
- 33