Alc Item Source

In Scope

Technical: ALC_ITEM_SOURCE | ID: OR-RACS-ALC_ITEM_SOURCE

Stores the item source information used to create the allocation. a unique record for each item/wh/purchase order/release date will be available on this table, this resembles the selections made by the user on the item search page.

See how this object fits into Allocations

Review the broader sequencing and dependencies for this domain

Migration Details

Complexity
Medium
Stage
Stage 2
Cutover Wave
Dependency Level

Dependencies

No dependencies

Target Structure

Load API
Table
Target Objects
ALC_ITEM_SOURCE

Implementation Considerations

Use Cases

Initial load, rehearsal loads, cutover

Sequencing

Load during Open Transactions to stage transactional records only after prerequisite master data and opening positions are stable. Load once prerequisite cross-domain reference data is available so ALC_ITEM_SOURCE can be established cleanly. Sequence this object with its allocations peers so RACS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail RACS documentation.)

Cutover

Load during Stage 2 / .

Data Governance

Requires business ownership and source-to-target crosswalk governance.

Field Definitions (28)

Typical Source Systems

ERPLegacy

Notes

Load during Open Transactions to stage transactional records only after prerequisite master data and opening positions are stable. Load once prerequisite cross-domain reference data is available so ALC_ITEM_SOURCE can be established cleanly. Sequence this object with its allocations peers so RACS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail RACS documentation.)