SA Error Rev Hist

In Scope

Technical: SA_ERROR_REV_HIST | ID: OR-MFCS-SA_ERROR_REV_HIST

Captures processing errors, validation failures, or exception details for SA error rev 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_REV_HIST

Field Definitions(22)

Rules & Considerations(59)

Sample Load Data(4)

_scenario	DAYR	STORER	REV_NOR	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_REV_NO	TRAN_SEQ_NO	TOTAL_SEQ_NO	VALUE_REV_NO	BAL_GROUP_SEQ_NO
default	001	1001	002	SA Error Rev Hist-001	MIG_USER	STD-SA_ERROR-001	2	SA Error Rev Hist-001	2026-01-01	2	2026-01-01	SA Error Rev Hist-001	SA Error Rev Hist-001	SA Error Rev Hist-001	0001	0001	0001	002	2	2	002	2

default

DAYR: 001
STORER: 1001
REV_NOR: 002
REC_TYPER: SA Error Rev Hist-001
UPDATE_IDR: MIG_USER
ERROR_CODER: STD-SA_ERROR-001
ERROR_SEQ_NOR: 2
HQ_OVERRIDE_INDR: SA Error Rev Hist-001
UPDATE_DATETIMER: 2026-01-01
STORE_DAY_SEQ_NOR: 2
HIST_WRITTEN_DATER: 2026-01-01
STORE_OVERRIDE_INDR: SA Error Rev Hist-001
ORIG_CC_NO: SA Error Rev Hist-001
ORIG_VALUE: SA Error Rev Hist-001
KEY_VALUE_1: 0001
KEY_VALUE_2: 0001
KEY_VALUE_3: 0001
TRAN_REV_NO: 002
TRAN_SEQ_NO: 2
TOTAL_SEQ_NO: 2
VALUE_REV_NO: 002
BAL_GROUP_SEQ_NO: 2

All objects