SA Store Day Write Lock
In ScopeTechnical: SA_STORE_DAY_WRITE_LOCK | ID: OR-MFCS-SA_STORE_DAY_WRITE_LOCK
Stores records for all write locks on store/days currently held in Sales Audit. All updating of this table in the system is handled by functions store_day_attrib_sql.get_lock and store_day_attrib_sql.release_lock.
See how this object fits into Sales Audit
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
- SA_STORE_DAY_WRITE_LOCK
Implementation Considerations
Use Cases
Initial load, rehearsal loads, cutover
Sequencing
Load during Master Data to establish foundational reference data before dependent setup or transactional loads. Load once prerequisite cross-domain reference data is available so SA_STORE_DAY_WRITE_LOCK can be established cleanly. Sequence this object with its sales audit peers so MFCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail MFCS documentation.)
Cutover
Load during Stage 2 / .
Data Governance
Requires business ownership and source-to-target crosswalk governance.
Field Definitions (1)
Typical Source Systems
Notes
Load during Master Data to establish foundational reference data before dependent setup or transactional loads. Load once prerequisite cross-domain reference data is available so SA_STORE_DAY_WRITE_LOCK can be established cleanly. Sequence this object with its sales audit peers so MFCS processing can consume it without synthetic defaults. (Inferred from vendor object description, current scope dependencies, and Oracle Retail MFCS documentation.)