Supplier Item Country Dim

In Scope

Technical: SUPPLIER_ITEM_COUNTRY_DIM | ID: OR-SIOCS-SUPPLIER_ITEM_COUNTRY_DIM

this table will hold dimensions for each item/supplier/country/dim_object combination.

See how this object fits into Store Operations

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
SUPPLIER_ITEM_COUNTRY_DIM

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 SUPPLIER_ITEM_COUNTRY_DIM can be established cleanly. Sequence this object with its store operations peers so SIOCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail SIOCS documentation.)

Cutover

Load during Stage 2 / .

Data Governance

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

Field Definitions (15)

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 SUPPLIER_ITEM_COUNTRY_DIM can be established cleanly. Sequence this object with its store operations peers so SIOCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail SIOCS documentation.)