Organisation Unit
In ScopeTechnical: ORG_UNIT | ID: OR-FND-ORG_UNIT-ORGANISATION_UNIT
This table will hold the oracle organizational unit values.
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
- ORG_UNIT
Field Definitions(5)
Rules & Considerations(14)
validation
constraint
Sample Load Data(4)
| _scenario | CREATE_IDR | DESCRIPTIONR | ORG_UNIT_IDRPK | CREATE_DATETIMER | EXTERNAL_REF_ID | SET_OF_BOOKS_ID | EXTERNAL_REF_NAME |
|---|---|---|---|---|---|---|---|
| Example values from field definitions | SAMPLE | SAMPLE | 1 | 2026-01-01 | SAMPLE | 1 | SAMPLE |
| default | C LIENT_INFO | Org Unit-002-ALT | 1000000003 | 2026-01-03 | ALT-ORG_UNIT-002 | 1000000003 | Org Unit Secondary |
| default | USE RENV | Org Unit-003-EDGE | 1000000005 | 2026-01-05 | EDGE-ORG_UNIT-003 | 1000000005 | Org Unit Core |
Example values from field definitions
- CREATE_IDR
- SAMPLE
- DESCRIPTIONR
- SAMPLE
- ORG_UNIT_IDRPK
- 1
- CREATE_DATETIMER
- 2026-01-01
- EXTERNAL_REF_ID
- SAMPLE
- SET_OF_BOOKS_ID
- 1
- EXTERNAL_REF_NAME
- SAMPLE
default
- CREATE_IDR
- C LIENT_INFO
- DESCRIPTIONR
- Org Unit-002-ALT
- ORG_UNIT_IDRPK
- 1000000003
- CREATE_DATETIMER
- 2026-01-03
- EXTERNAL_REF_ID
- ALT-ORG_UNIT-002
- SET_OF_BOOKS_ID
- 1000000003
- EXTERNAL_REF_NAME
- Org Unit Secondary
default
- CREATE_IDR
- USE RENV
- DESCRIPTIONR
- Org Unit-003-EDGE
- ORG_UNIT_IDRPK
- 1000000005
- CREATE_DATETIMER
- 2026-01-05
- EXTERNAL_REF_ID
- EDGE-ORG_UNIT-003
- SET_OF_BOOKS_ID
- 1000000005
- EXTERNAL_REF_NAME
- Org Unit Core
Rule Validation Summary
- Source Rule Count
- 18
- Governed Rule Count
- 14