Allocations Created
In ScopeTechnical: ALC_ALLOC | ID: OR-ALLOC-ALC_ALLOC-ACTUAL_LANDED_COST_ALLOCATION
Stores a record for all allocations created within oracle retail allocation. this table is the primary place for header level allocation information.
See how this object fits into Allocations
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
- ALC_ALLOC
Field Definitions(5)
Rules & Considerations(41)
constraint
validation
Sample Load Data(4)
| _scenario | STATUSR | ALLOC_IDRPK | PROCESS_STATUSR | TYPE | CONTEXT | PARENT_ID | PROMOTION | ALLOC_DESC | CREATED_BY | EXT_REF_ID | PROMO_DESC | CREATED_DATE | ALLOC_COMMENT | LAST_UPDATED_BY | LAST_UPDATE_DATE | PARENT_ALLOCATION | MLD_APPROVAL_LEVEL | MLD_MODIFIED_LEVEL | RULE_TEMPLATE_NAME | AUTO_QTY_LIMITS_IND | DEAGGREGATED_FASHION | LOCATION_TEMPLATE_NAME | NEVER_UPDATE_GROUP_IND | ENFORCE_WH_STORE_REL_IND | NON_SELL_FASHION_PACK_ONL | NON_SELL_FASHION_PACK_ONLY | RELEASE_DATE_FROM_IN_STORE_IND | LAST_UPDATE_DATEYTIMESTAMP(6)1123LAST_UPDATED_BY |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| Example values from field definitions | SA | 1 | SA | SAMPL | SAMPLE | 1 | 1 | SAMPLE | SAMPLE | SAMPLE | SAMPLE | 2026-01-01 | SAMPLE | SAMPLE | 2026-01-01 12:00:00.000000 | S | SA | SA | SAMPLE | S | S | SAMPLE | S | S | SA | SA | S | SAMPLE |
| default | PE | 1000000003 | PE | SA | Alc Alloc- | 1000000003 | 3 | Alc Alloc-002-ALT | Alc Alloc-002-ALT | ALT-ALC_ALLOC-002 | Alc Alloc-002-ALT | 2026-01-03 | Alc Alloc-002-ALT | — | — | A | Al | Al | Alc Alloc Secondary | N | A | Alc Alloc Secondary | N | n | N | — | 2 | 2026-01-02-ALT |
| default | AC | 1000000005 | AC | SA | Alc Alloc- | 1000000005 | 5 | Alc Alloc-003-EDGE | Alc Alloc-003-EDGE | EDGE-ALC_ALLOC-003 | Alc Alloc-003-EDGE | 2026-01-05 | Alc Alloc-003-EDGE | — | — | A | Al | Al | Alc Alloc Core | N | A | Alc Alloc Core | N | y | N | — | 2 | 2026-01-03-EDGE |
Example values from field definitions
- STATUSR
- SA
- ALLOC_IDRPK
- 1
- PROCESS_STATUSR
- SA
- TYPE
- SAMPL
- CONTEXT
- SAMPLE
- PARENT_ID
- 1
- PROMOTION
- 1
- ALLOC_DESC
- SAMPLE
- CREATED_BY
- SAMPLE
- EXT_REF_ID
- SAMPLE
- PROMO_DESC
- SAMPLE
- CREATED_DATE
- 2026-01-01
- ALLOC_COMMENT
- SAMPLE
- LAST_UPDATED_BY
- SAMPLE
- LAST_UPDATE_DATE
- 2026-01-01 12:00:00.000000
- PARENT_ALLOCATION
- S
- MLD_APPROVAL_LEVEL
- SA
- MLD_MODIFIED_LEVEL
- SA
- RULE_TEMPLATE_NAME
- SAMPLE
- AUTO_QTY_LIMITS_IND
- S
- DEAGGREGATED_FASHION
- S
- LOCATION_TEMPLATE_NAME
- SAMPLE
- NEVER_UPDATE_GROUP_IND
- S
- ENFORCE_WH_STORE_REL_IND
- S
- NON_SELL_FASHION_PACK_ONL
- SA
- NON_SELL_FASHION_PACK_ONLY
- SA
- RELEASE_DATE_FROM_IN_STORE_IND
- S
- LAST_UPDATE_DATEYTIMESTAMP(6)1123LAST_UPDATED_BY
- SAMPLE
default
- STATUSR
- PE
- ALLOC_IDRPK
- 1000000003
- PROCESS_STATUSR
- PE
- TYPE
- SA
- CONTEXT
- Alc Alloc-
- PARENT_ID
- 1000000003
- PROMOTION
- 3
- ALLOC_DESC
- Alc Alloc-002-ALT
- CREATED_BY
- Alc Alloc-002-ALT
- EXT_REF_ID
- ALT-ALC_ALLOC-002
- PROMO_DESC
- Alc Alloc-002-ALT
- CREATED_DATE
- 2026-01-03
- ALLOC_COMMENT
- Alc Alloc-002-ALT
- LAST_UPDATED_BY
- —
- LAST_UPDATE_DATE
- —
- PARENT_ALLOCATION
- A
- MLD_APPROVAL_LEVEL
- Al
- MLD_MODIFIED_LEVEL
- Al
- RULE_TEMPLATE_NAME
- Alc Alloc Secondary
- AUTO_QTY_LIMITS_IND
- N
- DEAGGREGATED_FASHION
- A
- LOCATION_TEMPLATE_NAME
- Alc Alloc Secondary
- NEVER_UPDATE_GROUP_IND
- N
- ENFORCE_WH_STORE_REL_IND
- n
- NON_SELL_FASHION_PACK_ONL
- N
- NON_SELL_FASHION_PACK_ONLY
- —
- RELEASE_DATE_FROM_IN_STORE_IND
- 2
- LAST_UPDATE_DATEYTIMESTAMP(6)1123LAST_UPDATED_BY
- 2026-01-02-ALT
default
- STATUSR
- AC
- ALLOC_IDRPK
- 1000000005
- PROCESS_STATUSR
- AC
- TYPE
- SA
- CONTEXT
- Alc Alloc-
- PARENT_ID
- 1000000005
- PROMOTION
- 5
- ALLOC_DESC
- Alc Alloc-003-EDGE
- CREATED_BY
- Alc Alloc-003-EDGE
- EXT_REF_ID
- EDGE-ALC_ALLOC-003
- PROMO_DESC
- Alc Alloc-003-EDGE
- CREATED_DATE
- 2026-01-05
- ALLOC_COMMENT
- Alc Alloc-003-EDGE
- LAST_UPDATED_BY
- —
- LAST_UPDATE_DATE
- —
- PARENT_ALLOCATION
- A
- MLD_APPROVAL_LEVEL
- Al
- MLD_MODIFIED_LEVEL
- Al
- RULE_TEMPLATE_NAME
- Alc Alloc Core
- AUTO_QTY_LIMITS_IND
- N
- DEAGGREGATED_FASHION
- A
- LOCATION_TEMPLATE_NAME
- Alc Alloc Core
- NEVER_UPDATE_GROUP_IND
- N
- ENFORCE_WH_STORE_REL_IND
- y
- NON_SELL_FASHION_PACK_ONL
- N
- NON_SELL_FASHION_PACK_ONLY
- —
- RELEASE_DATE_FROM_IN_STORE_IND
- 2
- LAST_UPDATE_DATEYTIMESTAMP(6)1123LAST_UPDATED_BY
- 2026-01-03-EDGE
Rule Validation Summary
- Source Rule Count
- 57
- Governed Rule Count
- 41