Alc Code Detail

In Scope

Technical: ALC_CODE_DETAIL | ID: OR-RACS-ALC_CODE_DETAIL

Stores the code and decoded descriptions for each code type defined in the alc_code_head table. this table will have a foreign key constraint back to the code_type on the alc_code_head table.

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_CODE_DETAIL

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_CODE_DETAIL 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 (5)

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_CODE_DETAIL 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.)