SA Error Hist
In ScopeTechnical: SA_ERROR_HIST | ID: OR-MFCS-SA_ERROR_HIST
Captures processing errors, validation failures, or exception details for SA error hist in Oracle Retail Merchandising. Used to support investigation, reconciliation, reprocessing, and operational issue resolution.
See how this object fits into Sales Audit
Review the broader sequencing and dependencies for this domain
Migration Details
- Complexity
- Medium
- Sequencing
- Stage 2
- Typical Sources
- ERPLegacy
Target Structure
- Load Approach
- Table
- Target Objects
- SA_ERROR_HIST
Field Definitions(19)
Rules & Considerations(52)
Sample Load Data(4)
| _scenario | DAYR | STORER | REC_TYPER | UPDATE_IDR | ERROR_CODER | ERROR_SEQ_NOR | HQ_OVERRIDE_INDR | UPDATE_DATETIMER | STORE_DAY_SEQ_NOR | HIST_WRITTEN_DATER | STORE_OVERRIDE_INDR | ORIG_CC_NO | ORIG_VALUE | KEY_VALUE_1 | KEY_VALUE_2 | KEY_VALUE_3 | TRAN_SEQ_NO | TOTAL_SEQ_NO | BAL_GROUP_SEQ_NO |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| default | 001 | 1001 | SA Error Hist-001 | MIG_USER | STD-SA_ERROR-001 | 2 | SA Error Hist-001 | 2026-01-01 | 2 | 2026-01-01 | SA Error Hist-001 | SA Error Hist-001 | SA Error Hist-001 | 0001 | 0001 | 0001 | 2 | 2 | 2 |
default
- DAYR
- 001
- STORER
- 1001
- REC_TYPER
- SA Error Hist-001
- UPDATE_IDR
- MIG_USER
- ERROR_CODER
- STD-SA_ERROR-001
- ERROR_SEQ_NOR
- 2
- HQ_OVERRIDE_INDR
- SA Error Hist-001
- UPDATE_DATETIMER
- 2026-01-01
- STORE_DAY_SEQ_NOR
- 2
- HIST_WRITTEN_DATER
- 2026-01-01
- STORE_OVERRIDE_INDR
- SA Error Hist-001
- ORIG_CC_NO
- SA Error Hist-001
- ORIG_VALUE
- SA Error Hist-001
- KEY_VALUE_1
- 0001
- KEY_VALUE_2
- 0001
- KEY_VALUE_3
- 0001
- TRAN_SEQ_NO
- 2
- TOTAL_SEQ_NO
- 2
- BAL_GROUP_SEQ_NO
- 2