SA Error Rev

In Scope

Technical: SA_ERROR_REV | ID: OR-MFCS-SA_ERROR_REV

Stores a record for every modification of an error generated during the automated audit process.

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

Field Definitions(21)

Rules & Considerations(60)

Sample Load Data(4)

_scenario	DAYR	STORER	REV_NOR	REC_TYPER	UPDATE_IDR	ERROR_CODERPK	TRAN_SEQ_NOPK	ERROR_SEQ_NORPK	HQ_OVERRIDE_INDR	UPDATE_DATETIMER	STORE_DAY_SEQ_NORPK	STORE_OVERRIDE_INDR	ORIG_CC_NO	ORIG_VALUE	KEY_VALUE_1	KEY_VALUE_2	KEY_VALUE_3	TRAN_REV_NO	TOTAL_SEQ_NO	VALUE_REV_NO	BAL_GROUP_SEQ_NO
default	001	1001	002	SA Error Rev-001	MIG_USER	STD-SA_ERROR-001	2	2	SA Error Rev-001	2026-01-01	2	SA Error Rev-001	SA Error Rev-001	SA Error Rev-001	0001	0001	0001	002	2	002	2

default

DAYR: 001
STORER: 1001
REV_NOR: 002
REC_TYPER: SA Error Rev-001
UPDATE_IDR: MIG_USER
ERROR_CODERPK: STD-SA_ERROR-001
TRAN_SEQ_NOPK: 2
ERROR_SEQ_NORPK: 2
HQ_OVERRIDE_INDR: SA Error Rev-001
UPDATE_DATETIMER: 2026-01-01
STORE_DAY_SEQ_NORPK: 2
STORE_OVERRIDE_INDR: SA Error Rev-001
ORIG_CC_NO: SA Error Rev-001
ORIG_VALUE: SA Error Rev-001
KEY_VALUE_1: 0001
KEY_VALUE_2: 0001
KEY_VALUE_3: 0001
TRAN_REV_NO: 002
TOTAL_SEQ_NO: 2
VALUE_REV_NO: 002
BAL_GROUP_SEQ_NO: 2

SA Error Rev | undefined | Oracle Retail